Oct 03, 2022 10:37 AM
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:
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.
Nov 17, 2022 04:16 AM
Hi, that is quite close what I am looking for. I have questions.
Nov 17, 2022 01:20 PM
The automation will not count the previosly changed records before it was setup. I’m not sure if that was the question tough!
Nov 18, 2022 02:57 AM
Yes that was it. I will use your method from now on. Thanks.