Template
Search in Form
How to search for items in a dropdown
Industry:
n/a
This app allows the user to optionally filter the values in a dropdown menu before selecting from it. In this case, you can optionally filter the items in the dropdown menu by color and size.
Loading...
Also see:
tablet mode & fullscreen mode
How we built this app
This app uses two tables: Item and Form.
The item table has a list of items, each with a color and a size.
The form table has a dropdown menu (Choose Item) that's a ref-type column to the Item table. It has a valid_if that filters values from the Item table. The valid_if formula is:
SELECT(
Item[Name],
AND(
OR(ISBLANK([Restrict Color]), [Restrict Color] = [Color]),
OR(ISBLANK([Restrict Size]), [Restrict Size] = [Size])
)
)
This is a preview of the data sets used in the app.
Data
This is a high-level model of both the data entities and the UI elements in the app.
Loading...