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

Jaros
Participant V

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?

0 1 487
1 REPLY 1

Aurelien
Participant V

Hi @Jaros

You may want to have a look there:

Even more, with a sample app:

โ€ฆ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) :

Let us know if you have trouble at achieving your goal

Cheers !

Top Labels in this Space