# 🆕 Joined List column ready in production **URL:** \ **Category:** Ask for Help\ **Created:** [August 7, 2020, 9:01am UTC](https://community.glideapps.com/t/joined-list-column-ready-in-production/13679 "2020-08-07T09:01:10Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [August 7, 2020, 9:01am UTC](https://community.glideapps.com/t/joined-list-column-ready-in-production/13679/1 "2020-08-07T09:01:10Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/be053e01abb1461c17f2b40fbf3c0853a3791203.png) Now you can add a “Joined List” column in production apps. In the example, I joined the list of dishes from a category relation, separated by a comma. ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [August 7, 2020, 9:44am UTC](https://community.glideapps.com/t/joined-list-column-ready-in-production/13679/2 "2020-08-07T09:44:56Z")
Can you explain this a little more? What is the use case for this? What does it actually do? How can we practically use it in our apps to achieve something? Thanks ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [August 7, 2020, 9:48am UTC](https://community.glideapps.com/t/joined-list-column-ready-in-production/13679/3 "2020-08-07T09:48:28Z")
I think the most immediate use is this. > [@Write an array column (via Lookup) to Google sheet](https://community.glideapps.com/t/write-an-array-column-via-lookup-to-google-sheet/13062/14): > > Hola @Mark, thanks for replying My request is simple, as you know, a lookup is an array column with multiple values. Any lookup using a simple relation can be only used with a Template, Math, IF-Then-Else tool or into a single value component, this is understandable but what if the lookup uses a multiple relation and its result generates a kind of list (like a unidimensional array column)? I’d like to write that list (lookup with multiple relation) to one cell in my GS in order to have that … ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [August 7, 2020, 12:23pm UTC](https://community.glideapps.com/t/joined-list-column-ready-in-production/13679/4 "2020-08-07T12:23:23Z")
Yeesss, now I have more work to change, it’s a bittersweet feeling: I wished this feature for weeks and now I have it, I hate all work I made as workaround before it 🤨 But anyway it’s a big step to everyone working with Glide. Gracias por este gran juguete @Mark!! Saludos ---
**Author:** ![everys](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/everys/32/10724_2.png) [@everys](https://community.glideapps.com/u/everys)\ **Post date:** [August 8, 2020, 9:55am UTC](https://community.glideapps.com/t/joined-list-column-ready-in-production/13679/5 "2020-08-08T09:55:05Z")
i can see the future of this feature but now i’m thinking of a generic use case. ![Screen Shot 2020-08-08 at 17.34.16](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/a0de4dfa97df7989f75e52e247cd32c7acb5aa2c.png) Edited: i had tried and saw that it could gather up all data within specific column then rolled up into one single array with anything as delimiter. But so far I had tried and it seemed no Glide components can cope with this array. And since this cannot be used with the generic data table as the data will keep on tailing. I wonder how to use it apart of being a good Logging feature. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [August 8, 2020, 6:21pm UTC](https://community.glideapps.com/t/joined-list-column-ready-in-production/13679/6 "2020-08-08T18:21:14Z")
The thing is, Joined List is no longer an array. It’s just a single string of text, so it can only be applied to components that accept single column values. If you still needed an array, then a Lookup column would give you that. The original request that brought the Joined List feature was to take an array list of toppings for a food item and put them in a single column when an order is submitted, so they can be written to a single row. I use it myself to build dynamic html or markdown tables from multiple rows of data. ---
**Author:** ![Jaime](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jaime/32/72726_2.png) [@Jaime](https://community.glideapps.com/u/Jaime)\ **Post date:** [April 18, 2021, 1:42am UTC](https://community.glideapps.com/t/joined-list-column-ready-in-production/13679/7 "2021-04-18T01:42:59Z")
is there a limit on the number of items/characters that should be included in a joined list? if hypothetically I included several hundred rows in a big joined list of several thousand characters, would this cause performance issues? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 18, 2021, 2:01am UTC](https://community.glideapps.com/t/joined-list-column-ready-in-production/13679/8 "2021-04-18T02:01:09Z")
> [@Chat and Comments using the Trebuchet Method](https://community.glideapps.com/t/chat-and-comments-using-the-trebuchet-method/25396/4): > > According to @Jason you can store 1 million characters in a glide table cell. Google sheets limited to 50,000 characters per cell I think here’s the relevant info. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 18, 2021, 2:03am UTC](https://community.glideapps.com/t/joined-list-column-ready-in-production/13679/9 "2021-04-18T02:03:21Z")
> [@Jeff\_Hager](#): > > I use it myself to build dynamic html or markdown tables from multiple rows of data. Would love to see a couple simple versions of this ---
**Author:** ![Jaime](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jaime/32/72726_2.png) [@Jaime](https://community.glideapps.com/u/Jaime)\ **Post date:** [April 18, 2021, 2:32am UTC](https://community.glideapps.com/t/joined-list-column-ready-in-production/13679/10 "2021-04-18T02:32:09Z")
thanks! ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [April 18, 2021, 7:56pm UTC](https://community.glideapps.com/t/joined-list-column-ready-in-production/13679/11 "2021-04-18T19:56:50Z")
@Robert_Petitto I threw together a quick example here. > **[Multiple Row Reset Concept](https://synonymous-sheep-0795.glideapp.io/)** It’s adapted from how I currently use it in my main app to display a list of lessons in an Invoice. I mix it with CSS to get the border and the alternating gray bar. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 18, 2021, 8:18pm UTC](https://community.glideapps.com/t/joined-list-column-ready-in-production/13679/12 "2021-04-18T20:18:24Z")
Thanks Jeff! Really appreciate you taking the time to create an example! ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [September 1, 2021, 12:15am UTC](https://community.glideapps.com/t/joined-list-column-ready-in-production/13679/13 "2021-09-01T00:15:48Z")
Not sure if this might be of interest to anyone, but we can avoid use of formulas to split items across several rows by just replacing the comma with \< /br \> \< /br \> and pull the items as a list using the rich text component. ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [September 1, 2021, 3:23am UTC](https://community.glideapps.com/t/joined-list-column-ready-in-production/13679/14 "2021-09-01T03:23:15Z")
Can you give us a usecase Wiz? I guess I didn’t get it at all ---
**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:** [September 1, 2021, 4:49am UTC](https://community.glideapps.com/t/joined-list-column-ready-in-production/13679/15 "2021-09-01T04:49:56Z")
Just a single CRLF (carriage return line feed) also works. I use this to generate CSV exports. ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [September 1, 2021, 2:51pm UTC](https://community.glideapps.com/t/joined-list-column-ready-in-production/13679/16 "2021-09-01T14:51:07Z")
@Lucas_Pires say we have a long list of items. Comma separated result is below: ![comma separated](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/5/f53d4ac32fbccc5b9e941075789335a286781082.png) HTML break tag separated result is below ![HTML break tag](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/7/e7cf024b485028cd52861e34894b5004be5c98d2.png) ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [September 1, 2021, 3:14pm UTC](https://community.glideapps.com/t/joined-list-column-ready-in-production/13679/17 "2021-09-01T15:14:21Z")
Got it! Amazing ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [September 1, 2021, 3:28pm UTC](https://community.glideapps.com/t/joined-list-column-ready-in-production/13679/18 "2021-09-01T15:28:48Z")
> [@Wiz.Wazeer](#): > > below: > > ![comma separated](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/5/f53d4ac32fbccc5b9e941075789335a286781082.png) Hola @Wiz.Wazeer But your long list is a Joined List right? If so, you can use the CRLF instead of comma (,) (press Enter). This will create a list separated by an empty line. Saludos ---
**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\ **Post date:** [September 1, 2021, 4:01pm UTC](https://community.glideapps.com/t/joined-list-column-ready-in-production/13679/19 "2021-09-01T16:01:59Z")
Hi Darran, would be interested to know this. I have subscription based app (Public App) wherein each user have their data inserted by them. I want to give them an option to export their data to CSV. I checked integromat but I am stuck on how to combined the data into one. Probably you can help me out in this. Thanks ---
**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:** [September 1, 2021, 4:36pm UTC](https://community.glideapps.com/t/joined-list-column-ready-in-production/13679/20 "2021-09-01T16:36:06Z")
A few people have asked about this. I’ll try and find some time to post a short tutorial later this week. [Next page](https://community.glideapps.com/t/joined-list-column-ready-in-production/13679.md?page=2)