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?
Calculated update
+35Unfortunately, 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.
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
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.