Automate a notification when a cell in a specific column is changed

[mhower]

Hi All - 

I am having trouble getting a notification to send when a specific column is changed. I have tried [_THISROW_BEFORE].[School] <> [_THISROW_AFTER].[School] where school is the column to look at but it does not seem to work.

Basically, what I need is anytime column "school" is changed from one thing to another thing a notification should be sent. 

Example data struction

Name1   Email1   School1

Name2  Email2  School2

If any of the schools change I would like to be notified with the name and email of the row that changed.

Thank you for the help

[Marc_Dillon]

"but it does not seem to work."

Why not? What does it do? Have you checked the audit logs and the automation monitor? Have you thoroughly read the help articles about automation?

https://help.appsheet.com/en/articles/4865307-appsheet-automation-the-essentials