{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/45933fa8ecb34841b2776a5c685d43b6\" frameborder=\"0\" width=\"1920\" height=\"1440\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1440,"width":1920,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1440,"thumbnail_width":1920,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/45933fa8ecb34841b2776a5c685d43b6-bd59026e09beaa7b.gif","duration":254.047,"title":"Airtable Dashboard for Large Scale Project Control","description":"This Loom explains an Airtable system James Fleming built to manage large, multi-site projects with real-time visibility into status, risks, and budget. He describes leading a 13,000 user platform migration across 40 sites in 8 countries and creating the app to quickly answer which projects are on track, at risk, or will miss deadlines. The dashboard color-codes health (green on track, orange-yellow at risk, red-yellow needs attention) and pulls live counts of active tasks and open risks from linked data. A project detail page centralizes related information, while seven linked tables, formulas, rollups, and automations calculate health and notify owners of overdue tasks or critical risks, including budget overrun alerts."}