+2I have an automation that 1st Finds Records from a table then Inserts the Found Grid into an Email. I have static Emails and also want to Use Emails from the Found Records. If all the Found Records Emails match is there a way to just add 1 instead of it putting in multiple identical Emails in the To:
I imagine maybe a script but do not know how to write those.
Bull
Best answer by TheTimeSavingCo
If all the Found Records Emails match is there a way to just add 1 instead of it putting in multiple identical Emails in the To:
Here’s an example base I set up
Assuming your data looks like this:
And your goal is to have a list of emails that looks like this:
Then you could try using the following script to get a unique list of emails:
let {emails} = input.config()
let uniqueEmails = [...new Set(emails.map(e => e.toLowerCase()))].sort();
output.set('uniqueEmails', uniqueEmails)And this is how the automation setup looks and works in practice:
+12need more info.
when an automation is triggered, there’s a triggering record, you don’t need to find email addresses at all.
+31If all the Found Records Emails match is there a way to just add 1 instead of it putting in multiple identical Emails in the To:
Here’s an example base I set up
Assuming your data looks like this:
And your goal is to have a list of emails that looks like this:
Then you could try using the following script to get a unique list of emails:
let {emails} = input.config()
let uniqueEmails = [...new Set(emails.map(e => e.toLowerCase()))].sort();
output.set('uniqueEmails', uniqueEmails)And this is how the automation setup looks and works in practice:
+2
I have an automation that Sends this list to pre set emails I also want to send it to the Test email. Right now it will put the test email in the CC line 6 times. It does only send 1 Email to the Test email. Is there a way to clean it up. the script above gave me a snytax error when I tried it.
+31Hm, that’s weird. Could you provide screenshots of the automation setup? If you could private message me a read-only link to your base so that I can troubleshoot it directly that’d be easier too
+31Thanks for the link to the base! The reason you’re getting a syntax error for the script is because we need to set the input variable on the left, and here’s how you’d do that:
Could you try setting this up and testing the script out again? It should give you a unique list compiled from the Test Email values
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
