Sending an email if an email address isn't empty - failed

Topic Labels: Automations
332 4
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi there, 

Here's the scenario: 

• I have an automation to send an email to the marketing contact if the 'marketing contact email' field isn't empty

• the 'marketing contact field' is a Rollup field with a formula of ARRAYUNIQUE(values)

• even though the 'marketing contact field'rollup field is empty, as you'll see from the test run on the below Loom, it still tried to execute that worflow. 

• is it seen as not empty because there's a formula in it?

4 Replies 4

Does changing the rollup formula to ARRAYJOIN(ARRAYUNIQUE(ARRAYCOMPACT(values)), ", ") help? This will clear out empty values and then force the result into a text string. 

Thank you for the reply @kuovonne however it doesn't seem to have done the trick, as you can see below. 

You can see here that it says "if marketing email isn't empty" but then it clearly shows an empty field below!

Screenshot 2024-04-05 at 17.06.03.png

Try making your rollup formula `ARRAYJOIN(ARRAYUNIQUE(values))`? Seems to work!

Screenshot 2024-04-06 at 11.57.28 AM.png

Screenshot 2024-04-06 at 11.57.24 AM.png
Link to base

This is puzzling.

Could there be a record with a space in the email field that makes it look blank when it is not? 

Sometimes retesting the trigger helps.