What's the difference between Sheets and Tables?

One thing I’ve learned from Glide/ app building is that everything is possible.

Glide tables are your fastest option so I would use that as my first choice.

You could use a webhook with zapier or integromat and write the data to multiple GSheets at once in all of your apps (this is a little clunky and will be much much slower than synching with glide tables)

The 5K Table is a read only table.
So I dont have any option to upload all the data to the Glide table?

Thank you @ThinhDinh for pointing out that the data from glide tables DOES in fact get exported. And apologies to @Lin_Altshuler for the incorrect information.

I love learning from the experts here!

1 Like

At the moment it’s a no, you can’t mass upload a CSV or something like that yet. This might change in near future though.

@Eric_Penn I think this must be noted that computed columns won’t get exported :wink:

1 Like

@Darren_Murphy What is the best way to move Sheet data to a Glide Table?

Two options that I’m aware of:

The first option is a lot easier to implement and would probably be my preferred choice if the dataset isn’t too large. But for very large datasets then option 2 may be better.

1 Like

@Darren_Murphy Thank you!
What is the best way to link a Glide Table Column to Google Sheet?

Not sure I fully understand the question, Ralf.

Can you describe your use case?

I am planning to move the members register to a Glide Table. I need the column Members-ID in Google Sheets for various calculations.

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 to look at moving those into Glide instead.

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:

2 Likes

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 if you need to use it elsewhere. It really depends. In most of my apps I’ll have a mix of both Glide Tables and Google Sheets. For each new table/sheet that I add, I try to make a conscious decision about whether it should be a Glide Table or a Google Sheet. I don’t have any hard and fast rule, but it usually comes down to how I intend to use the data. If there is any likelihood that I’ll need it outside the app, then I’ll use a Google Sheet.

2 Likes

@Darren_Murphy For example, I am not sure how to produce this in Glide Tables only:

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

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 different matter. It will be possible, but it won’t be simple. Essentially you’ll need to create a CSS/HTML table structure as a template, and then plug in the data. Exactly how that’s done will depend on how your data is structured.

As I understand from our earlier exchange about this, what you’re currently doing is displaying that Google table shown in your screen shot in a webview in Glide, yes? But I would assume that most of the values in that table are drawn from other tables using formulas and lookups, yeah? For example, I can imagine that you probably have one table for golfers/members, another one for courses, probably another for scores, and a few more.

So if you want to translate this into pure glide, it’ll be a similar approach. All your raw data will be in a series of tables/sheets, and then you’d pull all that data together using relations, lookups, joined lists and other computed columns to feed into a template for display in the app. The only difference is that instead of doing all the heavy lifting in the Google Sheet, it’s done in Glide.

The last time we had this discussion it was mostly about whether or not this was possible in Glide. I was arguing that it is - and I still firmly believe that it is. But whether or not it’s worth going to all this trouble with your app is another question. If what you currently have is getting the job done, then maybe it’s not worth the bother?

If you decide that it is, I’ll certainly be interested to see how you get on, and will help in any way that I can.

2 Likes

@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 different Glide Apps and that I understand that Glide Tables can be shared between applications. Today I am using IMPORTRANGE to share this data and I have noticed that this could be fragile.

It would have been nice if Sheets could get data from Tables, is it worth putting this as a feature request, what do you think?

1 Like

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

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…

1 Like

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?

If your add row or add form is adding data to a google sheet, then it will be stored and show up in the google sheet. If your add row or add form is adding data to a glide table, then it will only store data in the glide table. Glide tables are not connected to google sheets. The data in a glide table only lives in glide.

1 Like