Skip to main content

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?

https://www.loom.com/share/5b726b2bc41a414da662f055af863b55

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. 


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!


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!


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


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. 


Reply