video1.0<iframe src="https://www.loom.com/embed/45933fa8ecb34841b2776a5c685d43b6" frameborder="0" width="1920" height="1440" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>14401920Loomhttps://www.loom.com14401920https://cdn.loom.com/sessions/thumbnails/45933fa8ecb34841b2776a5c685d43b6-bd59026e09beaa7b.gif254.047This 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.