cancel
Showing results for 
Search instead for 
Did you mean: 

Combine of names

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

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

Answers (0)