Template
Lookup Table
Look up values from another table
Industry:
n/a
This app shows how to look up values from another table. This is similar to how you would use a VLOOKUP in Excel or Google Sheets. Choose an item from the dropdown menu, and the Choice Weight column will auto-fill based on the chosen value.
Loading...
Also see:
tablet mode & fullscreen mode
How we built this app
We have two tables in this app: Lookup Table and Form.
Lookup Table is a collection of fruits and their weights. Form captures an item and its weight.
The form is connected to the Lookup Table in two ways:
1) The Choice column has Suggested Values defined by the Name column of the Lookup Table.
2) The Choice Weight column is initialized using a LOOKUP expression over the Lookup Table.
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...