Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jan 24, 2022 12:35 PM
I’m using a base to conduct performance reviews and record records. On a set date, I’d like to send the relevant records to the relevant employees. While I understand how to find records and trigger emails (see below), I’ll need to use dynamic recipients, which conditionally match only to their rows in the table. I’m struggling to set this up. With 50+ employees, I’d like to be able to do this dynamically, without manually coding each recipient.
Specifically, I want to send Manager A all of the records about Employee A. I want to send Manager B all of the records of Employee B. Any ideas how to execute this? Thanks!
Jan 25, 2022 07:01 AM
Hey @Hallie_Bregman,
welcome to Airtable community.
The first choice is to try the conditional actions. For more info check the following link:
The second choice is to display with look up field the employee’s email who is assigned to the task, and then in send to use the plus button to add this email.
For any further help on that please feel free to text back :slightly_smiling_face:
Yours sincerely,
Dimitris Goudis
Jan 25, 2022 07:16 AM
Thanks for the suggestions! I previously reviewed the conditional logic, which can be done but then would have to manually specify each recipient (there are more than 20). Re: Looking up employee’s email, that makes sense- but how do i guarantee that the forms they receive are filtered to their forms only?
Jan 25, 2022 10:10 AM
Hey @Hallie_Bregman,
you can use on email a template with dynamic information. So then every time the automation runs the email will include the separated info. :winking_face:
If you need help with that text me again to see it more specifically
Yours sincerely,
Dimitris Goudis
Feb 24, 2022 10:44 AM
I am having a similar problem. I would like to notify my “clients” when they have a “connection” with a birthday coming up. I have a view in the clients table that shows clients with birthdays in 20 days or fewer. The automation is a weekly email (triggered at a scheduled time). Then I run a “Find Records” for clients that are in the upcoming birthdays view. Then I want to Send them an email with a list of their connections with upcoming birthdays.
Where I’m running into trouble is that when I am sending the email, it wants to send to all the clients (at once), and include a list of all of the birthdays coming up- not just the ones they are connected to. I haven’t been able to figure out how to send several emails - each client gets their own email with their own list.
Does that make sense?
Thanks,
Sally
Mar 13, 2022 10:33 AM
Cal you leave an screenshot?
May 04, 2023 01:10 PM - edited May 04, 2023 01:10 PM
Did you find a solution? I'm having a similar problem automatically emailing a list of people their own personal digest of information...