I have noticed that many new users appear to get a little confused when it comes to understanding what constitutes a sheet vs a table, and how they interact. The introduction of Glide Tables a while back has possibly exacerbated this situation somewhat. So I’m creating this FAQ topic in an attempt …

Ah, I see. That’s a bit tricky. I think you’d need to leave your existing Google Sheet intact with at least that column, and then make sure it’s updated when new members join. That could get rather fiddly. I don’t know what your calculations in the sheet are like, but I think I’d be more inclined …

[image] Darren_Murphy: Out of curiosity, what’s your reason for moving this sheet to a Glide Table? I love the flexibility of Google Sheets but sooner or later it is better to move everything to Glide Tables if I understand you @Darren_Murphy correctly :nerd_face:

haha, okay… Well, yes and no. I’m certainly a big fan of avoiding spreadsheet formulas and using Glide computed columns instead where ever possible. But that doesn’t mean all the data needs to live in Glide Tables. I think it can often make sense to leave your data in Google Sheets - especially i…

@Darren_Murphy For example, I am not sure how to produce this in Glide Tables only: [Screenshot_20211024-114439]

Do you mean the presentation, or the calculations, or both?

:joy: Okay… I think the calculations would be the easy bit. I’m a golfer (or at least I sometimes pretend to be one), so I’m familiar with the types of calculations that need to be done, and I can’t think of anything that would be much of a challenge with Glide computed columns. That table is a d…

@Darren_Murphy Thank you very much, your assumptions are quite right! However, I think I have to remain in Sheets since it will take too much time and energy and I am not at all familiar with CSS. The main reason for moving the Members register to Tables is that register data is used in three dif…

[image] Ralf: However, I think I have to remain in Sheets since it will take too much time and energy and I am not at all familiar with CSS. I suspected that might be the case, and I don’t blame you. If it ain’t broke, don’t fix it :smiley: [image] Ralf: The main reason for moving the Me…

Newbie question here: am I understanding this correctly → If using a Google Sheet as the app source, any public user who adds a new “item” will add a new row to the source Sheet? Does this occur if the source is a Glide Table?

What's the difference between Sheets and Tables?

Community Resources

Darren_Murphy October 24, 2021, 1:44pm 50

I suspected that might be the case, and I don’t blame you. If it ain’t broke, don’t fix it

Yes, this makes perfect sense.

Would a CSV export be good enough for your purposes?
This is certainly possible - I did a short tutorial on this a while back…

Topic		Replies	Views
🆕 Glide Tables General	123	8234	April 20, 2021
Convert existing Sheets-based tab (data, computed columns) to Glide Table Feature Requests	66	4000	April 15, 2025
Import Data From Excel & Sheets into Glide Table Feature Requests	33	8225	June 7, 2022
Manage Data in Glide Table Ask for Help	12	523	August 18, 2022
Import your Glide Table into any Google Sheet, with 1 formula! Project Showcase	19	1064	July 16, 2023

What's the difference between Sheets and Tables?

Related topics