If IsNull?

[Former Member]

So I have been trying to make a formula with text in it such as an address.  So one of the lines Address 2 sometimes doesn't have anything in it.  So I tried to suppress it by checking the box in format text.  Since its a formula that didn't work.  So I was looking around and someone suggested to put data into a If IsNull formula.  Although every time I do that it says "A field is required here" where I have the first part of data in formula.  Can you not have text data in this type of formula?

[abhilash_kumar · Accepted solution]

Hi William,

The syntax should be:

If {Tenant_Address_Type} = 'Legal & Lease' then

(

(if {BilltoName} <> "" then {BilltoName} & chr(13))&

(if {BilltoStreet} <> "" then {BilltoStreet} & chr(13))&

(if {BilltoBlock} <> "" then {BilltoBlock} & chr(13))&

(if {BilltoCity} <> "" then {BilltoCity} & ", ") &

(if {BilltoState} <> "" then {BilltoState} & " " &

if {BilltoZipcode} <> 0 then {BilltoZipcode})

)

Replace all fields in this formula with the fields from your datasource.

While in the formula editor, look for the drop-down on the top that reads 'Exceptions for Nulls'; change that to 'Default Values for Nulls'.

-Abhilash

[abhilash_kumar · Accepted solution]

I just looked at your reply in the other thread.

You cannot use this formula in the 'Selection Formula'. This would need to be entered in a formula created from the Field Explorer.

What this formula does is, it formats the address like so:

Name

Street

Block

City, State Zip

After you place this formula on a section, right-click it > format field > common tab > check 'Can Grow' and it should display the full address.

-Abhilash