Hey all,
Iโm having a little trouble finding the answer to what I hope is a quick question-- can a column with List type be further filtered?
For example, I have a table with 2 columns: Models | Category. I want the referenced dropdown list to only show Models matching a certain category.
Thanks for any input!
@Jenn_M Could you please add if
the table with columns Category and Models is a referenced table into another table or is it a lookup table into another table? Also are category and models AppSheetโs list type or text type columns?
If it is a lookup table with text type columns that is used to create drop down lists into another table, please take a look at the article below on
the concept of dependent drop downs.
Please revert if you are looking for something else.
help.appsheet.com - Dependent Dropdown
Dependent Dropdown help.appsheet.com
I believe he has a ref field and he wants to filter it. Yes you can do it, if you choose the Key column for your SELECT expressionโฆ Like SELECT(RefTableName[KeyColumn],[Category]=[_THISROW].[Category])
Thanks both for your input! Yes, Aleksi is correct. I was wanting to filter a ref field. Using the KEY COLUMN in the select expression did the trick.
Thank you!
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |