Use a column change as condition

Mark_11
Participant V

Hi,
is it possible to use a change of value in a certain column as condition to trigger a workflow?
I mean, in a row with a lot of column, i would trigger the workflow if the user change the value of a certain column.
Because i would assume, only in that specific case, he would use an action manually right after saving.
So could be nice to trigger this action.

0 7 1,999
7 REPLIES 7

LeventK
Participant V

@Mark_11
You can use [_THISROW_BEFORE].[ColumnName] <> [_THISROW_AFTER].[ColumnName] as a conditional benchmark for triggering a workflow upon a particular columnโ€™s change of value.

Steve
Participant V

Hello,
i ve used this formula as workflow condition and it works, except it happens it triggers more than once.

this is the workflow condition:
[_THISROW_BEFORE].[Coordinate] <> [_THISROW_AFTER].[Coordinate]

action change data: add a new row to another tableโ€ฆ
i have some workflow with the same rule, for every field i need to.
The clue is to have a historycal record for every change.
I have this issue of duplicate row a few second after the right one

event   -  coordinate  -  weight

โ€œcoordinate changeโ€ - A2 - 650 (this is an unexpected duplicate; coord is still A2)
โ€œweight changeโ€ - A2 - 650
โ€œcoordinate changeโ€ - A2 - 550
โ€œno eventโ€ - A4 - 550

You might want to specifiy an end condition to stop that, such as
AND(
[_THISROW_BEFORE].[Coordinate] <> [_THISROW_AFTER].[Coordinate],
[_THISROW_AFTER].[Coordinate]=3
)

thanks,
what is the reasoning about the condition โ€œ[coordinate]=3โ€ ?

Mark_11
Participant V

iโ€™m going to try,
seems perfect. Thanks

EDIT: Found the Solution for those who might be in the same situation.

So Iโ€™m having the same issue here. Iโ€™m using this formula
[_THISROW_BEFORE].[Aflt_Status1] <> [_THISROW_AFTER].[Aflt_Status1]

Intention is that at refresh of the app, the Spreadsheet formula updates and changes the [Aflt_Status1] value if the flight status changes and that would trigger the BOT to send an sms.

Iโ€™ve verified that the SMS works on a schedule and via Test. But I canโ€™t seem to figure out why it wonโ€™t trigger if the value of the cell changes.

any help would be appreciated here.

Top Labels in this Space