Solved: Send one email with information on several rows an... - Page 2

Ksenia1 · 02-27-2024 07:20 AM

Hi there,

In my App I am scheduling appointments. For each appointment a new row is added to the table "Appointment" with the status "new". Depending on the value in my column "Type" (being a Ref column to another table, not directly to my recipient list but the connection to my "Recipient" Table), this information shall be sent to a specific recipient.

After finishing scheduling, I want to press on an action button to trigger an automation to send out emails to these recipients regarding all appointments with status "new". Now the trick is, I want only one email per recipient to be sent out with their relevant information and not an email per row.

After the emails are sent out, the status for all affected columns shall change to "informed".

How do I do that?

AleksiAlkio

I would probably trigger this from the "Type" table as it sounds you have an email column or columns where that email should be sen. If you add an action button (inline), you can trigger the "Type" row one by one. If there isn't any new scheduled row, hide that action. Then you have rows here and there to trigger.

Then you can use the Start & End formula on your template to read those rows where the status is new. You can use for example <<Start: ORDERBY(SELECT([Related appointmens][Key],[Status]="New"),[Created],FALSE)>>

View solution in original post

Send one email with information on several rows and to different recipients