B_Y
September 27, 2019, 4:59am
1
I have been using MarkDown for creating tables. {By concatenating cell values and CHAR(10) for new lines.} (Attached screenshot)
But, I always feel that itβs incomplete without those vertical and horizontal borders.
Are there any alternative ways to create tables in Glide?
4 Likes
Ralf
September 27, 2019, 6:27am
2
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/
1 Like
B_Y
September 27, 2019, 8:50am
3
Thanks @Ralf for this brilliant ideaβ¦ letβs see if anyone suggest other ways of doing this.
Yes I like what @Ralf is doing.
Didnβt this discussion give you your answers?
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|
B_Y
September 27, 2019, 2:05pm
5
@George_B I wanted to know if anyone has a solution other than markdown and table chart.
Krivo
September 27, 2019, 2:16pm
6
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?
Ralf
September 27, 2019, 2:46pm
7
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.
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.
Ralf
September 27, 2019, 3:28pm
9
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
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!
1 Like
Krivo
September 27, 2019, 4:55pm
10
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:
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β¦
1 Like
Ralf
September 27, 2019, 5:24pm
11
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.
2 Likes
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!
B_Y
October 2, 2019, 10:59am
13
@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 & β|β )
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!
1 Like
@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
1 Like
Are you am saying you want to add 300k rows? If so take note π Glide Tables
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
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
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.
2 Likes
What its the HTML table @ThinhDinh