First of all, are you planning on using Airtable Automations?
Second, to be able to do “all emails in the to: field” then you need to have a schedule because otherwise it will tigger for every record individually.
Third, to send those emails for Report A and Report C separately, you need to have a different view for each of them. Is this doable for you? Another work around would be to have the Reports as a Linked Records Field (i.e.: they will have their own table, and therefore the sending 1 email to multiple recipients will be even easier)
Hi, Thank you very much for the welcome and for your fast reply!
Yes, I’m trying to use Airtable automation.
About the 2nd point, when you said “Schedule”, do you mean sending emails to each group of people at a different time or day?
About the 3rd point of your answer, my real database has more than 300 different reports, and creating a different view for each of them, it should be a long process and probably really confusing. Is there any other way? In my Real database, I have a view of the reports as a linked records field.
What I mean by “Schedule” is the trigger for the automation.
Since you have the Reports already as a Linked Record field, then you should use that in your automation instead. You can use a Rollup “ArrayUnique(values)” or a Lookup to get all the email addresses from the Table 1 (which I assume is a Contacts or Users table) then use this email field to
trigger the emails. Now comes the part of how to start your automation, do you want to send it daily or when something happens? If it’s daily then you can set the trigger as At Scheduled Time.
Yes, the condition is set in Table 1 instead of Reports table. You need to Rollup the value from Table 1 (probably using Max to get the latest date) into table Reports. THEN use this as the condition so the data will come from Reports table (1 per report) instead of Table 1 (1 per user)