🎉 Come hang out — the Discord server is live and free to join!

background shape
background shape

NULL value comparison in IF statement

If you have field in DE that its value is not always populated for a particular row (customer) and you test field value against any value cloud page will throw an 500 – internal server error.

%%[
var @field;// null value


if @field == 4 then
//500 
endif

]%%

To fix this, you will simply need to add another AND-condition to test field value for NULL with NOT IsNull()

%%[
var @field;// null value


if NOT IsNull(@field) AND @field == 4 then
//do something
endif

]%%

Oh hey there đź‘‹
I’ve got something special for you—free scripts every month!

Sign up now to receive monthly premium Salesforce Marketing Cloud script examples straight to your inbox.

We don’t spam! Read our privacy policy for more info.

Share With Others

Leave a Comment

Your email address will not be published. Required fields are marked *

MarTech consultant

Marcel Szimonisz

Marcel Szimonisz

I specialize in solving problems, automating processes, and driving innovation through major marketing automation platforms—particularly Salesforce Marketing Cloud and Adobe Campaign.

Related posts