Notify User When Assign Record

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 Solved
0 2 447
1 ACCEPTED 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]

View solution in original post

2 REPLIES 2

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!

Top Labels in this Space