A real-time command center for safety-critical maintenance
A large city and county government's transit maintenance and engineering command center runs a 24/7 operations log in Airtable: nightly schedule imports, blanket sheet generation with set-on and clear tracking, vehicle location logic, on-duty staffing visibility across 11 locations, and automated shift summary and incident notifications. The base replaced static HTML and PDF logs with a live system that enforces safety checks before crews re-energize the system.
The problem
Static PDF logs took hours to compile each night, and an unreliable notification system hid who was on duty across 11 maintenance locations. Paper processes carried a severe safety risk: crews faced electrocution if equipment was re-energized before a section was cleared.
What they built
Maintenance, Dispatch, and Engineering built a 24/7 operations log in Airtable that imports nightly schedules and tracks vehicle set-on and clear times with scripted safe-to-power status. Form check-ins show who is on duty, and shift summaries go out every 8 hours to over 100 recipients.
The outcome
Coordinators and leadership now work from a real-time command center, saving an estimated 40 to 45 minutes a night once spent compiling blanket sheets by hand. Enforced safety checks before re-energizing reduce electrocution risk, and reliable Airtable notifications replaced the unreliable internal server.
Inside the solution
24/7 Maintenance Operations Command Center
Rapid App Development
- CSV import and deduplication via scripts
- Nightly blanket sheet generation with set-on and clear tracking
- Vehicle entry, exit, and safe-to-power status logic
- Form check-in integration for on-duty staffing
- API-driven compliance check flagging missing field documents
- 8-hour shift summary emails and incident notifications
- Static PDF logs taking hours to compile
- An unreliable legacy notification system
- Lack of night visibility into who is where
- Error-prone paper processes with severe safety risk
- Manual spreadsheet transcription
- 40-45 minutes saved nightly producing blanket sheets
- Reduced human error in safety-critical workflows
- Reliable notifications replacing an unreliable internal server
- Real-time visibility into staffing and vehicle locations
- Maintenance crews
- Operations
- Dispatch
- Engineering
- Leadership
- A scheduling system
- A field-form tool
- A workforce scheduling system
24/7 Maintenance Operations Command Center
Run a 24/7 maintenance command center in one base: nightly blanket sheets with set-on and clear tracking, colour-coded safe-to-power logic, live on-duty staffing across eleven locations, and a queue of flagged missing field documents. Automations pre-stage each vehicle set-on log, flip a blanket to safe-to-power the moment a green clear is recorded, and push 8-hour shift summaries and incident alerts by email, while AI columns draft night summaries, incident parsing, and shift handoff notes.
From static PDFs to a live operations log
Copy the templates
Automate the nightly build
Wire up notifications
FAQ
Frequently asked questions
A nightly script imports the CSV schedule, dedupes it against existing records, and pre-creates the next day's blanket entries at a fixed time, replacing the manual compilation that used to take 40 to 45 minutes.
Vehicle set-on and clear times run through color-coded, scripted safe-to-power logic, so a section cannot be marked ready to re-energize until the tracked status confirms it is clear.
Form check-ins feed the same base, so coordinators see who is on duty at every site in real time instead of relying on radio calls or a static roster.
Automated shift summary and incident emails now go out on an 8-hour cadence to more than 100 recipients directly from Airtable, replacing a legacy server that could not be depended on.
Not yet in production. The government is exploring AI for handwriting extraction from field documents and incident parsing as a next step, building on the structured data this command center already captures.