Help

The "To" field Options for email addresses

Topic Labels: Automations
4052 11
cancel
Showing results for 
Search instead for 
Did you mean: 
Nanette_Mattox
5 - Automation Enthusiast
5 - Automation Enthusiast

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

11 Replies 11

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
5 - Automation Enthusiast
5 - Automation Enthusiast

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

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
4 - Data Explorer
4 - Data Explorer

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 ?

Welcome to the Airtable community!

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
4 - Data Explorer
4 - Data Explorer

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

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
4 - Data Explorer
4 - Data Explorer

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

Jacob_Feldman
5 - Automation Enthusiast
5 - Automation Enthusiast

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:

2021-09-07_11-06-37
2021-09-07_11-08-40