How to Build an Order Form With Line Items

One order, many products, each with its own quantity.

Orders rarely contain one product. Line Items let a single order hold many products with quantities, without a hidden helper table.

  1. Create Customers, Products and Orders.
  2. On Orders, add a Line Items property linked to Products, with a quantity.
  3. Add a Rollup for the order total: "sum of price times quantity".
  4. Share the order form with your cashiers so they can enter orders from their phones.