Google Sheet does not match data view in Glide

The logo is just an image with a lot of empty space on the left. It functions as a button to take the user to an “About” screen.

“CHALLENGE PERIOD” is just a Glide Basic Text component.

I fiddled around to determine the color and size of the header font (color: #666666; font-weight: 400; font-size: 0.857em;) so I could mimic it in the table.

The table itself was a lot of trial and error in Markdown. Here’s the formula in the cell:

="<span style='color: #666666; font-weight: 400; font-size: 0.857em;'>PROGRESS</span>
| Rank & name &nbsp; | &nbsp; To date &nbsp; | &nbsp; Week 3 (#) &nbsp; | &nbsp; Last &nbsp; |
| :--- | :---: | :---: | :---: |
| 1. Victor | 7% | 1 | Today |
| 2. Andrew | 0% | 0 | na |
| 3. apertur.co | 0% | 0 | na |
| 4. Claudia | 0% | 0 | na |
| 5. Ernesto | 0% | 0 | na |
| 6. Guusje | 0% | 0 | 1 d |
| 7. Laura | 0% | 0 | 1 d |
| 8. Lexi | 0% | 0 | na |"

This is built up from the first two rows + CONCATENATE of the column containing the per-user data. It’s all dynamic, based on the names or users and their posts.

We’ve been warned that Glide may not support HTML formatting (the first line beginning with "<span style=...) in the future. I try to use it sparingly and just stick to Markdown. There are a lot of online tutorials.

3 Likes