# List of items in single cell
**URL:** https://community.glideapps.com/t/list-of-items-in-single-cell/555
**Category:** Ask for Help
**Created:** [September 24, 2019, 3:36pm UTC](https://community.glideapps.com/t/list-of-items-in-single-cell/555 "2019-09-24T15:36:36Z")
**Posts on this page:** 12
**Page:** 1
### Author:  [@citation](https://community.glideapps.com/u/citation)
#### Post date: [September 24, 2019, 3:36pm UTC](https://community.glideapps.com/t/list-of-items-in-single-cell/555/1 "2019-09-24T15:36:36Z")
Hi,
How can I show a list of items within a cell as such in the App?
---
### Author:  [@George\_B](https://community.glideapps.com/u/George_B)
#### Post date: [September 24, 2019, 3:46pm UTC](https://community.glideapps.com/t/list-of-items-in-single-cell/555/2 "2019-09-24T15:46:57Z")
@citation Not sure what your use of wanting a list inside a single cell is, but if you formatted the list of items in Markdown you would use a RichText component in the App to display it. I use that technique in one of my apps to show who is coming to an event and if they have paid or not. I blocked out the names for privacy.
---
### Author:  [@citation](https://community.glideapps.com/u/citation)
#### Post date: [September 24, 2019, 4:12pm UTC](https://community.glideapps.com/t/list-of-items-in-single-cell/555/3 "2019-09-24T16:12:34Z")
Hey George\_B, thanks so much. that worked. just one follow up question; how do you get the Rich Text field to have a Label? “Attendees” in your case.
---
### Author:  [@George\_B](https://community.glideapps.com/u/George_B)
#### Post date: [September 24, 2019, 7:11pm UTC](https://community.glideapps.com/t/list-of-items-in-single-cell/555/4 "2019-09-24T19:11:57Z")
It’s part of the markdown, the Title of the table. If this worked for you please mark it as the Solution, thanks.
```auto
|Attendees| Num
|:-------|:-------|
| Last, Peggy & Jim | 2 |
| Smith, Bill | 2 |
| Jones , Edythe | 1 |
|===========|===|
|Total Attending|5|
```
---
### Author:  [@filipa](https://community.glideapps.com/u/filipa)
#### Post date: [September 25, 2019, 11:32am UTC](https://community.glideapps.com/t/list-of-items-in-single-cell/555/5 "2019-09-25T11:32:48Z")
> [@George\_B](#):
>
> |Attendees| Num |:-------|:-------| | Last, Peggy & Jim | 2 | | Smith, Bill | 2 | | Jones , Edythe | 1 | |===========|===| |Total Attending|5|
@George_B And is there a way to make google sheets build this table dynamically? Like, instead of “Smith, Bill”, make it fetch the text in cell A2?
---
### Author:  [@George\_B](https://community.glideapps.com/u/George_B)
#### Post date: [September 25, 2019, 11:43am UTC](https://community.glideapps.com/t/list-of-items-in-single-cell/555/6 "2019-09-25T11:43:29Z")
For a short list I would say yes, but for long ones it would be a little messy at best. I am building the list shown in the picture in a script. The list actually is coming from a spreadsheet attached to a Google Form. It is a listing of who signed up for a given event, and shows in the calendar in the details for that event. So the names are coming from a sheet, but the actual building of the string of data is done in a script while looping through the rows on the sheet.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [September 25, 2019, 1:52pm UTC](https://community.glideapps.com/t/list-of-items-in-single-cell/555/7 "2019-09-25T13:52:28Z")
I have done this at a dynamic level. Without getting too technical, I have lessons that a coach enters in the app. Based on user input, I figure out the amount to bill for that lesson into a column. Then I build another column that joins together into from other columns and adds the piping for a single row of a markdown table. This is essentially one row that will be part of a markdown in another sheet. That sheet is an invoice. Using formulas and intermediate sheets with a query built in, I can gather all the lessons for each student within a date range and create an invoice that’s displayed in the rich text component. Like @George_B said, it can get extremely messy. My example might be overly complicated, but hopefully it gives you ideas.
> **[Demo Dynamic Markdown Table](https://docs.google.com/spreadsheets/d/1A1V3dX0ACmzLHygpcjwQP7zuto59HKGA3xFuO2_alDA/edit?usp=sharing)**
>
> Lessons
>
> Name,Lesson,Length,Date,Coach,Notes,NameLesson,Custom Rate,Rate,ConvertedDate,InvoiceBillingListMarkdown
> ,,,
> Student 1,Dance/Moves/Freestyle,1-1/2 Lesson,5/1/2019,fakeemail@gmail.com,Student 1 - D/M/F - 1-1/2 Lesson,16.5,5/1/2019,|\
### Author:  [@Ralf](https://community.glideapps.com/u/Ralf)
#### Post date: [September 27, 2019, 3:09am UTC](https://community.glideapps.com/t/list-of-items-in-single-cell/555/8 "2019-09-27T03:09:49Z")
> [@filipa](#):
>
> |Attendees| Num |:-------|:-------| | Last, Peggy & Jim | 2 | | Smith, Bill | 2 | | Jones , Edythe | 1 | |===========|===| |Total Attending|5|
I use Table chart to display tabular data dynamically. 
---
### Author:  [@filipa](https://community.glideapps.com/u/filipa)
#### Post date: [September 27, 2019, 4:13am UTC](https://community.glideapps.com/t/list-of-items-in-single-cell/555/9 "2019-09-27T04:13:44Z")
thanks, @Jeff_Hager! actually, i experimented a bit and managed to do what i wanted. i’ll check your sheet, i’m sure i’ll learn something new! i had never delved into markdown, it’s an amazing new world to me, like magic! 🙂
---
### Author:  [@B\_Y](https://community.glideapps.com/u/B_Y)
#### Post date: [September 27, 2019, 4:47am UTC](https://community.glideapps.com/t/list-of-items-in-single-cell/555/10 "2019-09-27T04:47:33Z")
@Ralf … Can you please let us know on how to create a Table Chart?
Also, does the changes in values reflect immediately in the chart or does it take some time?
---
### Author:  [@Ralf](https://community.glideapps.com/u/Ralf)
#### Post date: [September 27, 2019, 6:07am UTC](https://community.glideapps.com/t/list-of-items-in-single-cell/555/11 "2019-09-27T06:07:57Z")
Table Chart is a Google Sheet Chart which you can find at bottom of the Chart menu.
It should update immediately if you put this at the end of the URL &data=DataThatChangesWhenChartChanges
Here is a link to a financial app with real time data from GOOGLEFINANCE where I extensively use Table Charts and other Google Charts. [https://navnalysis.glideapp.io/](https://navnalysis.glideapp.io/)
---
### Author:  [@B\_Y](https://community.glideapps.com/u/B_Y)
#### Post date: [September 27, 2019, 6:20am UTC](https://community.glideapps.com/t/list-of-items-in-single-cell/555/12 "2019-09-27T06:20:18Z")
Thats awesome! Thanks a lot @Ralf for this tip!! 🙂👍👌