The To is empty

[Toniebosch]

In my base i have made an automation that sends mail ( gmail) but whatever i tried it keeps giving messag " the To" is empty, there are nog blank fields in the row ( email) i ve made a roll up with the fix ( found on another thread ) .. after days of testing i didnt solve the problem.. can anyone help me please??

A link to the loomvid 

https://www.loom.com/share/d497132a3ddb47c9a6ce93030e103e4b?sid=131789ac-7d4b-4f19-b43c-871452ce6fda 

[TheTimeSavingCo]

Hmm the loom video doesn't have audio for me so apologies if I've misunderstood something

May I know how the records are created?  The automation's trigger is "When record is created", and I'm wondering if the automation is triggering before the email field has been populated.  If you could DM me an invite link to your base I could take a look at this for you by reviewing the revision history too!

[Toniebosch]

I ve found the misstake, indeed, when i create a record, the automation is running before i ve finished the record, so the mailadres is not filled. I ve changed my workflow, and set a trigger and also there same issue, when i fill out the record completely and then change the trigger the automation runs as set and expected, so the automation works as soon as you hit a " new record" when you set the trigger to that.

resume; as soon as i fill 1st tabel/column the trigger for automation is working? is that correct?

[Toniebosch]

sorry for bad english... i m from holland😊

[TheTimeSavingCo]

Ahh apologies, I don't really understand, but it seems like you're still facing issues?

If you're not creating the records via a form of some sort, I'd suggest using a checkbox field called "Send email" or something, and the workflow would be:
1. Fill out record
2. Mark the checkbox "Send email"
3. Automation runs and email is sent

Does that make sense?