We use Airtable to track client projects through multiple phases of work. It’s important for us to know how many projects are in a given phase and to track this distribution over time. I easily created a pivot table block to display how many projects are in a phase at the present time, but this doesn’t help with historical data.
I’m open to depositing our data into Google Sheets to maintain the historical log and create metrics there, but I’m not seeing an automated way to dump out these counts. The only Zapier triggers are based on an update to a view or a new record.
I saw this as a potential route, but would like to avoid creating additional fields and tables in my base to record these “phase counts.”