Hello all ! Maybe this question has been already replied, but I did’nt found the answer :confused: 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 !

You’d need to use screen filtering. I’ll create a tutorial on this today. It’s something I’ve wanted to do anyway.

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 :smile: #Karma

Looks like you’ve seen this already, so just adding the link to the video here for reference. [image] tornado Use Multiple Choice Components to Filter an Inline List Community Resources [Glide: Filter an Inline List with Choice Components] Updated July 2022 ▶ V…

yes thanks ! I should share the video here, will think about it next time !

Hello @Robert_Petitto :slight_smile: 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…

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?

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.

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)”

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 :confused: The only way I found is to create an array colum within Google Sheet by using an Arrayformula and then pu…

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 !”

Filter list based on user criteria

Report a Bug

Jeff_Hager October 9, 2020, 2:00pm 4

Looks like you’ve seen this already, so just adding the link to the video here for reference.

Topic		Replies	Views
Table relations & choice as filter Ask for Help	12	1689	July 7, 2022
How to Add "filter" of List Page from User Profile Ask for Help	21	1587	April 9, 2021
Filter based on customer profile inputs Ask for Help	12	1059	April 17, 2020
🌪 Use Multiple Choice Components to Filter an Inline List Community Resources tutorial	201	13764	October 18, 2024
Filter multiple sheets by choice component Ask for Help	6	260	February 12, 2024

Filter list based on user criteria

Related topics