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.