Skip to main content

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

 

 

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

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:

And when testing the automation trigger nothing was available for selection


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?

Hmm, I tried replicating that here:

And when testing the automation trigger nothing was available for selection


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 :

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

 

 

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

 

 


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))

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 😉

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.

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!

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

Terms & Conditions