- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 27, 2025 01:36 AM
Hey there,
First of all thank you for your time and your help 😉
I've made some pretty basic automation, when a record matches certain conditions, I trigger the action "send mail" (airtable default one). The field "To" is filled with a roundup type of field which has a formula "ARRAYUNIQUE(values)". It keeps the unique mails attached to the record.
My issue is that it works 30% of the time. The failure to run is always caused by : "The "To" input is empty"
Which is not, the field is never empty, it always has one or several mails. And it being not empty is a condition to trigger.
I can't find what's common to success or common to failure.
Any ideas ? 🙂
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 27, 2025 06:56 PM
Ah you're right, so sorry about that! I think I may have figured it out, does this look right?
And to do that I changed the rollup formula to be:
ARRAYJOIN(ARRAYUNIQUE(values))
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 27, 2025 02:17 AM
Perhaps you could set the conditions to also check whether the email field is empty? That would help you figure out if the automation was erroring out
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 27, 2025 04:15 AM
Hey Adam,
Thank you for your time,
It's already part of the conditions.
The automation tells me the "to" is empty, but it's not. That's what i don't get. Sometimes it decides it's empty, sometimes not, while it's always filled.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 27, 2025 04:41 AM
Hmm, I tried replicating that here:
And when testing the automation trigger nothing was available for selection
I figure my setup must be different from yours somehow. Could you take a look and let me know what I need to change to match yours?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 27, 2025 09:16 AM
Thanks for trying, here is mine :
Roundup field in data :
Automation trigger :
Actually your trigger should be roundupfield is not empty, but it's strange it doesn't show projet 2 and project 3 no ?
Here is the mail configuration with the "to" :
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 27, 2025 06:56 PM
Ah you're right, so sorry about that! I think I may have figured it out, does this look right?
And to do that I changed the rollup formula to be:
ARRAYJOIN(ARRAYUNIQUE(values))
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 28, 2025 11:03 AM
Hey Adam,
I'll try it and keep you posted. What is it supposed to solve ? Any ideas why some automations worked and some didn't ?
Thanks a lot 😉
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 30, 2025 05:37 AM
Hey there,
It seems to be working, thanks a lot ! But I'd like to know the impact of ARRAYJOIN, especially when there was only one mail to be used. My understanding is that it wouldn't change anything but it does.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 30, 2025 05:50 AM
I think what's happening is that ARRAYUNIQUE is returning some sort of data even when it looks empty visually, and ARRAYJOIN is kind of fixing that? I'm not too sure either so you may want to open a support ticket to get a better explanation, sorry!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 31, 2025 01:38 AM
Well it's working actually so i'm quite happy, thanks a lot ! 😉
