Find Unique emails in a column and add to row

[Jason_Martin]

Hi Everyone,

I have an automation that is triggered from a schedule, finds records in a view and then needs to email address using one of the values found in the view.

The problem is that the email address in the view may appear many times (Multiple rows) so that using that field in the automation will mean the TO: filed looks like this: user1@test.com, user2@test.com, user1@test.com, user2@test.com This means they get the email multiple times.

How can I get the unique values from the rows and use that for the sending on emails?

Cheers

[kuovonne]

The find records action in Airtable automations is rather limited. There is no built-in method of obtaining unique values from a find action.

You can use a scripting action that can find the records and filter out duplicate email addresses.

If you are interest in a script, but do not code, and have budget to hire someone to write a script, you can book an appointment with me.

[Jason_Martin]

Thanks. I thought it maybe possible with Rollup’s and Arrays some way. I will look to Integromat for this one but it would be nice feature to have for the future though.

[kuovonne]

Roll ups have a limited ability to eliminate duplicates under very specific circumstances. However they only work for linked records, which don’t apply in a find records action.