đ ī¸ System Control Dashboard
Environment: Cloud-Connectedđ Administrator Maintenance & Spreadsheets Guide
Access a friendly, step-by-step catalog guide detailing Google Sheets setups, caller mapping directories, and tips for inserting weekly logs at the top of the spreadsheet to avoid scrolling.
⥠Update Calling Logs
Re-reads the Master spreadsheet's Calling Log tab and updates transaction history records instantly. Do this weekly after new session programs have been added to the cloud sheet.
đ Full System Rebuild
Completely drops and repopulates all tables from scratch (Callers, Dances, Series, and Calling Logs). Use this when adding new callers, series codes, or importing new dances to your Instructions Sheet.
â ī¸ View Sync Errors Table
Inspect the errors logs to identify any misspelled dance names or unregistered callers inputted into the spreadsheets during recent updates.
đī¸ Recreate Tables Schema
Drops and recreates the SQLite database structures completely from scratch, then automatically reloads all data from the Google Sheets. This fully refreshes the schema and spreadsheets in under 2 seconds. You should hardly ever need to run this.