# Filtering inline list in a form **URL:** \ **Category:** Ask for Help\ **Created:** [July 30, 2021, 5:18pm UTC](https://community.glideapps.com/t/filtering-inline-list-in-a-form/29757 "2021-07-30T17:18:21Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Fabien\_Vermot](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fabien_vermot/32/5955_2.png) [@Fabien\_Vermot](https://community.glideapps.com/u/Fabien_Vermot)\ **Post date:** [July 30, 2021, 5:18pm UTC](https://community.glideapps.com/t/filtering-inline-list-in-a-form/29757/1 "2021-07-30T17:18:21Z")
Hello !! I’m trying to design a form designing with : 1. a choice component that allow users to choose a parking 2. an inline list that allow users to see the cars located in this parking But unfortunetaly, my inline list is not filtered once i’ve choosen my parking and it is still displayed the same cars whatever the parking choosen. Is there a way to filter dynamically an inline list from a choice component in a form ? Thanks for your help ---
**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:** [July 30, 2021, 11:38pm UTC](https://community.glideapps.com/t/filtering-inline-list-in-a-form/29757/2 "2021-07-30T23:38:43Z")
Does filtering an inline list with a “screen” value works inside a form? If it doesn’t then there’s no way to go. ---
**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:** [July 31, 2021, 12:54am UTC](https://community.glideapps.com/t/filtering-inline-list-in-a-form/29757/3 "2021-07-31T00:54:10Z")
- have your choice component writing to a User Specific column - use the value in that user specific column to form a multi-relation - display the results of the multi-relation in your inline list component Edit: I just noticed that you’re doing this in a form. To use the method I described you’d need to abandon the native form and build your own custom form ---
**Author:** ![Fabien\_Vermot](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fabien_vermot/32/5955_2.png) [@Fabien\_Vermot](https://community.glideapps.com/u/Fabien_Vermot)\ **Post date:** [August 1, 2021, 2:58pm UTC](https://community.glideapps.com/t/filtering-inline-list-in-a-form/29757/4 "2021-08-01T14:58:19Z")
Thanks @Darren_Murphy !! Indeed, it doesn’t work in a native form but it works perfectly in a custom form. ---
**Author:** ![Test\_Test](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/test_test/32/30930_2.png) [@Test\_Test](https://community.glideapps.com/u/Test_Test)\ **Post date:** [December 29, 2021, 9:03am UTC](https://community.glideapps.com/t/filtering-inline-list-in-a-form/29757/5 "2021-12-29T09:03:01Z")
> [@Darren\_Murphy](#): > > - use the value in that user specific column to form a multi-relation > - display the results of the multi-relation in your inline list component Hi @Darren_Murphy, Hitting you up in yet another topic 🙂 I have a similar setup, inside a custom form of course. I’m stuck at allowing the user to also see all options. I’ll explain a bit more: 1. We have a “type” sheet which lists all the client types (lead, active client, etc). 2. On the screen in which we list the clients, there’s a choice component is asking if the user would like to filter by a specific client type 3. Once they select a type, the list is filtered perfectly. 4. How do we make it that the list will show all clients if the user hasn’t selected anything? This is something like an opt-in selection, in which if the user doesn’t opt-in a type, all types are shown. One idea that I had is adding two inline lists: 5. All types - visible if user didn’t select a specific type 6. Specific type - visible only once a specific type has been selected **but wait, there’s another layer for this challenge:** Another filter we need to apply is the client status. Similar setup here as well, i.e. status sheet, each row in clients sheet has a column for status, etc. How do we drill down here? Specifically, there are the following scenarios for the clients screen: 1. User didn’t select anything, so we show him everything 2. User selected a client type, but haven’t selected a client status. We show him all clients from that type, regardless of their status 3. User selected both type and status, we show him only those clients that match both selections. It’s probably a lot longer to explain than to solve. I’m sure your solution will be very simple, and elegant, as always 🙂 Thanks ---
**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:** [December 29, 2021, 9:17am UTC](https://community.glideapps.com/t/filtering-inline-list-in-a-form/29757/6 "2021-12-29T09:17:36Z")
This looks fairly straight forward. I’m out at the moment, I’ll come back to you a bit later with an option. ---
**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:** [December 29, 2021, 10:46am UTC](https://community.glideapps.com/t/filtering-inline-list-in-a-form/29757/7 "2021-12-29T10:46:15Z")
Okay, so here is what I would suggest. Note that this assumes that you have both Client Type and Client Status columns in your Clients table. You will need to add 3 columns to your Clients table. - The first two columns will be Single Value columns, with each one taking one of the User Specific column values that each of your choice components are writing to. - The 3rd column will be where a little bit of magic happens 😉 This should be an if-then-else column, that will resolve to a boolean type. If it resolves to `true`, that means the associated row will be filtered (not shown). Configure it as follows: – If single value Client.type is empty, then empty – If single value Client.status is empty, then empty – If single value Client.type is not Client.type, then `true` – If single value Client.status is not Client.status, then `true` – Else empty NB. “empty” above means exactly that. Empty, no value, nil, nothing, blank. Now you just need a single inline list on your form screen that uses your Clients table as the source. And the filter condition on that should be "where if-then-else column is not `true`" I haven’t tested the above, but I’m fairly confident it should work, if I’ve understood your use case correctly. ---
**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:** [December 29, 2021, 11:39am UTC](https://community.glideapps.com/t/filtering-inline-list-in-a-form/29757/8 "2021-12-29T11:39:45Z")
Hola de nuevo @test_test What you need is a Filter based on a “logical OR” and this new method to have dynamic filters can help you: > [@Multi Filters using Relations: a new way bulb](https://community.glideapps.com/t/multi-filters-using-relations-a-new-way/36092): > > Hola, feliz día! Watching some threads and good [Robert Petitto’s](https://community.glideapps.com/t/use-multiple-choice-components-to-filter-an-inline-list/16932) videos about creating customized filters using an Inline List component, I thought an idea to make it simpler and avoid configuring manually the Inline List’s filter and suddenly, I got this to share wink: A way to have a wide Filter using the OR operator A narrow Filter using the AND operator I recorded a video to show and help to understand how this APP demo works and its procedure: [Loom | Free S…](https://www.loom.com/share/24af344081ff48aba9baf684e9a67be5) Saludos! ---
**Author:** ![Test\_Test](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/test_test/32/30930_2.png) [@Test\_Test](https://community.glideapps.com/u/Test_Test)\ **Post date:** [December 29, 2021, 2:22pm UTC](https://community.glideapps.com/t/filtering-inline-list-in-a-form/29757/9 "2021-12-29T14:22:13Z")
> [@gvalero](#): > > Filter based on a “logical OR” and this new method to have dynamic filters Hola amigo, As @Darren_Murphy said in his comment inside the topic you shared: this is very sophisticated logic and it’s truly impressive. If I understand correctly, I believe that actually logical AND suits my case better, no? We have three tiers/levels of filter: **First level - Account manager** Here we have two ways to select the filter: 1. Switch (Boolean) for “show my accounts”. This is meant to be used by, you guessed it, the account managers. Very easy for them to narrow down to their client list. 2. If Switch is false, we show a choice list of all account managers to choose from. I have added an ITE column to properly mark the account manager: either “current user” or the name selected in the choice list **Second level - type** We have three options: Lead, Client, Inactive client. User will choose on a sliding choice. This should be narrowed down to only the client types the account manager has. i.e. he/she might have just clients so there’s no point in showing them a slider with leads and inactive clients. I am using the filter option for the screen component and I think it’s working fine. **Third level - status** Each client type has its own list of possible statuses. Again, using filter inside the components to show only the statuses relevant based on the two previous levels. I’ve tried your AND logic (brilliant), but it’s not working for me. Tried to copy 100% of the logic from your demo, but no luck ☹ Any thoughts? PS - Sorry I cannot share the app, it’s confidential. ---
**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:** [December 29, 2021, 2:58pm UTC](https://community.glideapps.com/t/filtering-inline-list-in-a-form/29757/10 "2021-12-29T14:58:34Z")
Did you try the option that I gave you? The option presented by @gvalero could be used, and I’m sure it would work fine if setup correctly. But honestly, I think it’s overkill for your use case. ---
**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:** [December 29, 2021, 4:02pm UTC](https://community.glideapps.com/t/filtering-inline-list-in-a-form/29757/11 "2021-12-29T16:02:13Z")
> [@Test\_Test](#): > > Tried to copy 100% of the logic from your demo, but no luck ☹ Hola! I am out using my phone and reply a full answer is hard but what part of my demo/logic doesn’t work for you? As soon as I come back I will help you better. Bye ---
**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:** [December 29, 2021, 4:14pm UTC](https://community.glideapps.com/t/filtering-inline-list-in-a-form/29757/12 "2021-12-29T16:14:25Z")
> [@Darren\_Murphy](#): > > I think it’s overkill for your use case. Overkill!!! I read “overkill” and always think about Men at Work inevitably 🤣🤣 Nothing beats this cover so far and its video: [![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/f/af58b99e160b7e53e6a7aa7dce150b95987d66c0.jpeg "Overkill - Lazlo Bane") ](https://www.youtube.com/watch?v=RqOU7r4hdmw) 💪💪 ---
**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:** [December 29, 2021, 4:22pm UTC](https://community.glideapps.com/t/filtering-inline-list-in-a-form/29757/13 "2021-12-29T16:22:21Z")
They were one of my favourite Aussie bands. Saw them live once, more than 30 years ago (showing my age 🤣🤪) ---
**Author:** ![Test\_Test](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/test_test/32/30930_2.png) [@Test\_Test](https://community.glideapps.com/u/Test_Test)\ **Post date:** [December 29, 2021, 4:55pm UTC](https://community.glideapps.com/t/filtering-inline-list-in-a-form/29757/14 "2021-12-29T16:55:02Z")
> [@Darren\_Murphy](#): > > I think it’s overkill for your use case. Could you please explain? I’m all for minimalistic approach, but one that can serve best for the given scenario, and (who knows) easily scalable for other scenarios. > [@gvalero](#): > > I read “overkill” and always think about Men at Work inevitably 🤣🤣 Good song, no doubt. ---
**Author:** ![Test\_Test](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/test_test/32/30930_2.png) [@Test\_Test](https://community.glideapps.com/u/Test_Test)\ **Post date:** [December 29, 2021, 5:15pm UTC](https://community.glideapps.com/t/filtering-inline-list-in-a-form/29757/15 "2021-12-29T17:15:11Z")
> [@Darren\_Murphy](#): > > Did you try the option that I gave you? Yes, tried it earlier today and couldn’t get it to work. Moved on to the 2nd idea from @gvalero, which didn’t work as well. Now circled back to your idea and, not surprisingly, it’s still not working for me. Don’t get me wrong, I’m sure both ideas are perfect and the fault is on my side. ---
**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:** [December 30, 2021, 1:58am UTC](https://community.glideapps.com/t/filtering-inline-list-in-a-form/29757/16 "2021-12-30T01:58:38Z")
> [@Test\_Test](#): > > Could you please explain? um… overkill. It means “using way more force than is necessary”, eg… - swatting a fly with a sledgehammer - killing two birds with one small thermonuclear device - creating an elaborate series of complex computed columns, when only a handful are needed to get the job done 😉 ---
**Author:** ![Test\_Test](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/test_test/32/30930_2.png) [@Test\_Test](https://community.glideapps.com/u/Test_Test)\ **Post date:** [December 30, 2021, 7:24am UTC](https://community.glideapps.com/t/filtering-inline-list-in-a-form/29757/17 "2021-12-30T07:24:39Z")
> [@Darren\_Murphy](#): > > creating an elaborate series of complex computed columns, when only a handful are needed to get the job done Not bad. Perhaps we can turn your sense of humor to an app… 💰 ---
**Author:** ![Test\_Test](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/test_test/32/30930_2.png) [@Test\_Test](https://community.glideapps.com/u/Test_Test)\ **Post date:** [December 31, 2021, 9:33am UTC](https://community.glideapps.com/t/filtering-inline-list-in-a-form/29757/18 "2021-12-31T09:33:01Z")
> [@Darren\_Murphy](#): > > Configure it as follows: > – If single value Client.type is empty, then empty > – If single value Client.status is empty, then empty > – If single value Client.type is not Client.type, then `true` > – If single value Client.status is not Client.status, then `true` > – Else empty Hi, Still struggling [making this happen](https://community.glideapps.com/t/filtering-inline-list-in-a-form/29757/9): Here’re the filter columns ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/b/ebede7545373c03912ec8690aaf199a2ecb80f15.png) The text ones get input from choice component. The If is as follows: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/8/c8874c5955f015ddb7b647d87a0db156feb64606.png) Then I implement your solution (I think… :P) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/6/d665ba557d6529698fa8acbede150514abdfc887.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/b/cb46450623592726cb900b75779f91e6de26a076.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/e/3ef9b0b5f5f045ddf1b7294524e2e70e3b1a4b19.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/7/877185a03b71cc11673614937956b1f3d3b34fb7.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/7/677e63583d39ef0fc9bac9144a9e0253292de927.png) And on the Client list screen we filter ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/0/20c25c9e484bee6751837202433c5e6bd73fcbe3.png) Would be grateful if you can point out to what I missed. Thanks! ---
**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:** [December 31, 2021, 11:03am UTC](https://community.glideapps.com/t/filtering-inline-list-in-a-form/29757/19 "2021-12-31T11:03:41Z")
That all looks okay. In what way does it not work? ---
**Author:** ![Test\_Test](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/test_test/32/30930_2.png) [@Test\_Test](https://community.glideapps.com/u/Test_Test)\ **Post date:** [December 31, 2021, 2:22pm UTC](https://community.glideapps.com/t/filtering-inline-list-in-a-form/29757/20 "2021-12-31T14:22:39Z")
> [@Darren\_Murphy](#): > > In what way does it not work? Well, it simply doesn’t filter anything right. The inline list does change (not always) but these changes have nothing to do with the filter selections ☹ [Next page](https://community.glideapps.com/t/filtering-inline-list-in-a-form/29757.md?page=2)