As things shift towards Glide Tables, I would LOVE a querying function in glide tables. Being able to aggregate and group data would make the tool extremely powerful because you can then make high value charts and dashboards. An example: taking this data: Date User …

@AymenM thanks for the question. As @Jeff_Hager mentioned, this would be different than the tutorial from @ThinhDinh . Its a great tutorial, and I love using the query function in google sheets, but as Glide Tables provides better responsiveness and higher capacity, I would want to also be able to do…

@david Fantastic! Can’t wait :star_struck:

Just want to add to this…if you need a workaround for now…what I would do is first make sure you have enabled the RowID column in your sheet. Then create a template with the unique key values you would normally select for a query. Then create a multiple relation that links that template back to it…

This is such a powerful technique, and has so may different applications. I use this a lot now to create filtered lists - it removes the need to apply filtering to list components.

@Jeff_Hager I think I understand. I will give that a try! I have a workaround right now where I manually put in the unique values for the query grouping then relate that to the data set, then rollup up those relations. That means for weekly rollups I have to manually type in a new week into the GT e…

Yes, it would all be automatic because it’s all in the same existing sheet. The Single value column is only pulling back one rowid from the matching set of keys and that single value will always be the FIRST matching row from the relation. That way, only one of your rows in each group will be mark…

I am using dates ( with seconds) instead of row IDs

I do have to add, that a built in solution from glide would still be better. Not only would it probably be less overhead processing, but a separate sheet would allow you to have a separate details layout since it would be a separate sheet. But that all depends on how your app is laid out. I’m sti…

Is there any way we can get whole column values from the other table (not just rollup sums) at once? The objective is to get the public info only from one table into another automatically

A relation and lookup should work for that if there is a common value in both tables that you can use to create the relation.

🙏😍 Add Query function to Glide Tables, Please!

Feature Requests

Jeff_Hager June 21, 2022, 11:28am 25

Something like this.

Topic		Replies	Views
What's the difference between Sheets and Tables? Community Resources	59	7037	October 19, 2024
🆕 Glide Tables General	123	8214	April 20, 2021
Import your Glide Table into any Google Sheet, with 1 formula! Project Showcase	19	1064	July 16, 2023
Query funtion in glide table Ask for Help	1	30	August 22, 2024
Glide Big Tables API! Get your big table to your google sheet! Community Resources tutorial	5	872	November 1, 2023

🙏😍 Add Query function to Glide Tables, Please!

Related topics