How toTrigger a Notification when changing a record column to ON, True or Yes?

We need help with this.

We need to add records (meaning a row in a data table)  that we have to edit before is published. The record is shown in a View when a record column Yes/No is changed to Yes. We would also like to trigger a notification, but don't have any idea because if we use updates only  the notification will trigger when an update is done on any column.

Wonder if there is an expresión that can limit to an update in the column Yes/No only?

Thanks,

 

Solved Solved
0 1 48
1 ACCEPTED SOLUTION

In the bot's automation event pane you could set the condition something like 

AND( [_THISROW_BEFORE].[YesNo Column]<>[_THISROW_AFTER].[YesNo Column] , [_THISROW_AFTER].[YesNo Column] )

Please replace [YesNo Column] with the actual name for the yes/no column you have.

Suvrutt_Gurjar_0-1661656731513.png

 

View solution in original post

1 REPLY 1

In the bot's automation event pane you could set the condition something like 

AND( [_THISROW_BEFORE].[YesNo Column]<>[_THISROW_AFTER].[YesNo Column] , [_THISROW_AFTER].[YesNo Column] )

Please replace [YesNo Column] with the actual name for the yes/no column you have.

Suvrutt_Gurjar_0-1661656731513.png

 

Top Labels in this Space