# ⚡ Filter any inline list by another inline list: Many to many filtering!
**URL:** https://community.glideapps.com/t/filter-any-inline-list-by-another-inline-list-many-to-many-filtering/25473
**Category:** Community Resources
**Created:** [April 12, 2021, 4:26pm UTC](https://community.glideapps.com/t/filter-any-inline-list-by-another-inline-list-many-to-many-filtering/25473 "2021-04-12T16:26:38Z")
**Posts on this page:** 12
**Page:** 1
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [April 12, 2021, 4:26pm UTC](https://community.glideapps.com/t/filter-any-inline-list-by-another-inline-list-many-to-many-filtering/25473/1 "2021-04-12T16:26:38Z")
# 👋Hey all!
Just finished this tutorial on how to create an interface that will filter one list of items (eg. teachers) by a completely different list of items (eg. subjects) to find a perfect filter match.
Uses the same interface as the in-app filter BUT makes perfect (`AND`) matches rather than `OR` matches.
## 🍿Enjoy!
[ ](https://www.youtube.com/watch?v=AkygzhrdUgE)
---
### Author:  [@eltintero](https://community.glideapps.com/u/eltintero)
#### Post date: [April 12, 2021, 4:40pm UTC](https://community.glideapps.com/t/filter-any-inline-list-by-another-inline-list-many-to-many-filtering/25473/2 "2021-04-12T16:40:35Z")
Good stuff!
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [April 12, 2021, 11:35pm UTC](https://community.glideapps.com/t/filter-any-inline-list-by-another-inline-list-many-to-many-filtering/25473/3 "2021-04-12T23:35:20Z")
Thanks for sharing! Great stuff.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [April 13, 2021, 1:31am UTC](https://community.glideapps.com/t/filter-any-inline-list-by-another-inline-list-many-to-many-filtering/25473/4 "2021-04-13T01:31:32Z")
`sumDisplay` also useful for displaying a dynamic count of matched results - good if you have lots of records.
Just thinking about that little display glitch at the end, perhaps you could add an extra condition to the filter icon ITE - if the filter count equals the total number of records, then blank?
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [April 13, 2021, 1:39am UTC](https://community.glideapps.com/t/filter-any-inline-list-by-another-inline-list-many-to-many-filtering/25473/5 "2021-04-13T01:39:34Z")
> [@Darren\_Murphy](#):
>
> perhaps you could add an extra condition to the filter icon ITE
Good call. Here’s what I’m doing:
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [April 13, 2021, 1:45am UTC](https://community.glideapps.com/t/filter-any-inline-list-by-another-inline-list-many-to-many-filtering/25473/6 "2021-04-13T01:45:54Z")
👍
yeah that also works
---
### Author:  [@Jaime](https://community.glideapps.com/u/Jaime)
#### Post date: [April 13, 2021, 3:44am UTC](https://community.glideapps.com/t/filter-any-inline-list-by-another-inline-list-many-to-many-filtering/25473/7 "2021-04-13T03:44:00Z")
great as always 👍
---
### Author:  [@Krivo](https://community.glideapps.com/u/Krivo)
#### Post date: [April 13, 2021, 6:03am UTC](https://community.glideapps.com/t/filter-any-inline-list-by-another-inline-list-many-to-many-filtering/25473/8 "2021-04-13T06:03:56Z")
@Robert_Petitto just my thoughts (as suggested by @Darren_Murphy) as you are combining two different conceptual model
- All is an OR model
- user set selections is an AND model.
Could be an idea to add a button “Clear selections” which would clear all user selections
---
### Author:  [@Krivo](https://community.glideapps.com/u/Krivo)
#### Post date: [April 13, 2021, 6:06am UTC](https://community.glideapps.com/t/filter-any-inline-list-by-another-inline-list-many-to-many-filtering/25473/9 "2021-04-13T06:06:55Z")
@Robert_Petitto And you could possibly also add a choice with two choices “Any of”, “All of” - then both the OR and AND conceptual models are covered.
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [April 13, 2021, 10:02am UTC](https://community.glideapps.com/t/filter-any-inline-list-by-another-inline-list-many-to-many-filtering/25473/10 "2021-04-13T10:02:13Z")
> [@Krivo](#):
>
> Could be an idea to add a button “Clear selections” which would clear all user selections
This was my thought about using set column → dates … use some date magic to determine if a cell is “cleared”. Need to think about that one a bit.
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [April 13, 2021, 10:02am UTC](https://community.glideapps.com/t/filter-any-inline-list-by-another-inline-list-many-to-many-filtering/25473/11 "2021-04-13T10:02:46Z")
> [@Krivo](#):
>
> And you could possibly also add a choice with two choices “Any of”, “All of” - then both the OR and AND conceptual models are covered.
Nice idea and perfectly doable. I’ll see what I can do to tweak.
---
### Author:  [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)
#### Post date: [April 14, 2021, 6:09pm UTC](https://community.glideapps.com/t/filter-any-inline-list-by-another-inline-list-many-to-many-filtering/25473/12 "2021-04-14T18:09:13Z")
Okay not sure if you guys already have this on a another thread. But we can conduct and AND/OR choice on the Same inline list (no choice component); Using an inline list to grab everything from several other inline lists.
By accident than design I discovered we can do both an AND/OR on the same item.
I’ll share it with you guys.
1. I have an inline list with 20 different items.
2. I want to tap on say 5 items AT ONCE to see which of the 20 offer me my selected items.
3. I’m end up with AND/OR on those choices.