What is the best way to create Table view?

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?

3 Likes

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

Thanks @Ralf for this brilliant idea… let’s see if anyone suggest other ways of doing this. :blush:

Yes I like what @Ralf is doing.
Didn’t this discussion give you your answers?

@George_B I wanted to know if anyone has a solution other than markdown and table chart. :slightly_smiling_face:

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?

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.

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

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:

1 Like

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.

1 Like

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! :blush:

@Sidney_Kunst This is the formula that I have in the cell. Hope it helps. :blush:

=("|"&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

You are welcome! :blush::+1: