Concatenate two columns

I want to combine data from two columns and store it a new column. How can I do that ?

In one of solutions, it is mentioned to use Template data type, but, I am not able to do with that.

A Template column is the way to do this. Can you explain why it doesn’t work for your use case?

1 Like

hi @Darren_Murphy I want to combine texts from Country code and mobile number.

I create a new field of type Template and I selected “Country code” column from the columns. how can I select the “mobile number” column next ?

Okay, you’re not using it correctly. What you need to do is add something like the following in the Template Text field:

{code} - {number}

Then add two replacement values, one for {code}, and one for {number}.
It should look something like the following:

Learn more below:

4 Likes

Thank you @Darren_Murphy This worked.

I was also looking to have a field datatype - dropdown with multiple values where I can select single or multiple values. But, I don’t see any such data type. Can you please help on how I can do that ?

For ex., I want a field “Lead Status” and it should have a dropdown with values Hot, Cold, Stale and the user should be able to select one value. How is this possible ?

2 Likes