Greetings
i have data entry App, which had appointments dates etc, I have a column named "Assigned To" i would like whoever is captured when he/she assigned that file to it send email to that employee. Employee table with employee details is linked.
Hello @Sakhy ,
This is what I would do:
A slight simplification I would suggest: simply use a condition on the Event, so that you focus on the [assigned To] column:
And use the expression:
[_THISROW_BEFORE].[Assigned To]<>[_THISROW_AFTER].[Assigned To]