Email only if a specific column updated

Val
New Member

I have a table with 10 columns and I need to trigger email only if 10th column “Approval” is changed.

How do I do this? Thank you!

Solved Solved
0 4 377
1 ACCEPTED SOLUTION

For your Workflow Condition, use

[_THISROW_BEFORE].[10th column] <> [_THISROW_AFTER].[10th column]

View solution in original post

4 REPLIES 4

For your Workflow Condition, use

[_THISROW_BEFORE].[10th column] <> [_THISROW_AFTER].[10th column]

Val
New Member

Hi guys,

 

I find myself in a similar scenario, however in my instance the value of the column is updated through the formula (IF(IN([Key],Verification[Maintenance Job Key]),"Verified", "Unverified")) which checks another table for a related record and if that record is added, the status automatically changes from unverified to verified.

Using this row before does not work for me to trigger the email condition, I guess because that the update only option would work if the update happens through the app and not behind the scenes. Any idea how I can fix this?

Please start a new topic for help with this.

Top Labels in this Space