Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Automation to send an email says “‘to’ field is empty”

Topic Labels: Automations
395 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

image

This is formula I’m using with rollup
image

Even tried with formula field.
image

3 Replies 3

Can you post a screenshot of your trigger conditions? Is one of your conditions “{Driver’s Mail} is not empty”?

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.