Jump to content

If data is blank, return a name


Recommended Posts

If address line 2 is blank, I just need it to return a name. If it has a value in the data, I need it to be blank.



John Smith

<value> <would return a name here

123 E. Way Street

Anywhere, WI 54729


Suzie Smith

<no value> <would be blank

456 E. Way Street

Apt. 32 <has an address 2

Anywhere, WI 54729

Link to comment
Share on other sites

I think I may have figured it out..:o



if (Field("Address Line 2") == "")
return "Attn:Purchasing Department";

return Field("");

I think the last line should just be:

return "";

You could also write the entire rule like this:

return Field("Address Line 2") ? "" : "Attn:Purchasing Department";

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...