# Multi Filters using Relations: a new way šŸ’” **URL:** \ **Category:** Ask for Help\ **Created:** [December 18, 2021, 11:32pm UTC](https://community.glideapps.com/t/multi-filters-using-relations-a-new-way/36092 "2021-12-18T23:32:34Z")\ **Posts on this page:** 10\ **Page:** 2
**Author:** ![Guillaume\_RABALLAND](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/guillaume_raballand/32/35847_2.png) [@Guillaume\_RABALLAND](https://community.glideapps.com/u/Guillaume_RABALLAND)\ **Post date:** [September 27, 2023, 12:39am UTC](https://community.glideapps.com/t/multi-filters-using-relations-a-new-way/36092/21 "2023-09-27T00:39:07Z")
Yes, you can now filter using built-in ā€œin-appā€ filters on several columns for the same collection or list, it was a great news when they released this update as it was highly requested! šŸ˜‰ It works as an AND operator for all the filters where you select at least 1 value, and does not filter the columns where you select all or none of the values in the filter. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/f/df50085147a031a41b6e0673bacd7bf1987d8e0a.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/b/8b1b0ea7c5a00767e0c1bd67237d00656de9101d.png) ---
**Author:** ![Gui\_Rodrigues\_Goncal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gui_rodrigues_goncal/32/41584_2.png) [@Gui\_Rodrigues\_Goncal](https://community.glideapps.com/u/Gui_Rodrigues_Goncal)\ **Post date:** [September 27, 2023, 11:47am UTC](https://community.glideapps.com/t/multi-filters-using-relations-a-new-way/36092/22 "2023-09-27T11:47:28Z")
The built-in ā€œin-appā€ filters are excelent. The caveat here is just the translation, that is not fixed yet, as we indicated in another post: > [@Fix - fixed labels](https://community.glideapps.com/t/fix-fixed-labels/61776/1): > > Hi Guys, When creating apps in different than English language, there are few places in Glide where you cannot change the label: Cancel/Submit in forms Sign in/Sign-up & View Profile/Sign out Add/Edit/Delete in collection actions ā€œAllā€ in collection filter & ā€œFilter Byā€ and ā€œSearchā€ ā€œOpen Appā€ button in email template Can these be fixed? The apps would be then fully translatable. And I guess, full multilanguge apps thatā€™s probably too much to ask for? wink Thanks ---
**Author:** ![sc0o0py](https://avatars.discourse-cdn.com/v4/letter/s/35a633/32.png) [@sc0o0py](https://community.glideapps.com/u/sc0o0py)\ **Post date:** [May 4, 2025, 4:06pm UTC](https://community.glideapps.com/t/multi-filters-using-relations-a-new-way/36092/23 "2025-05-04T16:06:02Z")
great job @gvalero, but how did you show the number of filtered items on screen ā€œpeersonnel Foundā€ ā€¦ i wish you can advise me . ---
**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, 2025, 11:30pm UTC](https://community.glideapps.com/t/multi-filters-using-relations-a-new-way/36092/24 "2025-05-04T23:30:34Z")
If you can create a query that represents how you are filtering items on the screen, you can use a rollup on top of that to count the number of items that match the query. You can then also use that query to display the filtered items on the screen. ---
**Author:** ![sc0o0py](https://avatars.discourse-cdn.com/v4/letter/s/35a633/32.png) [@sc0o0py](https://community.glideapps.com/u/sc0o0py)\ **Post date:** [May 5, 2025, 8:49am UTC](https://community.glideapps.com/t/multi-filters-using-relations-a-new-way/36092/25 "2025-05-05T08:49:01Z")
Thanksā€¦ Creating the query is actually the hardest part for me, and unfortunately, Iā€™m not able to get it right. Itā€™s not as straightforward as something like `COUNTA` in an Excel sheet. Iā€™d really appreciate some guidance or examples if possible. ---
**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 5, 2025, 8:59am UTC](https://community.glideapps.com/t/multi-filters-using-relations-a-new-way/36092/26 "2025-05-05T08:59:20Z")
Have you reviewed the videos and examples in the docs? They are pretty good. > **[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. ---
**Author:** ![sc0o0py](https://avatars.discourse-cdn.com/v4/letter/s/35a633/32.png) [@sc0o0py](https://community.glideapps.com/u/sc0o0py)\ **Post date:** [May 5, 2025, 9:23am UTC](https://community.glideapps.com/t/multi-filters-using-relations-a-new-way/36092/27 "2025-05-05T09:23:37Z")
Yes, the one uploaded by @ gvaleroā€¦but itā€™s not a tutorial, it was just 3 minute overview only. I would be much appreciated if someone make more detailed video to show exactly how to display count number of filtered data ---
**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 5, 2025, 10:31am UTC](https://community.glideapps.com/t/multi-filters-using-relations-a-new-way/36092/28 "2025-05-05T10:31:13Z")
There are two videos in the Glide Docs that I linked to - have you looked at those? There are also example use cases in the docs with step by step instructions. ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [May 6, 2025, 1:02am UTC](https://community.glideapps.com/t/multi-filters-using-relations-a-new-way/36092/29 "2025-05-06T01:02:41Z")
Hola @sc0o0py .. sorry for my delay to reply. My demo app is very old (classic) and this method was an alternative way to filter data avoiding creating manual filters. In those days, the **Query** column didnā€™t exist, but now it may be an easier solution to achieve what I wanted to do in most cases. But coming back to your question to get the number of filtered items created by the relation, what you do is create a **Rollup** column based on that relation and count the items found. Itā€™s something very easy as you can see. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/d/0df337fd3f3a31f42a7d53e86d2af1f62ee54f85.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/3/330cf7bb81112dd4fb908252873eb60319a29785.png) If you are going to use newer Glide APPs with the **Query** column, your Rollup column must now point to your Query column instead the Relation column. I hope it helps. Saludos! ---
**Author:** ![sc0o0py](https://avatars.discourse-cdn.com/v4/letter/s/35a633/32.png) [@sc0o0py](https://community.glideapps.com/u/sc0o0py)\ **Post date:** [May 6, 2025, 6:32am UTC](https://community.glideapps.com/t/multi-filters-using-relations-a-new-way/36092/30 "2025-05-06T06:32:35Z")
Thank you so much for your help @gvaleroā€”it worked perfectly and solved my issue! I really appreciate you taking the time to guide me through it [Previous page](https://community.glideapps.com/t/multi-filters-using-relations-a-new-way/36092.md?page=1)