# Workaround for filtering by some computed columns in glide big tables

**URL:** <https://community.glideapps.com/t/workaround-for-filtering-by-some-computed-columns-in-glide-big-tables/79701>\
**Category:** Community Resources\
**Tags:** big-tables\
**Created:** [February 1, 2025, 1:57am UTC](https://community.glideapps.com/t/workaround-for-filtering-by-some-computed-columns-in-glide-big-tables/79701 "2025-02-01T01:57:26Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Eitan](https://avatars.discourse-cdn.com/v4/letter/e/aca169/32.png) [@Eitan](https://community.glideapps.com/u/Eitan)\
**Post date:** [February 1, 2025, 1:57am UTC](https://community.glideapps.com/t/workaround-for-filtering-by-some-computed-columns-in-glide-big-tables/79701/1 "2025-02-01T01:57:26Z")

</div>

Hello!

I have been employing a technique to work around some of the filtering limitations of glide big tables which I have not seen mentioned around here.

For example, I have a table of bookings which are related to different schools, so each booking is for a particular school. Now if I want to filter those bookings by school type which is a non-computed column in the schools table I can’t do it through a lookup column at the moment with big tables.

What I have been doing is creating two queries.

1. One query is for the schools table where I filter that column by the school type and then I created a joined list of all the rowIDs from that query.

2. Then I make another query for the bookings table and in that query I specify if the schoolID column is included in the joined list of rowIDs from the school query.

this can also be fully dynamic with a custom filtering system where I create user specific columns that the user inputs the school type and it queries the school table which in turn queries the bookings table for those specific schools.

I hope this makes sense and is something useful for everyone! I can always make a video if it need be for more clarity

---

<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:** [February 1, 2025, 5:01am UTC](https://community.glideapps.com/t/workaround-for-filtering-by-some-computed-columns-in-glide-big-tables/79701/2 "2025-02-01T05:01:34Z")

</div>

Yes. I’ve been using variations of the same approach. Works well 👍