# šŸ†• Query column! **URL:** \ **Category:** Community Resources\ **Created:** [May 4, 2023, 12:28am UTC](https://community.glideapps.com/t/query-column/61320 "2023-05-04T00:28:30Z")\ **Posts on this page:** 20\ **Page:** 1
**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:** [May 4, 2023, 12:28am UTC](https://community.glideapps.com/t/query-column/61320/1 "2023-05-04T00:28:30Z")
This request has been brought to life. > [@Conditional Relations](https://community.glideapps.com/t/conditional-relations/13818/): > > I know myself and others have made this case before, but Iā€™d like to mention it again. I think it would be hugely benificial to be able to apply IF conditions within Relation settings. My use case for this is to get the unpaid dollar amount from unpaid invoices. I have invoices for students that, letā€™s say, are billed monthly. The user creates the billing period for a particular month, and any lessons that have occured within that billing period are automatically included in that invoice. Inā€¦ See Markā€™s video here. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [May 4, 2023, 12:32am UTC](https://community.glideapps.com/t/query-column/61320/2 "2023-05-04T00:32:59Z")
Itā€™s AMAZING. This is going to reduce so many columns when creating ā€œconditional relationsā€. After playing around with this, the first thing I learned is that the output is ALWAYS a ā€œmultiple relationā€. Going to be huge in the world of gamification! ---
**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:** [May 4, 2023, 12:34am UTC](https://community.glideapps.com/t/query-column/61320/3 "2023-05-04T00:34:27Z")
Please share videos if you want here, we would love to see your applications šŸ˜‰ ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [May 4, 2023, 12:36am UTC](https://community.glideapps.com/t/query-column/61320/4 "2023-05-04T00:36:41Z")
So bad I donā€™t use glide rows anymore šŸ˜‰ That would be useful a year agoā€¦ now I do everything with Javaā€¦ but a nice feature for a small database. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [May 4, 2023, 12:36am UTC](https://community.glideapps.com/t/query-column/61320/5 "2023-05-04T00:36:51Z")
First thing that came to mindā€¦before this took either a complicated series of array columns or a tedious/static if then else column: The `this row` filter is going to be MAGICAL! āœØ ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [May 4, 2023, 12:43am UTC](https://community.glideapps.com/t/query-column/61320/6 "2023-05-04T00:43:23Z")
Where do you get this Query columnā€¦ I canā€™t find itā€¦ only in Staging? ---
**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:** [May 4, 2023, 12:58am UTC](https://community.glideapps.com/t/query-column/61320/7 "2023-05-04T00:58:10Z")
Yes, I stated that in the title. Edit: Itā€™s now in production! ---
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [May 4, 2023, 5:14pm UTC](https://community.glideapps.com/t/query-column/61320/8 "2023-05-04T17:14:26Z")
Rookie question: who has access to stuff like this in staging? (I have a pro account and have signed up for developmental stuff like integrations) ---
**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:** [May 4, 2023, 5:17pm UTC](https://community.glideapps.com/t/query-column/61320/9 "2023-05-04T17:17:21Z")
Anyone and everyone has access, just go to [https://staging.heyglide.com/](https://staging.heyglide.com/) Because itā€™s a staging environment, the usual caveats apply. ie. nothing is guaranteed to work, and stuff that is working can break at any time without notice. ---
**Author:** ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)\ **Post date:** [May 4, 2023, 6:06pm UTC](https://community.glideapps.com/t/query-column/61320/10 "2023-05-04T18:06:24Z")
Just signed up for staging.heyglideā€¦ ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/0/b075e16a7431d4ae80d2f5fa49e818bdb606c5ec.png) I do not see query. It seemed to be above relation in Markā€™s demo. Do I have to upgrade an account or ā€¦? Thanks ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/c/2cf2dccf17653ee9ab7048ad51b1168ab7a85481.png) ---
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [May 4, 2023, 9:30pm UTC](https://community.glideapps.com/t/query-column/61320/11 "2023-05-04T21:30:44Z")
But ā€˜So bad I donā€™t use glide rows anymoreā€™ ? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [May 4, 2023, 9:44pm UTC](https://community.glideapps.com/t/query-column/61320/12 "2023-05-04T21:44:03Z")
Nopeā€¦ only JSON šŸ˜‰ ---
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [May 4, 2023, 9:50pm UTC](https://community.glideapps.com/t/query-column/61320/13 "2023-05-04T21:50:49Z")
> [@Uzo](#): > > Where do you get this Query column So you wonā€™t be really interested in ā€˜Where do you get this Query columnā€™ I assume? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [May 4, 2023, 9:57pm UTC](https://community.glideapps.com/t/query-column/61320/14 "2023-05-04T21:57:02Z")
Ohā€¦ no, sometimes I have small apps under 500 rowsā€¦ so that can be useful šŸ˜‰ ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [May 4, 2023, 10:15pm UTC](https://community.glideapps.com/t/query-column/61320/15 "2023-05-04T22:15:58Z")
Mark, you say itā€™s a ā€œlittle featureā€, maybe this was said tongue in cheek. This feels like a big deal. Thank you so much for developing this. ---
**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:** [May 4, 2023, 11:30pm UTC](https://community.glideapps.com/t/query-column/61320/16 "2023-05-04T23:30:06Z")
Have you enabled it in previews on the team level? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/e/5e3756d4cfd466dfe7f8c6d5963db4c64816668d.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/3/b3648977c82c2e466273f9649a3848e535a162c2.png) ---
**Author:** ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)\ **Post date:** [May 4, 2023, 11:51pm UTC](https://community.glideapps.com/t/query-column/61320/17 "2023-05-04T23:51:58Z")
Nope. I signed up for the beta which showed integrations. Will try this now - thanks for the tip! ---
**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:** [May 4, 2023, 11:55pm UTC](https://community.glideapps.com/t/query-column/61320/18 "2023-05-04T23:55:22Z")
Itā€™s already in production now, if you want to test it there, instead of staging. Please go through the same flow of enabling it in Previews. ---
**Author:** ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)\ **Post date:** [May 4, 2023, 11:59pm UTC](https://community.glideapps.com/t/query-column/61320/19 "2023-05-04T23:59:32Z")
Done - thanks again! ---
**Author:** ![Antonino\_Nolasco](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/antonino_nolasco/32/80601_2.png) [@Antonino\_Nolasco](https://community.glideapps.com/u/Antonino_Nolasco)\ **Post date:** [May 5, 2023, 11:48am UTC](https://community.glideapps.com/t/query-column/61320/20 "2023-05-05T11:48:38Z")
Greaaaaaaat news!!! I just deleted about 50 template columns from my apps thanks to new query column. I love you guys!!! [Next page](https://community.glideapps.com/t/query-column/61320.md?page=2)