How can I count the number of changes to a specific field and return an integer value?

[Imee_Lee]

Hello, hope someone could help me.

So we have this "Status" field.

The specific status was "active search"

How can I set automation to count how many times that status was moved to active search?

Currently, I have this automation set up:

The main goal here is that:

• When the record was moved to Active Search Status for the second time, the field Count moved to AS should be 2.
• When the record was moved to Active Search Status for the third time, the field Count moved to AS should be 3.

Are there any changes that I need to set up with my current automation? because currently, it would only work when the status was moved for the first time.

Thank you.

[TheTimeSavingCo · Accepted solution]

Hi Imee!

To do this:
1. In your automation's trigger, remove the "Count moved to AS is empty" condition
2. Convert the "Count moved to AS" field to a "Number" field
3. Create a "Formula" field with the formula `{Count moved to AS} + 1`
4. In your automation's "Update Record" action, use the value of the formula field created in step 2 for the field "Count moved to AS"

And that should do what you're looking for!

[RdMedia_srl]

Hi Imee_Lee , I don’t think you can do this in Airtable on its own but you can easily do it with Make.com 

this should be you Airtable table 

You need a "Last modified"  field that will your "trigger" for the Make scenario

this is the configuration, it only "watch" at the "Status" field change

then you will have this simple Make scenario, where will be triggered as soon as the "Status" is changed

than in the next module you update the record with a simple formula

Lastly you have more than one Status you should use a filter like this

Hope this helps

[Imee_Lee]

Thank you, Adam!
It worked!  ⭐ 

[Imee_Lee]

Thank you for this as well Rodolfo 🙂