Send emails

[Sakhy]

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.

[LIUZheng]

Hello @Sakhy ,

This is what I would do:

1. create another column besides “Assigned To”, called “c_AssignedTo”, with type as ChangeCounter, columns “Assigned To”, initial value = 0, Update Mode = Reset.
2. Create a Bot in automation, trigger of the event is updates of the table, condition [c_AssignedTo]> = 1. Run process, send email, To “[_ThisRow].[Assigned To]”.

[Aurelien]

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]