# Filtering within glide similar to excel

**URL:** <https://community.glideapps.com/t/filtering-within-glide-similar-to-excel/82693>\
**Category:** Ask for Help\
**Created:** [June 23, 2025, 8:55pm UTC](https://community.glideapps.com/t/filtering-within-glide-similar-to-excel/82693 "2025-06-23T20:55:55Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Babs](https://avatars.discourse-cdn.com/v4/letter/b/cdc98d/32.png) [@Babs](https://community.glideapps.com/u/Babs)\
**Post date:** [June 23, 2025, 8:55pm UTC](https://community.glideapps.com/t/filtering-within-glide-similar-to-excel/82693/1 "2025-06-23T20:55:55Z")

</div>

I need to create an app that filters data similar to excel. I have tried multiple ways of creating relations and it seems to only let me do exact matches. I need to select 3 values that then link back to 1 number.  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/8/88585e8a9e0ed693c7f344ab4e17f0b950299919.png)  
Red House/Red Door/Blue Knob/1010

If I select Red House/ Red Door/Blue Knob the 4th dropdown should show only 1010 as a selection

Can anyone help?

---

<div class="post-metadata">

**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:** [June 23, 2025, 9:05pm UTC](https://community.glideapps.com/t/filtering-within-glide-similar-to-excel/82693/2 "2025-06-23T21:05:35Z")

</div>

Queries can match multiple items, but…are you applying filters to your choice components?

---

<div class="post-metadata">

**Author:** ![Babs](https://avatars.discourse-cdn.com/v4/letter/b/cdc98d/32.png) [@Babs](https://community.glideapps.com/u/Babs)\
**Post date:** [June 23, 2025, 9:12pm UTC](https://community.glideapps.com/t/filtering-within-glide-similar-to-excel/82693/3 "2025-06-23T21:12:27Z")

</div>

I have been using the relations function, but it only relates exact match. Where would I apply filters? I am not seeing that option.

---

<div class="post-metadata">

**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:** [June 23, 2025, 9:38pm UTC](https://community.glideapps.com/t/filtering-within-glide-similar-to-excel/82693/4 "2025-06-23T21:38:54Z")

</div>

> [@Jeff\_Hager](#):
>
> Queries

A query column is is more powerful than a relation because it has built in filtering (although it runs a bit slower than a relation).

> [@Babs](#):
>
> Where would I apply filters?

Are you talking about a query column or a choice component? The query column is self explanatory when you add it, but a choice component has filters in the right hand panel (Options tab) when the component is selected in the left hand panel. You can filter by Screen Values or whatever else.