Hey guys. I’m looking for some help with expression.
I got two tables.
BULLETIN table - 13 columns, 1 row of random update information.
MODERATOR table 14 columns, 13 rows of different user info
Heres’s my issue.
I have a drop-down column in my BULLETIN table called “POC Mod”, which lists the key values of the Moderators in the MODERATOR sheet.
I created a workflow rule to send a phone notification when the Mod is changed in the “POC Mod” column
[_THISROW_BEFORE].[POC Mod] <> [_THISROW_AFTER].[POC Mod]
The notification is sent to the new Mod using [POC Mod].[Email] in the Notification’s “To” field
(The MODERATOR sheet has an email column)
However, I also want to send a notification to the old Mod, to let them know they’re off-duty. However, it seems there is no easy way to identify who the old mod is. (The equivalent of a_THISROW.BEFORE value i can use in the notification’s “To” field)
Does anyone have any ideas they’re willing to share on how I can circumvent this? What’s the easiest way to identify who the old mod is here?