Accolade Community Theatre was tracking ticket check-ins on paper — slow, error-prone, and impossible to read in real time. Box office staff needed something they could open on a tablet at the door and use without any training. The app pulls the guest list directly from their existing Google Sheet, so there was no data migration and no new system for the client to manage. Staff tap a name to check someone in. The count updates live.
Design Decisions
Google Sheets as the data layer. Accolade already managed ticket sales there. Rather than migrate their data to a new system, the app connects to the existing sheet via a Google Apps Script endpoint. The client didn't have to change anything about how they sold tickets — the check-in tool just plugged into what was already there.
Performance tabs instead of separate URLs. The production had four show dates and front-of-house staff needed to switch between lists mid-evening as early shows ran long and late-night doors opened. A single URL with tab switching kept everything on one screen. No bookmarks, no confusion about which link to use.
Real-time write-back on every check-in. Each tap writes directly back to the Google Sheet, so the box office manager watching the spreadsheet in the back had a live door count without refreshing anything. The sync status bar at the top tells staff whether the last save succeeded — visible at a glance from across a table.
Designed for speed under pressure. Sorted alphabetically by last name, high contrast, large touch targets. A checked-in row shifts to teal so staff get an immediate visual read of house fill without counting. The whole interface was built to get from name lookup to checked in in under three seconds.
Live Preview
Like what you see?
Let's build something like this for your business.