# How to filter inline list with several parameters? **URL:** \ **Category:** Ask for Help\ **Created:** [January 8, 2022, 6:08pm UTC](https://community.glideapps.com/t/how-to-filter-inline-list-with-several-parameters/36855 "2022-01-08T18:08:35Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\ **Post date:** [January 8, 2022, 6:08pm UTC](https://community.glideapps.com/t/how-to-filter-inline-list-with-several-parameters/36855/1 "2022-01-08T18:08:35Z")
Hi experts, I have an inline list of exercises that I want the user to filter using the parameters: Area, Type and a letter search. I created the USC and filtered the list accordingly. My problem is when all the parameters are empty I want the list to show in full, the reality is it only shows the empty values that match. The area and Type parameters are set to allow choose multiple, that’s why I use “is included in” When everything is filled the list is searched correctly but when something left empty it does not show all the rows. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/3/237f1677e04f781ae32af4881e90b1e4a89d1719.jpeg) ---
**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\ **Post date:** [January 8, 2022, 6:22pm UTC](https://community.glideapps.com/t/how-to-filter-inline-list-with-several-parameters/36855/2 "2022-01-08T18:22:35Z")
Plugging my own template is not ideal but I had published this template as a proof of concept for filtering a list with multiple parameters: [Salary Benchmarking Template • Glide](https://www.glideapps.com/templates/salary-benchmarking-5i) Maybe this will help you think about how to set it up. ---
**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\ **Post date:** [January 8, 2022, 6:28pm UTC](https://community.glideapps.com/t/how-to-filter-inline-list-with-several-parameters/36855/3 "2022-01-08T18:28:34Z")
That’s nice 🙂 But I see you also don’t show all values when all parameters left empty. ---
**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\ **Post date:** [January 8, 2022, 6:29pm UTC](https://community.glideapps.com/t/how-to-filter-inline-list-with-several-parameters/36855/4 "2022-01-08T18:29:36Z")
Yeah. All the values in the choices are required for the filter to work. But should be easy to do with conditional visibility. If none is selected, show another list with all items. ---
**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\ **Post date:** [January 8, 2022, 6:31pm UTC](https://community.glideapps.com/t/how-to-filter-inline-list-with-several-parameters/36855/5 "2022-01-08T18:31:18Z")
I had that solution but I have in total 6 parameters. and they all open new screens. ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [January 8, 2022, 6:34pm UTC](https://community.glideapps.com/t/how-to-filter-inline-list-with-several-parameters/36855/6 "2022-01-08T18:34:19Z")
Hola Lin, Maybe you might test my idea in these cases and make simpler the logic. Take a look at it here [Multi Filters using Relations: a new way 💡](https://community.glideapps.com/t/multi-filters-using-relations-a-new-way/36092) Saludos! ---
**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\ **Post date:** [January 8, 2022, 7:46pm UTC](https://community.glideapps.com/t/how-to-filter-inline-list-with-several-parameters/36855/7 "2022-01-08T19:46:41Z")
This is working great! Now I need to think how to add the multiple option 🙂 Thank you ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [January 8, 2022, 9:27pm UTC](https://community.glideapps.com/t/how-to-filter-inline-list-with-several-parameters/36855/8 "2022-01-08T21:27:25Z")
Hola de nuevo! What do you mean with “_add the multiple option_”? My example has a choice using a multiple selection option too! Glad to know it helped you. Feliz día! ---
**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\ **Post date:** [January 9, 2022, 6:37am UTC](https://community.glideapps.com/t/how-to-filter-inline-list-with-several-parameters/36855/9 "2022-01-09T06:37:15Z")
I see only in the OR multiple selection. I need AND but only the area parameter can have multiple choices ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [January 9, 2022, 9:16am UTC](https://community.glideapps.com/t/how-to-filter-inline-list-with-several-parameters/36855/10 "2022-01-09T09:16:52Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/0/c0efe267dfde693d2176067271d681b3a978550e.png) Here’s my attempt to use XC to solve this. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/6/b6f54b0fe7abc46b4f75071c8a65146c0e6924c0.png) My column takes 3 inputs: joined filter list, category list, and delimiter (default to comma). I automatically trim each item in the filter/category list, this is also case-insensitive. The two lists’ orders do not matter. If the filter is empty I return a true value. Link to use: `https://thinhdinhlca.github.io/check-filter-and/` ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [January 9, 2022, 5:47pm UTC](https://community.glideapps.com/t/how-to-filter-inline-list-with-several-parameters/36855/11 "2022-01-09T17:47:07Z")
Hi @Lin_Altshuler, I am confused 🥴 Do you want a mixture of these 2 cases? I mean: your goal is to have several parameters ruled by an AND filter but one of those allows selecting multiple? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/2/e2d560f7a346c194789e22f2fd01946c1482572e.png) Bye ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [January 9, 2022, 11:42pm UTC](https://community.glideapps.com/t/how-to-filter-inline-list-with-several-parameters/36855/12 "2022-01-09T23:42:49Z")
> [@gvalero](#): > > your goal is to have several parameters ruled by an AND filter but one of those allows selecting multiple? Ah now I read Lin’s response again I’m confused too… I was thinking to filter multiple choices by an AND logic for what she calls “area parameter”. For your question, I expect an AND between different categories. Does that answer your question? ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [January 10, 2022, 12:18am UTC](https://community.glideapps.com/t/how-to-filter-inline-list-with-several-parameters/36855/13 "2022-01-10T00:18:40Z")
Sorry @ThinhDinh … I tagged you accidentally 🤯 My question is for Lin Altshuler!! Saludos! ---
**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\ **Post date:** [January 10, 2022, 5:21am UTC](https://community.glideapps.com/t/how-to-filter-inline-list-with-several-parameters/36855/14 "2022-01-10T05:21:49Z")
Ok I will try to explain/ The multiple choice in one of the parameters in an OR and the condition with the rest of the parameters is an AND. for example: Type: **Isolated** AND Area (multiple selection) **Quadriceps** or **Hamstrings** or **Gluteus Maximus** ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [January 10, 2022, 5:46am UTC](https://community.glideapps.com/t/how-to-filter-inline-list-with-several-parameters/36855/15 "2022-01-10T05:46:01Z")
You know, I don’t think you need a complicated solution with relations or anything for this. Just a couple of single value columns and a single if-then-else column should do it. Create these three columns in the table that contains the data to be filtered: - Single Value column that takes the user specific Type choice and applies it to all rows - Single Value column that takes the user specific Area choice and applies it to all rows - Now an if-then-else column: – If Type is not sv/type-choice, then blank – If Area is included in sv/area-choice, then true Now you can use that if-then-else column to filter your Inline List of results, showing only those rows where it is true. I haven’t tested this, but I believe it should work. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [January 10, 2022, 8:20am UTC](https://community.glideapps.com/t/how-to-filter-inline-list-with-several-parameters/36855/16 "2022-01-10T08:20:42Z")
As long as the area column that is compared to is a single one, I believe this approach should work. I.e there’s not one workout that belongs to both Quadriceps and Hamstrings. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [January 10, 2022, 8:25am UTC](https://community.glideapps.com/t/how-to-filter-inline-list-with-several-parameters/36855/17 "2022-01-10T08:25:17Z")
yeah, that did occur to me. It could also fall down if you had a value that is a subset of another value. For example if you had one called “Hamstrings” and another called “Hamstrings foo” (bad example, I know). If that was the case, then you’d probably have to go back to the split text/relation approach. ---
**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\ **Post date:** [January 10, 2022, 8:37am UTC](https://community.glideapps.com/t/how-to-filter-inline-list-with-several-parameters/36855/18 "2022-01-10T08:37:25Z")
> [@ThinhDinh](#): > > I.e there’s not one workout that belongs to both Quadriceps and Hamstrings. True thought you programmers wouldn’t know 😁 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [January 10, 2022, 8:39am UTC](https://community.glideapps.com/t/how-to-filter-inline-list-with-several-parameters/36855/19 "2022-01-10T08:39:14Z")
> [@Lin\_Altshuler](#): > > thought you programmers wouldn’t know What are you talking about??? I work out every day! (on my keyboard) 🤣 ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [January 11, 2022, 5:02am UTC](https://community.glideapps.com/t/how-to-filter-inline-list-with-several-parameters/36855/20 "2022-01-11T05:02:09Z")
Hi @Lin_Altshuler Not quite sure if this is the solution to your problem. Don’t worry about the relations. 2 choice components and 4 inline lists 1. Select an OR exercise category. show all, if none selected. 2. One OR leads to an AND multiple selection of OR/AND instructors, each selection opening the classes they are responsbile for. 3. If no gym instructors selected, show all classes. I hope I have understood you correctly. We are all trying our best! > **[Copy of myGym](https://tasty-stew-7242.glideapp.io/)**