Help

Re: Multiple email automation

887 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Master
4 - Data Explorer
4 - Data Explorer

Hey Airtable community, I need you!

I made an automation to send email to multiple email addresses when a record matches conditions.

The automation works well during the test session and sends the email to multiple addresses picked from a rollup field with this formula added:

ARRAYJOIN(ARRAYUNIQUE(ARRAYCOMPACT(values)), ", ") .

The problem is when I run the automation in airtable data, the automation sends the email only at the first contact of the rollup field.

Please, help me to fix this issue.

Thank you for your time

5 Replies 5
Zack_S
8 - Airtable Astronomer
8 - Airtable Astronomer

Are you able to share a copy of your base with the fields required?

Duplicate the base and turn off “copy records”

Master
4 - Data Explorer
4 - Data Explorer

Hi Zack,

this is the link Airtable - Main Story View

Zack_S
8 - Airtable Astronomer
8 - Airtable Astronomer

Not sure why it isn’t working for you. I’m not having any problems when testing a similar setup.

Just for the sake of it try this
ARRAYJOIN(ARRAYUNIQUE(ARRAYCOMPACT(values))).

If that doesn’t work, I’m not sure what to tell you without seeing how the base and automations are actually setup.

Hi Zack,

Thank you for your support.

I tried also with your formula ARRAYJOIN…(etc), but it works during the test, but doesn’t work during the operation in aritable data.

Below you can find the snapshot of my automation configuration:

1
2
3
5

Master
4 - Data Explorer
4 - Data Explorer

The automations runs successfully, but as you can see it uses only one email address (the first in the Rollup field).

I tried also to invert the addresses, but the mail is sent every time only at the first address.

6
7