Help

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

939 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Michael1
6 - Interface Innovator
6 - Interface Innovator

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”?

image

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.