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.
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?
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:
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 ?