Administrator reference

Schedule guide

How the public schedule works, how to update an event, and what to check when something doesn’t look right.

Open schedule spreadsheet

01

How it works

  1. 1

    An administrator edits the Google Sheet.
    Each row represents one scheduled event.

  2. 2

    Google publishes the sheet as CSV.
    The public CSV contains the same rows and column headers.

  3. 3

    The schedule reads that CSV on every visit.
    Visitors receive current data without rebuilding the Astro site.

02

Add or update an event

Add a new event

  1. Find an existing event row inside the schedule table near the new event’s date.
  2. Insert a row inside the table. On desktop, right-click the row number and choose Insert 1 row above or Insert 1 row below. In the Sheets app, tap the row number and use the insert-above or insert-below action.
  3. Confirm the new row remains inside the table and inherits its formatting or dropdowns. Do not type the event into the first blank row beneath the table; that row may fall outside the published table range.
  4. Fill in the event fields across the new row. If id does not populate automatically, enter a unique value that follows the existing pattern—never reuse another event’s ID.
  5. Use YYYY-MM-DD for dates and a time such as 6:00 PM.
  6. For an unknown time, leave start_time empty and set time_tbd to 1.
  7. Refresh the public schedule and confirm the event card.

The website sorts events by date and time, so the row’s exact position does not control its public order. Inserting it near the correct date simply keeps the spreadsheet easier to maintain.

Edit an existing event

  1. Find the event’s existing row inside the schedule table.
  2. Edit only the applicable cells in that row. Keep its existing id.
  3. Do not rename, remove, or rearrange the header-row columns.
  4. Refresh the public schedule and confirm the updated event card.

Google’s published CSV may take a short time to reflect a saved change. If the old value remains, wait a minute and refresh again.

03

Add a game stream

When a broadcast link becomes available, paste the complete address into the event’s existing stream_url cell. Clear that cell to remove the stream action from the public schedule.

idcel-2627-018 opponent_eventParkway stream_urlhttps://youtube.com/watch?v=example
  • Empty cell: no stream action appears.
  • YouTube link: a red YouTube action appears.
  • Other valid web link: a Watch stream action appears.

04

Common field reference

date

Event date in YYYY-MM-DD format.

start_time

Starting time with AM or PM.

time_tbd

Use 1 for TBD; otherwise use 0.

sport

Basketball, Bowling, Wrestling, Swimming, and so on.

team

Boys, Girls, Combined, or Unspecified.

level

MS, Varsity, JV/Varsity, or Unspecified.

opponent_event

Opponent or meet/tournament name.

home_away

Use Home or Away to power the quick filters.

venue

Optional facility or location detail.

timing_note

Optional note such as “Varsity follows.”

stream_url

Optional full URL for a live broadcast.

ticket_url

Optional full URL for purchasing event tickets.

05

Troubleshooting

A spreadsheet change is not showing.

Confirm the edit was made on the published tab, wait briefly for Google’s CSV cache, and reload the page. Keep the original header names unchanged.

A stream button is missing.

Confirm the header is stream_url and the cell begins with https://. The link must be in the same row as the event.

An event appears under the wrong filter.

Check the exact values in sport, team, level, and home_away. Spelling and capitalization should stay consistent.

The sponsor artwork needs to change.

Replace public/sponsor-banner.svg in the GitHub repository, commit, and push. Unlike spreadsheet edits, this change does trigger a site deployment.

Remember: the published CSV is public. Do not place private contact information, internal notes, credentials, or unannounced sensitive details in published columns.