Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 23, 2020 12:12 PM
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?
Sep 23, 2020 12:33 PM
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.
Oct 06, 2021 04:30 AM
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