Select row from another table that meet two conditions

[pmhungdao]

Hello,
I have a “Storage” table with the following fields: RowID, LocatorID, ProductID, Color, Qty
In “Delivery” table, I want user to select LocatorID and ProductID, then they can only select available color of the selected ProductID in the selected LocatorID.
What can I do that in Appsheet.
Thanks.

[Aurelien · Accepted solution]

Hi @pmhungdao,

Welcome to the community !

You may want to have a look here:

help.appsheet.com

SELECT()

Gather column values from row in table or slice

help.appsheet.com

FILTER()

Select rows of table or slice

help.appsheet.com

Dependent Dropdown

How to make a dropdown with choices that depend on the value selected in another dropdown.