Dear Sirs:
We have a parent table “Capacitaciones” and a child table “Asistencias”, how can we make a bot run from the parent table to send emails for each row in the child table.
Is there any way to do this?
Yes…but first, if you are using the Child table to gather the recipients to whom to send the email to, you can do that in a single email step running against the parent. The “To” property allows an expression to gather the list of email addresses.
If you need to send a separate and different email to each child row, you can’t create that from within the Bot itself. What you will want to do is the following:
- Add a column to the Child table maybe named “Send Email?”
- Attach an action set to the Form Saved behavior of the Parent row that processes a set of actions on each child row. These actions will set "Send Email? " to TRUE and then immediately resets it back to FALSE. This prevent inadvertent duplicates.
- Create a Bot that runs on your Child table and triggers when “Send Email?” has been set.
- Add the Email step to this new Bot as you normally would to generate and send a unique email for each child row.
I hope this helps!!
1 Like