Combine of names

[Former Member]

I have customer table that has a column for the customer_name.

It can be blank. If it's blank, I can get the name from 2 columns as well, called firstname and lastname.

How can I combine these two to display with blank?

So that my formula would look like:

If Customer_Name > ' ' then Customer_Name else

Firstname + ' ' Lastname

[abhilash_kumar · Accepted solution]

Hi Paul,

Create a formula with this code:

If Trim(Customer_Name) = '' then

Firstname + ' ' + Lastname

else

Customer_Name

While in the formula editor, select 'Default Values for Nulls' from the drop-down on the top.

-Abhilash