Is there any way to do A Counter that will increment only if the status is changed to a certain “text”. will remain its count and just keeps on incrementing
We would like to count the all the links that has gone through a certain status.
Counter increments when triggered
+18Hi @Jen_Baguhin - I don’t think you can do this in Airtable on its own. There aren’t any formulas based on when a record changes - the formula will just recalculate on the new status. However, pretty sure you could do this with Zapier:
Airtable on Zapier has two triggers:
If you create a view for the status you want to track then when the status changes it will appear as a new record in this view, e.g. if status is “not started” then it won’t be in the “in progress” view, but when you change the status to “in progress” it will be and will trigger on Zapier.
From there you could use the Zapier actions to update a field in the record (a static number field, for example) or create a new record in a different table to track these status changes:
Airtable isn’t a premium app on Zapier, so potentially you could do this on the free Zaiper tier.
JB
+21Perhaps a variation on this setup I posted will do the trick?
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.