Help

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

Solved
Jump to Solution
1088 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Imee_Lee
6 - Interface Innovator
6 - Interface Innovator

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:

Screenshot 2023-04-18 at 8.01.00 PM.png

 

Screenshot 2023-04-18 at 8.01.27 PM.png

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.

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

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!

See Solution in Thread

4 Replies 4
TheTimeSavingCo
18 - Pluto
18 - Pluto

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
7 - App Architect
7 - App Architect

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 

Schermata 2023-04-18 alle 15.00.21.png

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

Schermata 2023-04-18 alle 14.54.20.png

 

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

Schermata 2023-04-18 alle 15.02.58.png

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

Schermata 2023-04-18 alle 14.56.24.png

 

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

Schermata 2023-04-18 alle 15.06.10.png

Hope this helps

 


Rodolfo - RdMedia

Thank you, Adam!
It worked!   

Thank you for this as well Rodolfo 🙂