We're setting up your new app...


Food Orders 2

Create orders that have many items. Track items that have many orders.

Industry: Hospitality
Function: Other
This app shows how you can create a many to many relationship in AppSheet. In this app, orders have many items and items have many orders. This is accomplished through an intermediate table.

How we built this app

To create the many to many relationship, the App uses an intermediate table, Order Items. Each row of the Order Items table references one Order and one Menu Item. An Order has many Order Items. A Menu Item has many Order Items. This creates the bridge that allows an Order to (indirectly) have many Menu Items. I also added a few visibility formulas to improve the views, and created an action which uses a LINKTOFORM formula to allow users to add menu items to their order.
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