Formulas in Triggered option

[Guasho]

Hi all, it's possible to use formulas (similar to Excel) using a triggered option?

Thanks in advance

[CoopperBackpack]

Hello @Guasho,

First of all, please note, that in Triggers you can use the fields from the  tables.

Also, you may use Functions foк different data types: Text, Number, Date. You may check available functions under each section. 

For example:

You may want to check this article https://howto.caspio.com/tables-and-views/triggered-actions/

Maybe you can use the Formula in the table instead https://howto.caspio.com/tables-and-views/data-types/formula-fields/

Since everything depends on the expected result, you may clarify what exactly you try to achieve.

[autonumber]

Hi! I just want to add this Function Reference HowTo Documentation which gives you a definition of each function that you will use which are listed on the Triggered Action. I hope this will helps. 

https://howto.caspio.com/function-reference/

[NiceDuck]

Depending on what you are trying to do, I would suggest that you just use your trigger to collect the data and store them on fields then you use an actual formula field to do the computation for you. With that, you can control your formulas better than the blocks on the trigger.