Hi guys,
I know this is an easy one for you. When I add a new โJob requestโ I assign it to a user (field โAssign to)โ, a notification is sent that a โJob requestโ has been assigned to him. it works fine for โADDS_ONLYโ.
But I want that if I change the user assigned, I want to notify to that new user that a โJob requestโ has been assigned to him. In short words: I want to notify only if the field โAssign toโ is updated.
Solved! Go to Solution.
See topic โSending Email When a Row is Updated to Have a Specific Column Valueโ in this article https://help.appsheet.com/en/articles/961707-workflow
Just eliminate the check for the specific value and leave the part that looks for any change in value.
[_THISROW_BEFORE].[Assign to] <> [_THISROW_AFTER].[Assign to]
See topic โSending Email When a Row is Updated to Have a Specific Column Valueโ in this article https://help.appsheet.com/en/articles/961707-workflow
Just eliminate the check for the specific value and leave the part that looks for any change in value.
[_THISROW_BEFORE].[Assign to] <> [_THISROW_AFTER].[Assign to]
You are the best, thanks Phil!
User | Count |
---|---|
17 | |
12 | |
9 | |
4 | |
4 |