Filter results shown in a select control?

[Bryce_Gibb]

Is there a way to filter the results shown in a select control? For example, in the equipment inventory template, under the search inventory section, you are able to filter the table by category, and brand. Is there a way to have only the brands connected with the selected category show up in the brand select list? I have searched the formula list, but couldn’t figure it out. Any help would be appreciated.

[mallika]

Hi @Bryce_Gibb - are you looking for something like this -

Dropdown Menu Dependancies?

Hi all, Absolutely hooked on Coda, I’ve been using it for a couple of different purposes and loving it’s potential! I’ll try share a few things I’ve done so far that I really like soon. One thing I’ve yet to work out how to do (if it’s possible at all!) is how to setup dependancies for drop down menus. What I mean by this is, say I have a table with two drop down columns. I would like the second dropdown column to only show relevant options based on what was set in the first dr…

[Bryce_Gibb]

Thanks for the fast response. I just tried following the example, but couldn’t make it work. That example is working in a table, where I am using the select list to filter the table - maybe that is where I am having problems following it? I will try to play with it tomorrow, but if you have a quick formula example based on the - equipment inventory template, I would be very appreciative.

[mallika]

Try this formula -

[Brand and Model].Filter(Category.Matches(ChooseCategory)).Brand

ChooseCategory here is the Select List for Category.

[Bryce_Gibb]

Awesome! Thanks for you help.