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?

[image] Customize Map marker icons/pins Feature Requests 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.

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…

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

Can you maybe take a pic of what you are refering to?

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.

[filtri] 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

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.

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

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.

Would link to screen work here, with relations to the right items for each “filter”?

Menu lists acting as filters of another list

Ask for Help

Jeff_Hager December 3, 2020, 5:29pm 20

Topic		Replies	Views
Filter List based on other sheet Ask for Help	2	557	June 6, 2020
Email filtering in inline list Ask for Help	13	682	March 15, 2020
Pull Filtered Column Into Inline List Ask for Help	13	906	December 23, 2020
Link a choice list to a list and a map Ask for Help	9	133	April 25, 2025
🌪 Use Multiple Choice Components to Filter an Inline List Community Resources tutorial	201	13769	October 18, 2024

Menu lists acting as filters of another list

Related topics