Sign in to Community
Sign in to view all badges
using the Campaign Classic expression editor i'm trying to create the following:
I'm having trouble getting this to work and would appreciate some direction. Below is what i currently have:
Iif(@MOBILE_NUM is Null, @X_HOME_PH_NUM, Iif(@X_HOME_PH_NUM is Null and @MOBILE_NUM Is Null, "Call Customer Services to Update Number – 1-800-RED-CROSS", @MOBILE_NUM))
This should give you the desired result:
Iif(@X_HOME_PH_NUM is Null and @MOBILE_NUM Is Null, "Call Customer Services to Update Number – 1-800-RED-CROSS",Iif(@X_HOME_PH_NUM Is Null, @MOBILE_NUM, @X_HOME_PH_NUM))
worked perfectly. thank you! Apparently my issue was with order of operations -- good to know.
I am glad that this worked for you!!!