Skip to main content

Hello, this is an airtable newbie question:
I have searched here, watched videos, and am completely failing with the following problem:

I want to create an automation that sends a mail to ALL mail addresses contained in table 2 when a data record is added to table 1.
I have the trigger, it works, it's simple.
In the actions, I only have access to the data of table 1 in the To: field (where the mail addresses should go), not table 2.
How can I access the data of table 2 at this point?

Does anyone have a comprehensible tip for me?
Many thanks in advance for your time
Boris

Assuming you want to send one email per email address in Table 2, try setting up your automation like this:

It has a "Find Record" action that'll look for all the records from "Table 2", and you can then use a "Repeating Group" on the results of that "Find Record" action to send one email per found record

Assuming you want to send one email per email address in Table 2, try setting up your automation like this:

It has a "Find Record" action that'll look for all the records from "Table 2", and you can then use a "Repeating Group" on the results of that "Find Record" action to send one email per found record


Hello Adam,
Thank you very much for your quick reply.
I managed to find the email addresses, but there is something wrong with the formatting?
The test action/preview contains a lot of formatting elements. Is there any way to remove them?
Boris

Hello Adam,
Thank you very much for your quick reply.
I managed to find the email addresses, but there is something wrong with the formatting?
The test action/preview contains a lot of formatting elements. Is there any way to remove them?
Boris


Hmm, feels like you may have selected the wrong data to put into the "To".  Assuming you've set up your data like this:

 

Try setting up your automation like this:

Link to base

If this doesn't help, if you could you provide a read only invite link to a duplicated copy of your base with no data in it I could set it up for you real quick

Hmm, feels like you may have selected the wrong data to put into the "To".  Assuming you've set up your data like this:

 

Try setting up your automation like this:

Link to base

If this doesn't help, if you could you provide a read only invite link to a duplicated copy of your base with no data in it I could set it up for you real quick


YES YES YES
1001 thanks for the example, that was enlightening. 1 field was wrong
Best regards
Boris

Reply


Terms & Conditions