Table formula calculation vs. Triggered actions. Which one comes first ?

[Johan]

Hi there

I have a table with formula DataType. I want to transfer the result of the formula to another Table via a Triggered Action  ->  This is not working.

So I was wondering if there is a sequence to be respected and if I should perform the formula calulation also in the triggered action ?

Thanks for helping me out on this.

Johan

[NiceDuck]

As I know, the formula comes first before the trigger since it automatically produce value once the record is created even though they are still on the #inserted. 

As for why your workflow does not work, may you please give me a screenshot of trigger as well as the formula you are using?

[Johan]

NiceDuck

Thanks for your post. 

I have redesigend the wrokflow, so I guess this is solved for now.

[cheonsa]

Hi all, 

According to my experience, the trigger is executed first, followed by the formula field. You can recreate the formula in your Trigger so you can copy and save it to other Table.

 

[NiceDuck]

I really think that the formula field runs first.

If you have a formula field on your table and you insert a record on it, the #inserted.Formula_field will already have value which you can use.