We're setting up your new app...


Many-to-Many Relationships

A Sample App To Demonstrate How To Do Many-To-Many Relationships

Industry: n/a
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. |-----

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.
Start for free