Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Calculated update

1109 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Colin_Rathbun
6 - Interface Innovator
6 - Interface Innovator

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