I have created multiple lists of filter categories for users to narrow down their choice of options. Some filter categories allow users to select multiple options within the same list. If the options they select are not adjacent in the list, it will display NO MATCHES
example: if options are 1,2,3,4,5 - and user selects that they want 1 and 4 - DOES NOT WORK
example: if options are 1,2,3,4,5 - and user selects that they want 1 and 2 - it will work
Pictures for an example of: user selects 2 skills they are looking for. Three professionals MATCH these skill selections, but only ONE pops up, because the selections are adjacent in their column.
Hi @gvalero thank you so much for this information! While it is very similar to what I’m trying to create - I don’t think it is exactly the same. Let me see if I can explain…
The wide filter allows the results to only have SOME of the criteria in a filter section but not all…
For example: if you check off location Alcott rd AND downtown, it allows professionals to show up if they work at Alcot rd OR Downtown. I want mine to show the professionals that work at BOTH locations bc the user needs to go both locations.
This is currently how mine works EXCEPT if: let’s say Marie Rad said she worked at Alcott rd, downtown, AND beach locations but then a user only needed someone to who worked at Alcott and Beach… Glide misreads the criteria and says Marie Rad DOESN’T work at those locations bc in the database it reads Marie Rad works at “alcot rd,downtown,beach…” not the selection “alcot rd,beach”.
That’s what I was trying to show in my original photos. Hopefully that makes sense!!
I keep trying to find out a simple and useful solution for you.
I tested 2 workarounds but I guess these are tricky for your case.
Your idea fails because you are using the includes condition in your filter and when your selected services (or hair types or whatever) aren’t consecutive the string/text to be found doesn’t exist. I have an idea using an array for it, it should work and make the solution simple.
I’m going to use another version of my database to make some analogies with yours. Here you can see that I selected 3 different locations and the Filter showed 2 people with this criteria. Although you case might need 2 options, I show you a case with 3 options (up to 3 locations) to understand better the process.
Take data saved in your Service column (mine is called u_Location instead) by Choice component (multi selection) and create a new one based on it to have an array column.
You must use Split Text type to get it.
I called it u_Location[ ] but you can call your new column as u_Service[ ]
YOU ARE A GENIUS. It works perfectly and I have adjusted all my filter categories. I also love that I can put a limit on how many selections are being acknowledged in the filter without having to limit how many specialties someone can have aka: if a user selects more than 5 specialties it’ll only acknowledge the first  bc that’s all I allowed for, but the professionals can have more than 5 specialties in their profile.