# 🙏😍 Add Query function to Glide Tables, Please! **URL:** \ **Category:** Feature Requests\ **Created:** [February 10, 2021, 6:09am UTC](https://community.glideapps.com/t/add-query-function-to-glide-tables-please/22533 "2021-02-10T06:09:21Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Errcomp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/errcomp/32/13195_2.png) [@Errcomp](https://community.glideapps.com/u/Errcomp)\ **Post date:** [February 10, 2021, 6:09am UTC](https://community.glideapps.com/t/add-query-function-to-glide-tables-please/22533/1 "2021-02-10T06:09:22Z")
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 Points 1/1/2021 [a@gmail.com](mailto:a@gmail.com) 1 1/1/2021 [a@gmail.com](mailto:a@gmail.com) 1 1/2/2021 [b@gmail.com](mailto:b@gmail.com) 1 1/3/2021 [b@gmail.com](mailto:b@gmail.com) 1 2/1/2021 [a@gmail.com](mailto:a@gmail.com) 1 2/1/2021 [a@gmail.com](mailto:a@gmail.com) 1 2/2/2021 [b@gmail.com](mailto:b@gmail.com) 1 2/3/2021 [b@gmail.com](mailto:b@gmail.com) 1 And turning it into chart friendly data: Month user Sum Points 1 [a@gmail.com](mailto:a@gmail.com) 2 1 [b@gmail.com](mailto:b@gmail.com) 2 2 [a@gmail.com](mailto:a@gmail.com) 2 2 [b@gmail.com](mailto:b@gmail.com) 2 ---
**Author:** ![ThatGuyInArizona](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thatguyinarizona/32/12472_2.png) [@ThatGuyInArizona](https://community.glideapps.com/u/ThatGuyInArizona)\ **Post date:** [February 10, 2021, 5:03pm UTC](https://community.glideapps.com/t/add-query-function-to-glide-tables-please/22533/2 "2021-02-10T17:03:48Z")
If you mean something like SQL to query the data, yes i would LOVE that ! ---
**Author:** ![AymenM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aymenm/32/21370_2.png) [@AymenM](https://community.glideapps.com/u/AymenM)\ **Post date:** [February 10, 2021, 5:07pm UTC](https://community.glideapps.com/t/add-query-function-to-glide-tables-please/22533/3 "2021-02-10T17:07:03Z")
Hey ! Thank you for sharing your feature request with us ! Just to be sure, is your request not similar to this feature : > [@Tutorial - QUERY: "The most powerful function" in Google Sheets (part 1)](https://community.glideapps.com/t/tutorial-query-the-most-powerful-function-in-google-sheets-part-1/10432): > > This topic was inspired by our last community meetup, in which we talked about some formulas in Google Sheets and some people want to know more about QUERY, which was branded [“The most powerful function in Google Sheets”](https://www.benlcollins.com/spreadsheets/google-sheets-query-sql/) by famous GSheets teacher Ben Collins. So, what is QUERY, and why is it so powerful. Here’s a writeup on it, which hopefully would help many of you here in this community. Trust me, it would change so much how many of you “clean” your data in the future from raw data, in a very
 This is to avoid any duplicate message. ---
**Author:** ![Cisco\_Muratalla](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cisco_muratalla/32/12358_2.png) [@Cisco\_Muratalla](https://community.glideapps.com/u/Cisco_Muratalla)\ **Post date:** [February 10, 2021, 5:14pm UTC](https://community.glideapps.com/t/add-query-function-to-glide-tables-please/22533/4 "2021-02-10T17:14:48Z")
Hi @AymenM thank you for the great reference link. The functionality with the topic by @Errcomp is that individuals can vote for it, whereas the post by @ThinhDinh is a tutorial. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 10, 2021, 5:23pm UTC](https://community.glideapps.com/t/add-query-function-to-glide-tables-please/22533/5 "2021-02-10T17:23:49Z")
There is a difference with this request compared with @ThinhDinh’s tutorial. Yes, you can do queries in google sheets, but if you are running entirely on glide tables or want to avoid any google sheet lag, then a way to dynamically create a table with unique values based on another table would be beneficial. I currently build a google sheet based on data in another sheet, but if I could do that within glide, then I think there would be some performance increases. ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [February 10, 2021, 6:47pm UTC](https://community.glideapps.com/t/add-query-function-to-glide-tables-please/22533/6 "2021-02-10T18:47:10Z")
> [@Jeff\_Hager](#): > > a way to dynamically create a table with unique values based on another table would be beneficial Yes, we plan to allow you to ‘derive’ tables from other tables. For example, ‘create a table with the unique values in this column’. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 10, 2021, 7:21pm UTC](https://community.glideapps.com/t/add-query-function-to-glide-tables-please/22533/7 "2021-02-10T19:21:50Z")
Perfect! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 10, 2021, 10:54pm UTC](https://community.glideapps.com/t/add-query-function-to-glide-tables-please/22533/8 "2021-02-10T22:54:28Z")
Great to hear! ---
**Author:** ![Errcomp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/errcomp/32/13195_2.png) [@Errcomp](https://community.glideapps.com/u/Errcomp)\ **Post date:** [February 10, 2021, 11:12pm UTC](https://community.glideapps.com/t/add-query-function-to-glide-tables-please/22533/9 "2021-02-10T23:12:33Z")
@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 a query function within Glide Tables. I have an app currently that would benefit greatly from this feature! ---
**Author:** ![Errcomp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/errcomp/32/13195_2.png) [@Errcomp](https://community.glideapps.com/u/Errcomp)\ **Post date:** [February 10, 2021, 11:13pm UTC](https://community.glideapps.com/t/add-query-function-to-glide-tables-please/22533/10 "2021-02-10T23:13:43Z")
@david Fantastic! Can’t wait đŸ€© ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 14, 2021, 6:30am UTC](https://community.glideapps.com/t/add-query-function-to-glide-tables-please/22533/11 "2021-02-14T06:30:42Z")
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 itself. - Then create a Single Value column to get the first RowID out of that relation. - Then create an IF/Then column that returns ‘true’ if the row’s RowID matches the single value RowID. - Finally create any Rollup columns you need to sum data out of the relation. This will give you data that can be filtered using the ‘true’ column and that will have all of your summed data for each unique key. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 14, 2021, 7:42am UTC](https://community.glideapps.com/t/add-query-function-to-glide-tables-please/22533/12 "2021-02-14T07:42:43Z")
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. ---
**Author:** ![Errcomp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/errcomp/32/13195_2.png) [@Errcomp](https://community.glideapps.com/u/Errcomp)\ **Post date:** [February 14, 2021, 4:59pm UTC](https://community.glideapps.com/t/add-query-function-to-glide-tables-please/22533/13 "2021-02-14T16:59:56Z")
@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 every week. Does this method take out the manual aspect? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 14, 2021, 5:34pm UTC](https://community.glideapps.com/t/add-query-function-to-glide-tables-please/22533/14 "2021-02-14T17:34:15Z")
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 marked as true because only one of them will have the same rowid. ---
**Author:** ![Gerard\_Fernandez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gerard_fernandez/32/1183_2.png) [@Gerard\_Fernandez](https://community.glideapps.com/u/Gerard_Fernandez)\ **Post date:** [February 14, 2021, 6:11pm UTC](https://community.glideapps.com/t/add-query-function-to-glide-tables-please/22533/15 "2021-02-14T18:11:01Z")
I am using dates ( with seconds) instead of row IDs ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 14, 2021, 6:43pm UTC](https://community.glideapps.com/t/add-query-function-to-glide-tables-please/22533/16 "2021-02-14T18:43:08Z")
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 still all for a native solution. ---
**Author:** ![Kunal\_Bhadra](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kunal_bhadra/32/37451_2.png) [@Kunal\_Bhadra](https://community.glideapps.com/u/Kunal_Bhadra)\ **Post date:** [March 22, 2022, 6:04pm UTC](https://community.glideapps.com/t/add-query-function-to-glide-tables-please/22533/17 "2022-03-22T18:04:22Z")
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 ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [March 22, 2022, 6:17pm UTC](https://community.glideapps.com/t/add-query-function-to-glide-tables-please/22533/18 "2022-03-22T18:17:24Z")
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. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 23, 2022, 12:16am UTC](https://community.glideapps.com/t/add-query-function-to-glide-tables-please/22533/19 "2022-03-23T00:16:58Z")
> [@Kunal\_Bhadra](#): > > The objective is to get the public info Are you looking for a way to side-step Row Owners using computed columns? That’s not possible. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [March 23, 2022, 12:26am UTC](https://community.glideapps.com/t/add-query-function-to-glide-tables-please/22533/20 "2022-03-23T00:26:16Z")
Good point. Certain data protected by row owners in the user profile table cannot become public data by using computed columns such as a relation and lookup to extract the data into another table. You’ll just end up with a bunch of empty values for all users except the user that is signed in. The only way to do this in a way that will work is to actually write the data separately to each table, or if this a google sheet, then use a query formula to pull certain columns of data into another sheet table. [Next page](https://community.glideapps.com/t/add-query-function-to-glide-tables-please/22533.md?page=2)