The "To" field Options for email addresses

[Nanette_Mattox]

I am setting up an automated email and want it to go to the email (will be multiple emails) from a lookup field that has the email address in it. When inserting the Data from the Record and selecting the property that has the emails in it, it gives me options. I can not get any of them to work! The error is that the “To” input is empty.

Screen Shot 2021-04-04 at 11.57.55 AM|672x500

[kuovonne]

Welcome to the Airtable community!

The “To” option needs a comma separated list, but a lookup returns an array (which is a different type of list).

Try using a rollup field instead of a lookup field. Use this rollup formula to insert commas between the email addresses, remove duplicates, and remove blank values.

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

If this does not work, also check to make sure that the rollup field in your record has at least one valid email address in it.

Hope this help! Please report back.

[Nanette_Mattox]

Sorry…new to this… but the Rollup Field doesn’t have a place for a formula. Not sure what you mean.

[kuovonne]

The rollup configuration screen is too tiny on many screens. You may have to scroll down to find the place to put the formula.

[Admin_KONBINI]

Hello,

I want to create an automation to send daily summaries to my teams about the tasks to do for the next day. For this I have a roolup column with their email addresses and I use an automation find records to get their email addresses.
The only problem is that I can’t add these email addresses in the TO line of the email.
I’ve tried your configuration @kuovonne but I can only put length values and not email values.

Do you have any tips for me ?

[kuovonne]

Welcome to the Airtable community!

Admin_KONBINI:

I use an automation find records to get their email addresses.

The problem is that the find records action does not work the way you want. The find records action was designed to send an html grid of records in the body of a single email.

The information in this thread was about getting email addresses from a single field in the triggering record, not the result of a find.

[Admin_KONBINI]

Than you @kuovonne
Do tou have any idea to help me to do what I explain ?
(Sorry for my bad english)

[kuovonne]

Automations have limitations with calculated fields. I do not think you can get the email addresses from a rollup in a find action.

[Admin_KONBINI]

Thanks,
Do you think a formula field will works with Arrayjoin ?

[Jacob_Feldman]

Edit: I think I found the issue…not all records have an email address…will update with solution.

Hi @kuovonne I’m wondering if you might be able to support me on this same issue. I’m working to set up an automation but am receiving the “To Field Invalid” error message. I’ve tried to follow your recommendations here but I can’t get it to cooperate. I’ve confirmed the emails are valid and that the record Airtable is testing has a valid email.

The parameters are as follows:

-Emails are listed in Table 1 in an email field

-Table 2 has a lookup field that populates a person’s name from table 1, and a rollup field using
ARRAYJOIN(ARRAYUNIQUE(ARRAYCOMPACT(values)), ", ") to retrieve the associated emails from Table 1.

-Table 3 has a rollup field with the same formula in it to retrieve the emails from table 2.

Thanks for any help you can provide! Screenshots below: