[_THISROW_BEFORE] <> [_THISROW_AFTER]

[StephenSaid]

Is this expression available in Display expression of an Action?

I have a grouped: execute a sequence of actions:

In the second action (Sync) I'm checking for the before and after values of the which are set (or not) in the first action (Ref Set). If true, I am running an action to sync my app.

With this setup it simply doesn't run. If I remove the expression from the Behavior o the Sync action, it works.

[WillowMobileSys]

---

@StephenSaid wrote:

Is this expression available in Display expression of an Action?

---

No, [_THISROW_BEFORE] row state is not available inside of actions.  You should see an error in the Audit log explaining this as the reason the action didn't execute.

I hope this helps!

[StephenSaid]

@WillowMobileSys 

So is there another solution so the actions only runs if the column changed?

[WillowMobileSys]

Yes.  Use a ChangeCounter type column.  Set the initial value to zero, set the column to watch as [checkedOutBy] and the Mode to "Reset".

On each Save of the row, the ChangeCounter will either be:

• zero - no change to the specified column
• 1 - column value changed

Then your action can simply inspect that ChangeCounter = 1.  NOTE: updates made by actions should also reset the ChangeCounter but you should test and confirm - if you have that scenario.

I hope this helps!