# Query funtion in glide table

**URL:** <https://community.glideapps.com/t/query-funtion-in-glide-table/75792>\
**Category:** Ask for Help\
**Created:** [August 22, 2024, 3:34pm UTC](https://community.glideapps.com/t/query-funtion-in-glide-table/75792 "2024-08-22T15:34:23Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Chris\_Heck](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chris_heck/32/453_2.png) [@Chris\_Heck](https://community.glideapps.com/u/Chris_Heck)\
**Post date:** [August 22, 2024, 3:34pm UTC](https://community.glideapps.com/t/query-funtion-in-glide-table/75792/1 "2024-08-22T15:34:23Z")

</div>

So currently i do a cfb pickem league where every week each person picks 5 games. At the end of the week i update if the person got them right or wrong and it all goes into one spread sheet i have on google sheets. well now every time someone submits there answers it is using one of my updates and i only get 500 a month. problem is i have about 100+ people submiting their 5 games every week so that is going to get used up pretty fast. I want to move it to a glide table i guess (not by choice) but on the app i built i query the spread sheet that has the history of each users picks to show for the year how many they got right and wrong. What their past picks were and a bunch of other data. So my question is is there a way that i can do the same thing somehow if i use a glide table and just pull all the data for a specific user to display differt things. i Use the query Select Sum funtion and i dont know if glide table can do that.

---

<div class="post-metadata">

**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:** [August 22, 2024, 4:19pm UTC](https://community.glideapps.com/t/query-funtion-in-glide-table/75792/2 "2024-08-22T16:19:15Z")

</div>

Have a look at the Glide Query column. I suspect you could use that and then a series of rollup columns to get what you want.

> **[Query Column | Glide Docs](https://www.glideapps.com/docs/automation/computed-columns/query-column)**
>
> Create complex relations in your data with conditional filtering, sorting, and limits.