Hey all, I'm having a little trouble findin...

(Jenn M.) #1

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!

(Suvrutt Gurjar) #2

@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

(Aleksi Alkio) #3

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])

(Jenn M.) #4

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!