Template
Ordered Dropdown
How to order/sort the values in dropdowns
Industry:
n/a
This app shows how to order or sort the values in your dropdown menu. Open the dropdowns to see how this app behaves.
Loading...
Also see:
tablet mode & fullscreen mode
How we built this app
We have a table called Person and a table called Form. Form has three ref-type columns to the Person table. We use the following valid_if formulas to sort the values that appear in the dropdown menus:
1. ORDERBY(Person[Key], [First Name])
2. ORDERBY(Person[Key], [Last Name])
3. ORDERBY(Person[Key], [First Name], TRUE)
4. ORDERBY(Person[Key], RANDBETWEEN(0, 10000))
The last formula will sort the dropdown in random order every time the form is opened.
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...