Auto-rebuild on Airtable changes and daily schedule

[jakkdl]

Currently the site only rebuilds on deploy, so relative "last updated" dates go stale and Airtable data changes aren't reflected until someone manually triggers a deploy.

Solution: Set up two rebuild triggers pointing at a Vercel deploy hook:

1. GitHub Actions cron — daily rebuild to keep relative dates fresh
2. Airtable automations — one automation per table, triggered on record create/update, calling the deploy hook URL. This way the site rebuilds automatically when content changes.

Setup steps:

• Create a Vercel deploy hook for this project
• Add a GitHub Actions workflow that hits the hook on a daily schedule
• Add Airtable automations for each tracked table (events, map, communities, self-study, jobs, funding, media-channels, advisors, projects, founders)

[written by Claude Code]

[bryceerobertson]

Is this saying that this

doesn't update? If so, I'll get to that in QA. I haven’t done the resource pages yet.

[jakkdl]

yeah, with #307 we've made it so the dates are rendered when the page is built on the server, instead of when the user fetches the page, to reduce render time and avoid any issues with API's.
But there's no mechanism that automatically triggers a rebuild of the pages on the server, other than when we merge a pull request. So we need to rebuild the page once a day so the dates stay correct, and whenever airtable is updated.

I don't fully trust that the suggested steps in the issue description is the exact way to go about this, so if you do tackle it make sure you poke Claude enough to ensure it's a good approach.

[jakkdl]

last-updated should be adressed in #347, ace01be

See #347 (comment)