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”.
One way to track the number of times a record has been changed is by setting up a system like this: https://support.airtable.com/hc/en-us/articles/218151657-Using-Zapier-s-Multi-Step-Zaps-to-find-and-...
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, this sounds like a great approach, but I must ask - what is the definition of “change”?
These are each key distinctions that should be known before embarking on any analytics implementation strategy, right?
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.