I have a base that we use for activity management. I want to have a way to count the number of times a date field has been updated. I thought there might be a count() formula that could do this but it only counts current status rather than the number of historical record changes.
Does anyone know a workaround or how to do this? We are trying to see how many times a “Due Date” has been changed, and thus “Missed”.
Airtable is not known for its ability to produce change events. The only way I’ve been able to do this with precision is to continuously poll the data using the API and then snapshotting with date/timestamps so I can sense changes, and then track analytics separately.
What this does is creates a new table within your base. Think of this table like a “backend” or “admin” view. Each time a change is made to your “Frontend” table, the backend table will create a new record with a new timestamp, date field etc.
It’s really simple and straightforward to set up. Try it out?
Okay - that’s a very cool approach - it’s essentially giving us a change list for everything. But, there are some issues that come with this - for example - one formula adjustment to a single column in a table of 15,000 records will trigger a landslide of new “change” records. Imagine changing three fields.