Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Calculated update

Topic Labels: Automations
994 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello. If one of my automated actions is to update a number field, can I make it Calculate the update? IE (Current Field Value) minus (some other value) and put that newly calculated value in the field?

2 Replies 2

Unfortunately, automations can’t currently perform calculations. They also can’t perform conditional statements, although you didn’t ask about that. :slightly_smiling_face:

If you could make your desired value the result of a formula in a formula field, then you could update the number field based on the formula field.

You could also write a custom JavaScript to calculate the value as well.

One interesting thing to note is that the automation platform Integromat DOES allow you to perform math & other transformational functions on your data.

Hi, I tried the suggestions related to update field based on formula field and it seems that it is not allowed to insert formula field into update field in automation. It is true or I did something wrong? I cannot see the “Insert” option for formula field for “Nova hodnota” field. Thank you
Screen Shot 2021-10-06 at 1.29.23 PM