Skip to main content
Skip table of contents

Notes on Custom Pages

Google Sheets

Create a new Google Sheet.

  1. Type a name for the document.

  2. Add 4 columns: [PlayerID], [PlayerName], [TeamName], [Notes].

https://www.loom.com/share/4c801ebf2cf4461cad74eea2c54010b2

Share with TruMedia integrations email

  1. Open the Share Google Sheets menu.

  2. Copy and paste the email address below into the Add people and groups box:

  1. Tap Send and select Share Anyway when prompted.

https://www.loom.com/share/b9c5aee6333240bfa5f43226c50ef306

Copy SpreadsheetID

  1. Copy the SpreadsheetID from the Google Sheets URL.

The spreadsheet id is the characters after /d/ until the next back slash

Custom Page Builder

Create Note component

  1. Open the Custom Page Builder.

  2. Add a Notes component where you want these notes.

https://www.loom.com/share/6da6303ec2584ab0b67623b8cc481adf

Connect Google Sheets to the note component

  1. Select Component Settings > Google Sheets.

  2. Paste the SpreadsheetID in the Spreadsheet ID box.

  3. Open PlayerID Col menu and choose [playerID].

  4. Open Note Col menu and choose [Notes].

https://www.loom.com/share/8f559f278ef34bfdb29ecb9863331085

The Note Col menu tells the computer where to put the notes in this column on the Custom Page.

Add a title for the component

  1. Hover over the component.

  2. Select Component Settings.

  3. Open the Title box and type a title for your graphic.

https://www.loom.com/share/e3aa8e39bbf44ab195d14a48e2846420

Export the team roster

  1. Search a team.

  2. Select the roster page.

  3. Set the Filters and Qualifications to determine which players to include on the roster export.

  4. Export the roster to a .csv file.

https://www.loom.com/share/d79958fd309f4c60aabac2cc585f7ddc

Turn the Display Columns Only setting off.

If it is on, the playerID column will not download.

Add the roster to Google Sheets

  1. Open the .csv file and copy the [playerID] and [playerFullName] columns in the exported .csv file.

  2. Paste them in the Google Sheet.

  3. Add a [TeamName] column in the Google Sheet to organize the players by team.

  4. Write notes for each individual player in their row of the [Notes] column.

https://www.loom.com/share/443d03eaacf34e0a9c97a5a20dbea6f5?sid=a814b36e-3994-4a56-bb02-0f742ac75614

Confirm the notes added on a Custom Page

  1. Search the team on TruMedia

  2. Select the roster page.

  3. Open the Custom Page you created.

  4. Search a player you wrote notes for and confirm they are on the Custom Page.

https://www.loom.com/share/82e8767b0d4f4637bfc73eb1312783c5

Contact Us

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.