cancel
Showing results for 
Search instead for 
Did you mean: 

How to write calculation for concatenate one lookup field and a text field

Former Member
0 Kudos

I have one requirement that need to design one calculation field for concatenate two fields.

Itu2019s easy to concatenate two text fields.

Like this CONCAT(FAMILY NAME&FIRST NAME)

But when FAMILY NAME becomes a lookup fieldu2026

I donu2019t know how to write the expression for that field.

Please do me a favor.

Thanks a lot!

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Thanks a lot~~

Former Member
0 Kudos

Hi,

Its similar for lookups as well.

CONCAT(Countries.Name,Name)

When you navigate to Calculation Expression you will find the drop down of fields present in your repository. For lookup select the lookup field from the drop down and select the field present in the lookup table in above example its Name and check the result.

Kindly update...

Regards,

Jitesh Talreja