How to select only a few rows of options in my reference table?

AppSheet AppSheet Q&A
1

I have a reference table which has a list of rooms in a food production facility.

I have another table where the user needs to manage the temperature of products and will use the ref table to get the name of the fridges and freezers that he needs to record from.

But the ref table includes ambient temperature areas etc so I want to filter out the areas that are not applicable.

I created another column, “Type” in my ref table which assigns a value to each area and the ones I want in particular are the ones that are called “Cold Store”.

So I only want those cold store options to be accessible from my dropdown in my form. Is this possible?

2

Hi @Jaros

You may want to have a look there:

[Filtered Dropdown](https://community.appsheet.com/t/filtered-dropdown/15678) Questions

Hello to you all again! I have a table with Guardians and another one with Children. A third table, Connections, with 3 columns ID, Guardian, Children. In the Connections table, I want the dropdown for the child to be filtered and have only the unassigned children. I want to do this by checking the Connections table and if the child has not been on any records previously, then to have it in the dropdown. Any clues? Thank you!

[Filter a dropdown](https://community.appsheet.com/t/filter-a-dropdown/9969) Questions

I am trying to filter a dropdown depending on what the user put just before (year of the article and quantity) in the form of the app. I did like that: SELECT(Products[Article Id], AND(IN([_THISROW].[Article Année],Products[Article Année]),IN([_THISROW].[Article Quantité],Products[Article Quantité]))) My column is type ref and I put this formula in the suggested value. But the result gives all the column if I put a year that is in the column but I want just the article with this specific yea…

Even more, with a sample app:

[Sample App: Multiple (and optional) dependent dropdown filters](https://community.appsheet.com/t/sample-app-multiple-and-optional-dependent-dropdown-filters/23653) Tips & Tricks ?

I created a sample app to demonstrate setting up multiple search filters to narrow down the possibilities in a final Ref-type column. “Multi Filter Example” here: https://www.appsheet.com/portfolio/546920 This app does NOT utilize Appsheet’s implicit dependent dropdown feature, as described in the following post. The reason for this is to allow the user the option to filter by any, or all, or none, of the 4 filters, independently. Whereas the implicit dependent dropdown will auto-hide the …

…this question has been asked a lot on the community, I’m pretty sure you will find an answer among these posts:
https://community.appsheet.com/search?q=filter%20dropdown

Please see also (that may help you in writing expressions) :

[FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT()](https://community.appsheet.com/t/faq-filter-lookup-maxrow-minrow-ref-rows-and-select/24216) Tips & Tricks ?

Core concepts & functions Expressions: The Essentials FILTER() List Expressions and Aggregates LOOKUP() MAXROW() MINROW() REF_ROWS() SELECT() What is a Key? Adding & updating rows Is this a new row?/Does this row already exist? What is the previous value of this column? Excel alternatives How do I do COUNTIF() or COUNTIFS()? How do I do SUMIF() or SUMIFS()? How do I do VLOOKUP()? Last row of the spreadsheet How do I get the last row of the spreadsheet? How do I get a column value from…

Let us know if you have trouble at achieving your goal

Cheers !

4 Likes