Chase stale work orders and nudge vendors automatically

Keeps vendors honest on open work orders. Each day it scans the Airtable tracker for jobs that have exceeded their target turnaround, emails each responsible vendor a polite chase with the ticket details, and posts a digest of everything overdue to the facilities channel so the team can intervene on the worst offenders.

Use it once you already track work orders in Airtable and need to stop manually auditing which jobs are aging. Best for teams managing many concurrent vendor tickets where SLA slippage otherwise goes unnoticed.

1. 1A daily schedule triggers the run each morning.
2. 2The workflow queries Airtable for work orders still Open or In Progress past their SLA date.
3. 3A logic step groups the overdue records by assigned vendor.
4. 4Each vendor is emailed a follow-up listing their late ticket numbers and locations.
5. 5A summarized digest of all overdue jobs is posted to the facilities Slack channel for visibility.