Template
One-to-Many References
Basic Parent-Child References
This app's main purpose is to demonstrate how a simple one-to-many reference in AppSheet is made.
- This connection serves as the backbone of any truly useful data system
I intentionally kept this app as simple as possible, to reduce any confusion or distraction.
Loading...
Also see:
tablet mode & fullscreen mode
How we built this app
There's two tables:
- Departments - (Parent)
- Which serves as a helper table, an easy way of "grouping" records inside your app
- Employees - (Child)
- Which is the actual "data" table in the scenario
--------------------------------------------------------------------------------------------------------------------------------------------------------
Employees have a "hard reference" connecting them to the Departments table, through the "Department" column
- When you set a column to the Ref type like this, in the table you select as the "Referenced table" a reverse reference will be created by the system
- This "inline view" will show all the related records for whatever parent record
THIS IS THE ESSENCE OF REFERENCES
--------------------------------------------------------------------------------------------------------------------------------------------------------
Once you make this connection, there is a TON of things you can do
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...