# Filter list based on user criteria **URL:** \ **Category:** Report a Bug\ **Created:** [October 8, 2020, 12:46pm UTC](https://community.glideapps.com/t/filter-list-based-on-user-criteria/16914 "2020-10-08T12:46:10Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Sheme34](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sheme34/32/18017_2.png) [@Sheme34](https://community.glideapps.com/u/Sheme34)\ **Post date:** [October 8, 2020, 12:46pm UTC](https://community.glideapps.com/t/filter-list-based-on-user-criteria/16914/1 "2020-10-08T12:46:10Z")
Hello all ! Maybe this question has been already replied, but I did’nt found the answer 😕 I’ve a list of profile, with details such as city, age, gender… I would like to display a list of users, and people can filter this list by choosing age, city, gender… Hope someone could help ! ---
**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:** [October 8, 2020, 12:49pm UTC](https://community.glideapps.com/t/filter-list-based-on-user-criteria/16914/2 "2020-10-08T12:49:08Z")
You’d need to use screen filtering. I’ll create a tutorial on this today. It’s something I’ve wanted to do anyway. ---
**Author:** ![Sheme34](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sheme34/32/18017_2.png) [@Sheme34](https://community.glideapps.com/u/Sheme34)\ **Post date:** [October 8, 2020, 1:03pm UTC](https://community.glideapps.com/t/filter-list-based-on-user-criteria/16914/3 "2020-10-08T13:03:31Z")
You know what is funny ? Before posting here, I first searched among your videos on Youtube… I searched how to contact you on your youtube channel but didn’t found 😄 #Karma ---
**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:** [October 9, 2020, 2:00pm UTC](https://community.glideapps.com/t/filter-list-based-on-user-criteria/16914/4 "2020-10-09T14:00:03Z")
Looks like you’ve seen this already, so just adding the link to the video here for reference. > [@tornado Use Multiple Choice Components to Filter an Inline List](https://community.glideapps.com/t/use-multiple-choice-components-to-filter-an-inline-list/16932): > > [[Glide: Filter an Inline List with Choice Components] ](https://www.youtube.com/watch?v=NOYFsVUWQXw) Updated July 2022 > > > **Version 1** > > > > \https://www.youtube.com/watch?v=rtbFccDKuH0\ ---
**Author:** ![Sheme34](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sheme34/32/18017_2.png) [@Sheme34](https://community.glideapps.com/u/Sheme34)\ **Post date:** [October 9, 2020, 3:05pm UTC](https://community.glideapps.com/t/filter-list-based-on-user-criteria/16914/5 "2020-10-09T15:05:17Z")
yes thanks ! I should share the video here, will think about it next time ! ---
**Author:** ![Sheme34](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sheme34/32/18017_2.png) [@Sheme34](https://community.glideapps.com/u/Sheme34)\ **Post date:** [October 11, 2020, 12:15pm UTC](https://community.glideapps.com/t/filter-list-based-on-user-criteria/16914/6 "2020-10-11T12:15:12Z")
Hello @Robert_Petitto 🙂 This worked great !for age and gender. I also would like to filter with datas from another tab in the sheet. Let say (with your exemple) that I have another tab in my sheet called “Hobbies” with Hobby 1, Hobby 2 etc columns and a column for some students that are listed in your Student tab in the sheet. How filter by those hobbies ? It’s a little bit tricky and I can’t find how to do it. ---
**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:** [October 11, 2020, 12:22pm UTC](https://community.glideapps.com/t/filter-list-based-on-user-criteria/16914/7 "2020-10-11T12:22:27Z")
So you want the list to be filtered by a user preference “hobbies” that is selected in a different tab? Will it always be filtered then or is the user able to choose from their selected hobbies? ---
**Author:** ![Sheme34](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sheme34/32/18017_2.png) [@Sheme34](https://community.glideapps.com/u/Sheme34)\ **Post date:** [October 11, 2020, 12:25pm UTC](https://community.glideapps.com/t/filter-list-based-on-user-criteria/16914/8 "2020-10-11T12:25:48Z")
the user should be able to filter the Student list with one choice for Age AND one choice for Hobby to retrieve students that are 14 and play Football by example. ---
**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:** [October 11, 2020, 12:39pm UTC](https://community.glideapps.com/t/filter-list-based-on-user-criteria/16914/9 "2020-10-11T12:39:43Z")
Gotcha. So you’ll need an in between column. A multiple relation column that relates the hobby single value column to the hobby array column in the student profile tab. then, in your if then else, include “if (hobby multiple relation) is empty, then (nothing)” ---
**Author:** ![Sheme34](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sheme34/32/18017_2.png) [@Sheme34](https://community.glideapps.com/u/Sheme34)\ **Post date:** [October 11, 2020, 1:07pm UTC](https://community.glideapps.com/t/filter-list-based-on-user-criteria/16914/10 "2020-10-11T13:07:46Z")
That’s where I’m stuck, Create an array column in the Student profile tab listing all the values from Hobby 1, Hobby 2, hobby 3 etc from the Hobby tab sheet… I don’t find how to do it 😕 The only way I found is to create an array colum within Google Sheet by using an Arrayformula and then push this column in the student profile tab sheet. But I’m not sure this is the good way. Or the cleanest ! Maybe I need to create one relation column for each Hobby in the Student profile tab that’s create an array column ? I’m loosing myself ---
**Author:** ![Sheme34](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sheme34/32/18017_2.png) [@Sheme34](https://community.glideapps.com/u/Sheme34)\ **Post date:** [October 11, 2020, 1:24pm UTC](https://community.glideapps.com/t/filter-list-based-on-user-criteria/16914/11 "2020-10-11T13:24:27Z")
I found what was my problem : My student relation column in the student tab wad “match multiple” so I was no able to do a lookup on the array column in the hobby tab. yay! thank you ! As we say in France “Ca marche Capitaine !”