Emailing a weekly digest to separate users
We've built a ticket management system and every ticket has a "Status" and "Assigned To" field. I'd like to send a Monday digest email that lists all tickets "Under Review" - but send as separate emails to each person who has been assigned a ticket and show just their ticket details.
I was able to start with this article, but this automation only sends 1 email, which I can send to everyone listed as "Assigned To".
https://support.airtable.com/docs/how-to-create-email-digests-with-automations
In the To field, I've put the List of Emails from Assigned To found. This produces a result like "Name 1, Name 1, Name 2, Name 3, Name 3".
Instead, I want to send individual separate emails to each person, showing just their tickets. Is this possible?
Accepted Solutions
Yeap this is doable.
Assuming you have a tasks table like this:
And a users table like this:
You could set up your automation to find all the records in the "Users" table, and for each of the users, find the tasks that are linked to them and then send those tasks to each person as an email:
Resulting in this:
Yeap this is doable.
Assuming you have a tasks table like this:
And a users table like this:
You could set up your automation to find all the records in the "Users" table, and for each of the users, find the tasks that are linked to them and then send those tasks to each person as an email:
Resulting in this:
