A Sample App To Demonstrate How To Do Many-To-Many Relationships
The purpose of this app is to demonstrate how you can create a Many-to-Many relationship inside an AppSheet app. -----| This is non-standard functionality for an AppSheet app, so you should proceed with caution if you're implementing this in a production app; make sure you understand all the implications and have fully tested out this functionality before you implement it. |-----
Also see: tablet mode & fullscreen mode
How we built this app
This app consists of two tables: - Products - Orders Inside the Orders table, there is an EnumList (with a base type Ref to the Products table) where users can select any number of products to include in their order. -------- Inside the Products table, that's where you'll find the non-standard SELECT() formula specifically designed to allow for many-to-many. - The secret is in the SPLIT(CONCATENATE(...)) formula - this is what puts everything in the correct format so that when things are done processing they are as they should be and AppSheet can interpret the data.
This is a preview of the data sets used in the app.
This is a high-level model of both the data entities and the UI elements in the app.