# Menu lists acting as filters of another list **URL:** \ **Category:** Ask for Help\ **Created:** [December 1, 2020, 3:19pm UTC](https://community.glideapps.com/t/menu-lists-acting-as-filters-of-another-list/19229 "2020-12-01T15:19:50Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [December 1, 2020, 3:19pm UTC](https://community.glideapps.com/t/menu-lists-acting-as-filters-of-another-list/19229/1 "2020-12-01T15:19:50Z")
I’m now working on lists menus that act as filters for another list that has the data to be filtered. The first filter menu is macro category for the second list and so on. Suggestions? ---
**Author:** ![Pablo\_books](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablo_books/32/2110_2.png) [@Pablo\_books](https://community.glideapps.com/u/Pablo_books)\ **Post date:** [December 1, 2020, 4:35pm UTC](https://community.glideapps.com/t/menu-lists-acting-as-filters-of-another-list/19229/2 "2020-12-01T16:35:15Z")
Sorry, I’m not sure I understand. What you’re saying is that you’re filtering a list, and need suggestions? Also, I am not exactly sure what a ‘list menu’ is. I’m just gonna assume that you’re adding a regular list, and not screens in the menu. Although you could filter that too. I’d be proud to give you suggestions, but I’m kinda confused… ---
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [December 1, 2020, 7:41pm UTC](https://community.glideapps.com/t/menu-lists-acting-as-filters-of-another-list/19229/3 "2020-12-01T19:41:58Z")
It’s like: horizontal list 1 - filter 1 - filter 2 - filter 3 horizontal list 2 (optional) - filter 2\_1 - filter 2\_2 - filter 2\_3 adn then vertical list product 1 with filter 2\_1 product 2 with filter 2\_2 etc ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 1, 2020, 11:04pm UTC](https://community.glideapps.com/t/menu-lists-acting-as-filters-of-another-list/19229/4 "2020-12-01T23:04:16Z")
Can you maybe take a pic of what you are refering to? ---
**Author:** ![Pablo\_books](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablo_books/32/2110_2.png) [@Pablo\_books](https://community.glideapps.com/u/Pablo_books)\ **Post date:** [December 2, 2020, 4:39am UTC](https://community.glideapps.com/t/menu-lists-acting-as-filters-of-another-list/19229/5 "2020-12-02T04:39:50Z")
I’m even more confused than before! It’s not your fault, I just suck at understanding things. As @Drearystate asked, would you be able to provide us with a screenshot? If not, it’s okay. ---
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [December 2, 2020, 4:22pm UTC](https://community.glideapps.com/t/menu-lists-acting-as-filters-of-another-list/19229/6 "2020-12-02T16:22:37Z")
![filtri](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/e/ce12f73b6a45acae4a7f84c5f1bfe47c4a8142b8.png) like this, where the first horizontal menu list of filters is the father of the second horizontal list of filters, and maybe there will be a 3rd one and on the bottom the vertical list is the filtered one, maybe updating as the filters get selected. Also, some method to make it more elegant, like instead of more than one horizontal filter to have just one that updates as the user clicks, but in that case there must be some button or something that allows to go back ---
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [December 2, 2020, 4:25pm UTC](https://community.glideapps.com/t/menu-lists-acting-as-filters-of-another-list/19229/8 "2020-12-02T16:25:09Z")
Like the title says… ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 2, 2020, 5:43pm UTC](https://community.glideapps.com/t/menu-lists-acting-as-filters-of-another-list/19229/9 "2020-12-02T17:43:51Z")
When you select a image/button in the top list (inline list) it needs to enter data for you, you need the action to set a column value to that and have the data on the sheet filter by that column. Lists aren’t intended as filters. I use them as a kind of filter but they go to the same page with a filter applied and it looks like it’s a filter. But if you want it to actually filter you will have to do the first suggestion. or use a choice option that filters for you but again it enters data to the sheet. You can use glide sheets to make this instantaneous so there is no delay. ---
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [December 2, 2020, 7:37pm UTC](https://community.glideapps.com/t/menu-lists-acting-as-filters-of-another-list/19229/10 "2020-12-02T19:37:53Z")
Yes I’m already working on that method I just wanted to know if there maybe is something I don’t know, cause I’m having trouble writing tothe whole column or using user specific columns ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 2, 2020, 8:05pm UTC](https://community.glideapps.com/t/menu-lists-acting-as-filters-of-another-list/19229/11 "2020-12-02T20:05:00Z")
I think you might want to have ThinhDinh or Robert Pettito chime in on that. I normally use Glide as the UI and do most of the work in sheets and scripts to program what I want. But as far as I know you are doing whats available already. ---
**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:** [December 2, 2020, 11:55pm UTC](https://community.glideapps.com/t/menu-lists-acting-as-filters-of-another-list/19229/12 "2020-12-02T23:55:15Z")
Would link to screen work here, with relations to the right items for each “filter”? ---
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [December 3, 2020, 10:38am UTC](https://community.glideapps.com/t/menu-lists-acting-as-filters-of-another-list/19229/13 "2020-12-03T10:38:40Z")
That’s the problem, I don’t know how to do it. I’m using a separate sheet for the menu filters setting a user specific column to the choosen filter but then I should then write the choice to all the rows of all items to look for a realtion and I don’t know how, or if I can make it differently ---
**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:** [December 3, 2020, 10:40am UTC](https://community.glideapps.com/t/menu-lists-acting-as-filters-of-another-list/19229/14 "2020-12-03T10:40:33Z")
Let’s say we have 2 layers of data. Layer 1: Layer 1 ID | Content | Relation to Layer 2 (Layer 1 ID - match multiple) Layer 2: Layer 1 ID | Layer 2 ID | Content Then in the layer 1, set the action to link to screen, set the relation to layer 2 as the source of data. Then you do the same thing for the next layers. ---
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [December 3, 2020, 10:44am UTC](https://community.glideapps.com/t/menu-lists-acting-as-filters-of-another-list/19229/15 "2020-12-03T10:44:29Z")
ok and thx for the suggestion, for now I’m trying to keep everything in one screen though ---
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [December 3, 2020, 11:29am UTC](https://community.glideapps.com/t/menu-lists-acting-as-filters-of-another-list/19229/16 "2020-12-03T11:29:55Z")
I think the best way should be to use some sheets formula, where I can address a single, or two cells as filters reference and create a list querying those cells. I’ll look into it as with glide’s tool I can’t work a solution - edit - I forgot I can’t use user specific cells in sheets… ---
**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:** [December 3, 2020, 4:21pm UTC](https://community.glideapps.com/t/menu-lists-acting-as-filters-of-another-list/19229/17 "2020-12-03T16:21:05Z")
> [@Customize Map marker icons/pins](https://community.glideapps.com/t/maps-would-it-be-possible-to-have-different-map-pin-colors-on-one-map/1950/10): > > Well, I think a series of inline lists, set with an action to set a user specific column for each list, in combination with filtering each list by the screen value of the column set in the previous list, then following the directions in this post should get you what you need. [https://community.glideapps.com/t/use-multiple-choice-components-to-filter-an-inline-list/16932](https://community.glideapps.com/t/use-multiple-choice-components-to-filter-an-inline-list/16932) X ---
**Author:** ![ThatGuyInArizona](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thatguyinarizona/32/12472_2.png) [@ThatGuyInArizona](https://community.glideapps.com/u/ThatGuyInArizona)\ **Post date:** [December 3, 2020, 5:01pm UTC](https://community.glideapps.com/t/menu-lists-acting-as-filters-of-another-list/19229/18 "2020-12-03T17:01:55Z")
Is what you are describing a “cascading filter” – like you select the country, then it shows you states for that country, select a state and it shows cities in that state for you to pick ? ---
**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\ **Post date:** [December 3, 2020, 5:12pm UTC](https://community.glideapps.com/t/menu-lists-acting-as-filters-of-another-list/19229/19 "2020-12-03T17:12:04Z")
yes, and I know I can use the choice component, but that component is limited and ugly so I’m trying to use lists as filters ---
**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:** [December 3, 2020, 5:29pm UTC](https://community.glideapps.com/t/menu-lists-acting-as-filters-of-another-list/19229/20 "2020-12-03T17:29:27Z")
> [@Customize Map marker icons/pins](https://community.glideapps.com/t/maps-would-it-be-possible-to-have-different-map-pin-colors-on-one-map/1950/12): > > That’s why I mentioned to use a list with the set column action instead of a choice component. The concept in @Robert_Petitto’s post would then allow you to filter your final results based on those set column values and also account for empty selections on subsequent lists. It’s the exact same concept as using choice components, but with inline lists instead.