How would I have a Yes/No column change to tr...

workflow
(Ryan Callister) #1

How would I have a Yes/No column change to true once I change a value of a single column in the table? I have created an action that changes the value to true and I have that hidden. Then I have a workflow rule that when there is an UPDATES_ONLY data change the DO THIS action is Change Data and the action is the one that changes it to true. What Condition could I use to make it only do it when there is an update only to a certain column?

(Gil Littman [AppSheet]) #2

You can use [_THISROW_BEFORE].[column] <> [_THISROW_AFTER].[column] as condition for the workflow.

help.appsheet.com - Workflow Workflow help.appsheet.com

(Aleksi Alkio) #3

And please remember to use ISNOTBLANK([Column]) as well. Otherwise it will trigger the workflow when you add a new record and the condition is not true.