Hello Everyone!
I’ve been struggling to count the number of times a field is changed in airtable.
For instance, I have a bug tracker table and wanted to control how many times the “status” field is set to “Missing Information”. This is important for process control and have a better SLA with our customers.
I think my solution will work for your similars use cases. My solution is:
- Create a single line text field to receive strings. I named it "Missing Information Reg.;
- Create an automation that tracks when the “Status” field is changed to “Missing Information”
- Make the automation update the “Missing Information Reg.”
3.1 Configure in “Fields” as “Dynamic” and insert the field “Missing Information Reg” and then add a single character, like “1” or dash or whatever you like, as long it’s a single character.
That Automation will then add 1 character every time the “status” field changes to “Missing Information” and it will go like this, as I chose “1” as my added character:
1 then 11 then 111 and so on.
- Add a formula field with LEN({Missing Information Reg}) and you’ll have this field to count how many times that specific record has changed that specific field!
