Trigger for actions

[BOTFORCE]

Hi friends,

I have an implementation concept question here:

an action can trigger an automation which is nice. The automation will be conducted based on either a scheduled-trigger or on a data change-trigger (Insert, Update, Delete, or a combination of them).

Can I trigger an automation where the trigger-condition only relies on a data change of a single Column Value? Because currently I found out the data-change trigger refers to any attribute of the whole row.

Example:
I want to create an invoice-action. Automation is then to set a value [invoice] = true. Data change trigger whould be on that column vallue. If Iater change also an other attribute from the same row, it also generates an invoice which I do not want.

Thanks,
Robert

[WillowMobileSys · Accepted solution]

Robert:

Can I trigger an automation where the trigger-condition only relies on a data change of a single Column Value ?

Yes. In the trigger condition, there are AppSheet keywords [_THISROW_BEFORE] and [_THISROW_AFTER] you can use to test if a particular column was changed. You can something like this:

[_THISROW_BEFORE].[Column] <> [_THISROW_AFTER].[Column]  

I hope this helps!

[BOTFORCE]

Thank you John!

Was looking for concept quite some time but in front of my nose
Thx. again!
Robert