Oct 30, 2024 03:19 PM - edited Oct 30, 2024 03:27 PM
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
Oct 30, 2024 05:03 PM
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!
Oct 31, 2024 02:25 AM
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?
Oct 31, 2024 02:26 AM
sorry for bad english... i m from holland😊
Oct 31, 2024 07:26 PM
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?