# Concatenate two columns

**URL:** <https://community.glideapps.com/t/concatenate-two-columns/70155>\
**Category:** Ask for Help\
**Created:** [January 28, 2024, 1:38pm UTC](https://community.glideapps.com/t/concatenate-two-columns/70155 "2024-01-28T13:38:09Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hemanth\_Chandra](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hemanth_chandra/32/66798_2.png) [@Hemanth\_Chandra](https://community.glideapps.com/u/Hemanth_Chandra)\
**Post date:** [January 28, 2024, 1:38pm UTC](https://community.glideapps.com/t/concatenate-two-columns/70155/1 "2024-01-28T13:38:09Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [January 28, 2024, 1:42pm UTC](https://community.glideapps.com/t/concatenate-two-columns/70155/2 "2024-01-28T13:42:08Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Hemanth\_Chandra](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hemanth_chandra/32/66798_2.png) [@Hemanth\_Chandra](https://community.glideapps.com/u/Hemanth_Chandra)\
**Post date:** [January 28, 2024, 2:29pm UTC](https://community.glideapps.com/t/concatenate-two-columns/70155/3 "2024-01-28T14:29:09Z")

</div>

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 ?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/c/8c49b98c8d7915125aeb0aca7450814dac6b1102.png)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [January 28, 2024, 2:37pm UTC](https://community.glideapps.com/t/concatenate-two-columns/70155/4 "2024-01-28T14:37:30Z")

</div>

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

```auto
{code} - {number}

```

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

 ![CleanShot 2024-01-28 at 22.36.25@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/b/eb7f4faf8bc3a4332cc343db01b0b8f7b6b6435a.png)

Learn more below:

> **[Template Column | Glide Docs](https://www.glideapps.com/docs/automation/computed-columns/template-column)**
>
> Display dynamic text that can change with the values in other columns.

---

<div class="post-metadata">

**Author:** ![Hemanth\_Chandra](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hemanth_chandra/32/66798_2.png) [@Hemanth\_Chandra](https://community.glideapps.com/u/Hemanth_Chandra)\
**Post date:** [January 28, 2024, 4:03pm UTC](https://community.glideapps.com/t/concatenate-two-columns/70155/5 "2024-01-28T16:03:02Z")

</div>

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 ?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [January 28, 2024, 4:03pm UTC](https://community.glideapps.com/t/concatenate-two-columns/70155/6 "2024-01-28T16:03:55Z")

</div>

> **[Choice | Glide Docs](https://www.glideapps.com/docs/essentials/components/choice)**
>
> Pick options from a list.