# What is the best way to create Table view? **URL:** \ **Category:** Ask for Help\ **Created:** [September 27, 2019, 4:59am UTC](https://community.glideapps.com/t/what-is-the-best-way-to-create-table-view/630 "2019-09-27T04:59:42Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![B\_Y](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/b_y/32/114_2.png) [@B\_Y](https://community.glideapps.com/u/B_Y)\ **Post date:** [September 27, 2019, 4:59am UTC](https://community.glideapps.com/t/what-is-the-best-way-to-create-table-view/630/1 "2019-09-27T04:59:42Z")
I have been using MarkDown for creating tables. {By concatenating cell values and CHAR(10) for new lines.} (Attached screenshot) ![Screenshot_20190927-102831](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/5cd8b2c2df079ae0be0c6098107797734de10768.jpeg) But, I always feel that it’s incomplete without those vertical and horizontal borders. Are there any alternative ways to create tables in Glide? ---
**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\ **Post date:** [September 27, 2019, 6:27am UTC](https://community.glideapps.com/t/what-is-the-best-way-to-create-table-view/630/2 "2019-09-27T06:27:20Z")
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://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/b_y/32/114_2.png) [@B\_Y](https://community.glideapps.com/u/B_Y)\ **Post date:** [September 27, 2019, 8:50am UTC](https://community.glideapps.com/t/what-is-the-best-way-to-create-table-view/630/3 "2019-09-27T08:50:45Z")
Thanks @Ralf for this brilliant idea… let’s see if anyone suggest other ways of doing this. 😊 ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [September 27, 2019, 1:33pm UTC](https://community.glideapps.com/t/what-is-the-best-way-to-create-table-view/630/4 "2019-09-27T13:33:06Z")
Yes I like what @Ralf is doing. Didn’t this discussion give you your answers? > [@List of items in single cell](https://community.glideapps.com/t/list-of-items-in-single-cell/555/4): > > It’s part of the markdown, the Title of the table. If this worked for you please mark it as the Solution, thanks. |Attendees| Num |:-------|:-------| | Last, Peggy & Jim | 2 | | Smith, Bill | 2 | | Jones , Edythe | 1 | |===========|===| |Total Attending|5| ---
**Author:** ![B\_Y](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/b_y/32/114_2.png) [@B\_Y](https://community.glideapps.com/u/B_Y)\ **Post date:** [September 27, 2019, 2:05pm UTC](https://community.glideapps.com/t/what-is-the-best-way-to-create-table-view/630/5 "2019-09-27T14:05:17Z")
@George_B I wanted to know if anyone has a solution other than markdown and table chart. πŸ™‚ ---
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [September 27, 2019, 2:16pm UTC](https://community.glideapps.com/t/what-is-the-best-way-to-create-table-view/630/6 "2019-09-27T14:16:29Z")
Hi Ralf I wonder if you have real update times. My experience is that it is not real-time. Maybe minutes. This is not sufficient for apps where a user inputs data and want to see immediate change in chart/table. But might be just fine for you? ---
**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\ **Post date:** [September 27, 2019, 2:46pm UTC](https://community.glideapps.com/t/what-is-the-best-way-to-create-table-view/630/7 "2019-09-27T14:46:19Z")
Google claims a delay of up to 20 minutes. Stockholm is updated within 5 minutes which is good enough for my app. However, sometimes there is a longer delay between what I see in Sheet and what I see in Glide. I suspect a cache memory problem. ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [September 27, 2019, 2:47pm UTC](https://community.glideapps.com/t/what-is-the-best-way-to-create-table-view/630/8 "2019-09-27T14:47:31Z")
Realtime updates, for any calculation that your connected spreadsheet has to do, is not going to happen under the current iteration of Glide. Once Glide starts letting you put calcs within the databases that the app is directly connected to, which is something that is on their road map, then you will get realtime for those calcs. ---
**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\ **Post date:** [September 27, 2019, 3:28pm UTC](https://community.glideapps.com/t/what-is-the-best-way-to-create-table-view/630/9 "2019-09-27T15:28:38Z")
An Alternative is to publish a part of the sheet as html as I do in my financial app. [https://docs.google.com/spreadsheets/d/1vHhLvevHqBFMCzwpGhJFkLotybrCQGYYMMgI6OeSCMU/htmlembed/sheet?gid=0&range=O2:S28](https://docs.google.com/spreadsheets/d/1vHhLvevHqBFMCzwpGhJFkLotybrCQGYYMMgI6OeSCMU/htmlembed/sheet?gid=0&range=O2:S28) The link is dynamic so changes in sheet are shown without delay. Or more correctly, the links content is created on the fly every time you click it! ---
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [September 27, 2019, 4:55pm UTC](https://community.glideapps.com/t/what-is-the-best-way-to-create-table-view/630/10 "2019-09-27T16:55:59Z")
Glide do not recommend using html - they might break the possibility to have that working. Depending on you needs you could use tables to create a visual representation. Have a look on this post: > [@Personal budget app with table chart](https://community.glideapps.com/t/personal-budget-app-with-table-chart/659): > > This app is an extension of the template app β€œPersonal budget” Update of charts in glide is slow - taking maybe 5-20 minutes. The chart shown on front page of app is therefore not very relevant while the user inputs data. But there is other ways of giving an overview of you spending - I have in the app named a tab β€˜status’. The idea is to use a table layout. The update is done within a very few seconds - and in that way it seems feasible to put in along side the expenses. Notice also the tab… ---
**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\ **Post date:** [September 27, 2019, 5:24pm UTC](https://community.glideapps.com/t/what-is-the-best-way-to-create-table-view/630/11 "2019-09-27T17:24:03Z")
Please note that the sheet table in html format is created in a new browser tab outside of Glide! Inside glide is only a standard URL link, no html. ---
**Author:** ![Sidney\_Kunst](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sidney_kunst/32/603_2.png) [@Sidney\_Kunst](https://community.glideapps.com/u/Sidney_Kunst)\ **Post date:** [October 1, 2019, 11:14am UTC](https://community.glideapps.com/t/what-is-the-best-way-to-create-table-view/630/12 "2019-10-01T11:14:26Z")
Wow, can you please send me. I tried to do this EXCACT thing. If you can post the formula that is in the cell, that would be awesome! 😊 ---
**Author:** ![B\_Y](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/b_y/32/114_2.png) [@B\_Y](https://community.glideapps.com/u/B_Y)\ **Post date:** [October 2, 2019, 10:59am UTC](https://community.glideapps.com/t/what-is-the-best-way-to-create-table-view/630/13 "2019-10-02T10:59:40Z")
@Sidney_Kunst This is the formula that I have in the cell. Hope it helps. 😊 =("| **"&A1& "** | **Player** | **Played** | **Won** | **Lost** | **Win %** |" & char(10) & β€œ| :------: | :------: | :-----: | :-----: | :-----: | :------: |” & char(10) & β€œ|” & A2 & β€œ|” & B2 & β€œ|” & C2 & β€œ|” & D2 & β€œ|” & E2 & β€œ|” & F2 & β€œ|” & char(10) & β€œ|” & A3 & β€œ|” & B3 & β€œ|” & C3 & β€œ|” & D3 & β€œ|” & E3 & β€œ|” & F3 & β€œ|” & char(10) & β€œ|” & A4 & β€œ|” & B4 & β€œ|” & C4 & β€œ|” & D4 & β€œ|” & E4 & β€œ|” & F4 & β€œ|” & char(10) & β€œ|” & A5 & β€œ|” & B5 & β€œ|” & C5 & β€œ|” & D5 & β€œ|” & E5 & β€œ|” & F5 & β€œ|” & char(10) & β€œ|” & A6 & β€œ|” & B6 & β€œ|” & C6 & β€œ|” & D6 & β€œ|” & E6 & β€œ|” & F6 & β€œ|” & char(10) & β€œ|” & A7 & β€œ|” & B7 & β€œ|” & C7 & β€œ|” & D7 & β€œ|” & E7 & β€œ|” & F7 & β€œ|” & char(10) & β€œ|” & A8 & β€œ|” & B8 & β€œ|” & C8 & β€œ|” & D8 & β€œ|” & E8 & β€œ|” & F8 & β€œ|” & char(10) & β€œ|” & A9 & β€œ|” & B9 & β€œ|” & C9 & β€œ|” & D9 & β€œ|” & E9 & β€œ|” & F9 & β€œ|” & char(10) & β€œ|” & A10 & β€œ|” & B10 & β€œ|” & C10 & β€œ|” & D10 & β€œ|” & E10 & β€œ|” & F10 & β€œ|” & char(10) & β€œ|” & A11 & β€œ|” & B11 & β€œ|” & C11 & β€œ|” & D11 & β€œ|” & E11 & β€œ|” & F11 & β€œ|” & char(10) & β€œ|” & A12 & β€œ|” & B12 & β€œ|” & C12 & β€œ|” & D12 & β€œ|” & E12 & β€œ|” & F12 & β€œ|” & char(10) & β€œ|” & A13 & β€œ|” & B13 & β€œ|” & C13 & β€œ|” & D13 & β€œ|” & E13 & β€œ|” & F13 & β€œ|” & char(10) & β€œ|” & A14 & β€œ|” & B14 & β€œ|” & C14 & β€œ|” & D14 & β€œ|” & E14 & β€œ|” & F14 & β€œ|” & char(10) & β€œ|” & A15 & β€œ|” & B15 & β€œ|” & C15 & β€œ|” & D15 & β€œ|” & E15 & β€œ|” & F15 & β€œ|” & char(10) & β€œ|” & A16 & β€œ|” & B16 & β€œ|” & C16 & β€œ|” & D16 & β€œ|” & E16 & β€œ|” & F16 & β€œ|” & char(10) & β€œ|” & A17 & β€œ|” & B17 & β€œ|” & C17 & β€œ|” & D17 & β€œ|” & E17 & β€œ|” & F17 & β€œ|” & char(10) & β€œ|” & A18 & β€œ|” & B18 & β€œ|” & C18 & β€œ|” & D18 & β€œ|” & E18 & β€œ|” & F18 & β€œ|” & char(10) & β€œ|” & A19 & β€œ|” & B19 & β€œ|” & C19 & β€œ|” & D19 & β€œ|” & E19 & β€œ|” & F19 & β€œ|” & char(10) & β€œ|” & A20 & β€œ|” & B20 & β€œ|” & C20 & β€œ|” & D20 & β€œ|” & E20 & β€œ|” & F20 & β€œ|” & char(10) & β€œ|” & A21 & β€œ|” & B21 & β€œ|” & C21 & β€œ|” & D21 & β€œ|” & E21 & β€œ|” & F21 & β€œ|” & char(10) & β€œ|” & A22 & β€œ|” & B22 & β€œ|” & C22 & β€œ|” & D22 & β€œ|” & E22 & β€œ|” & F22 & β€œ|” & char(10) & β€œ|” & A23 & β€œ|” & B23 & β€œ|” & C23 & β€œ|” & D23 & β€œ|” & E23 & β€œ|” & F23 & β€œ|” & char(10) & β€œ|” & A24 & β€œ|” & B24 & β€œ|” & C24 & β€œ|” & D24 & β€œ|” & E24 & β€œ|” & F24 & β€œ|” & char(10) & β€œ|” & A25 & β€œ|” & B25 & β€œ|” & C25 & β€œ|” & D25 & β€œ|” & E25 & β€œ|” & F25 & β€œ|” & char(10) & β€œ|” & A26 & β€œ|” & B26 & β€œ|” & C26 & β€œ|” & D26 & β€œ|” & E26 & β€œ|” & F26 & β€œ|” ) ---
**Author:** ![Sidney\_Kunst](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sidney_kunst/32/603_2.png) [@Sidney\_Kunst](https://community.glideapps.com/u/Sidney_Kunst)\ **Post date:** [October 2, 2019, 11:34am UTC](https://community.glideapps.com/t/what-is-the-best-way-to-create-table-view/630/14 "2019-10-02T11:34:22Z")
Thanks a million! I tried to figure this out the other day and left it because it took me too long. Now I know how it IS possible! Superb! ---
**Author:** ![B\_Y](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/b_y/32/114_2.png) [@B\_Y](https://community.glideapps.com/u/B_Y)\ **Post date:** [October 2, 2019, 11:54am UTC](https://community.glideapps.com/t/what-is-the-best-way-to-create-table-view/630/15 "2019-10-02T11:54:27Z")
You are welcome! πŸ˜ŠπŸ‘ ---
**Author:** ![Yasin\_Hassanien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yasin_hassanien/32/9042_2.png) [@Yasin\_Hassanien](https://community.glideapps.com/u/Yasin_Hassanien)\ **Post date:** [October 11, 2020, 8:06am UTC](https://community.glideapps.com/t/what-is-the-best-way-to-create-table-view/630/16 "2020-10-11T08:06:57Z")
@ThinhDinh and @Jeff_Hager What are the best ways now to use the table view since we will be using the data of glide table instead of google sheet and I was using google data studio rather than anything in glide but now we have to push around 300K data in glide tables and wondering how to show the user a table view now and reporting πŸ€” ---
**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:** [October 11, 2020, 9:48am UTC](https://community.glideapps.com/t/what-is-the-best-way-to-create-table-view/630/17 "2020-10-11T09:48:37Z")
Are you am saying you want to add 300k rows? If so take note [πŸ†• Glide Tables](https://community.glideapps.com/t/glide-tables/15597/36) ---
**Author:** ![Yasin\_Hassanien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yasin_hassanien/32/9042_2.png) [@Yasin\_Hassanien](https://community.glideapps.com/u/Yasin_Hassanien)\ **Post date:** [October 11, 2020, 10:18am UTC](https://community.glideapps.com/t/what-is-the-best-way-to-create-table-view/630/18 "2020-10-11T10:18:24Z")
Nope that’s not what I meant I need to show to the user a table view with columns and rows such as this example [https://drive.google.com/file/d/1g\_bRxojJAf7mrHiRstgUSidfzhMHL7UV/view?usp=sharing](https://drive.google.com/file/d/1g_bRxojJAf7mrHiRstgUSidfzhMHL7UV/view?usp=sharing) So we will have a huge data inserted one by one into glide tables since its going to be better to hold data So what are the best way to show to user in that view ---
**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:** [October 11, 2020, 10:35am UTC](https://community.glideapps.com/t/what-is-the-best-way-to-create-table-view/630/19 "2020-10-11T10:35:03Z")
I think you have to resort to a HTML table for this. Glide’s basic table only supports two columns. Markdown doesn’t support extra icons, pretty hard to generate one that aligns the right way as well. ---
**Author:** ![Yasin\_Hassanien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yasin_hassanien/32/9042_2.png) [@Yasin\_Hassanien](https://community.glideapps.com/u/Yasin_Hassanien)\ **Post date:** [October 11, 2020, 12:13pm UTC](https://community.glideapps.com/t/what-is-the-best-way-to-create-table-view/630/20 "2020-10-11T12:13:34Z")
What its the HTML table @ThinhDinh [Next page](https://community.glideapps.com/t/what-is-the-best-way-to-create-table-view/630.md?page=2)