Mar 16, 2022 12:47 PM
Hello! I’m trying to make automation where an email is sent to a specific email address whenever a record matches condition. My trigger tests fine, but I can’t set up action because whenever I try to test it tells me the “to field is empty.”
Tried with a rollup, lookup fields. Also tried with formulas. Tried arrayjoin formula, but nothing works for me.
Main table looks like this. Driver is from other table, and driver’s mail is rollup from other table as well.
This is formula I’m using with rollup
Even tried with formula field.
Mar 16, 2022 01:41 PM
Can you post a screenshot of your trigger conditions? Is one of your conditions “{Driver’s Mail} is not empty”?
Mar 16, 2022 01:44 PM
Mar 16, 2022 01:56 PM
Well I would then add as one of your conditions that the email field is not empty. That way you know your Automation won’t fire until there’s definitely an email to send it to.