# Concatenate list field

**URL:** <https://community.glideapps.com/t/concatenate-list-field/27115>\
**Category:** Ask for Help\
**Created:** [May 22, 2021, 10:23pm UTC](https://community.glideapps.com/t/concatenate-list-field/27115 "2021-05-22T22:23:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alfredo\_Pou](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alfredo_pou/32/10797_2.png) [@Alfredo\_Pou](https://community.glideapps.com/u/Alfredo_Pou)\
**Post date:** [May 22, 2021, 10:23pm UTC](https://community.glideapps.com/t/concatenate-list-field/27115/1 "2021-05-22T22:23:12Z")

</div>

Hi!  
I have a Look Up column that brings me all related products from another table.  
I need to concatenate all the texts.  
For example:  
An Order has 3 products:  
Pears, Apples and Bananas in an Order Items table.  
From the table Order, in a relation column I bring all the items of each Order.  
I need to merge all those items into a single text field:  
PearsApplesBananas.

The Template column doesn’t seem to allow it.  
How do I do it?

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [May 22, 2021, 10:46pm UTC](https://community.glideapps.com/t/concatenate-list-field/27115/2 "2021-05-22T22:46:55Z")

</div>

It should be easy with template, as long items are in the same row

---

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [May 22, 2021, 10:51pm UTC](https://community.glideapps.com/t/concatenate-list-field/27115/3 "2021-05-22T22:51:34Z")

</div>

Hola @Alfredo_Pou

Make sure your relation is a multiple relation and create a joined list column to that relation.  
You’ll get what you need.