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.
@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.
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โ ?
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.
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |