Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Issue with mail automation : mail recipient roundup formula doesn't work 100%

Topic Labels: Automations
Solved
Jump to Solution
493 9
cancel
Showing results for 
Search instead for 
Did you mean: 
SpaceDandy
6 - Interface Innovator
6 - Interface Innovator

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 ? 🙂

 

 

1 Solution

Accepted Solutions

Ah you're right, so sorry about that!  I think I may have figured it out, does this look right?

Screenshot 2025-01-28 at 10.55.46 AM.png

Screenshot 2025-01-28 at 10.55.55 AM.png

Screenshot 2025-01-28 at 10.55.58 AM.png

 

And to do that I changed the rollup formula to be:

ARRAYJOIN(ARRAYUNIQUE(values))

See Solution in Thread

9 Replies 9

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

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.

 

Hmm, I tried replicating that here:

Screenshot 2025-01-27 at 8.39.14 PM.png

And when testing the automation trigger nothing was available for selection

Screenshot 2025-01-27 at 8.40.40 PM.png


Screenshot 2025-01-27 at 8.39.22 PM.png

Link to base

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?

Thanks for trying, here is mine :

Roundup field in data :

SpaceDandy_0-1737997858756.png

Automation trigger :

SpaceDandy_1-1737997900219.png

 

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" :

SpaceDandy_2-1737998180377.png

 

 

Ah you're right, so sorry about that!  I think I may have figured it out, does this look right?

Screenshot 2025-01-28 at 10.55.46 AM.png

Screenshot 2025-01-28 at 10.55.55 AM.png

Screenshot 2025-01-28 at 10.55.58 AM.png

 

And to do that I changed the rollup formula to be:

ARRAYJOIN(ARRAYUNIQUE(values))
SpaceDandy
6 - Interface Innovator
6 - Interface Innovator

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 😉

SpaceDandy
6 - Interface Innovator
6 - Interface Innovator

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.

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!

SpaceDandy
6 - Interface Innovator
6 - Interface Innovator

Well it's working actually so i'm quite happy, thanks a lot ! 😉