We're setting up your new app...


Order Capture

An app for managing customers, products, and orders.

This app can be used to manage customers, products, and orders. The app user can: - Create and edit a customer list. - Create and edit a product list. - Create orders associated with a customer. Orders can have three status: Open, Complete, or Canceled - Add products to each order, specifying an amount. The app will calculate the total value of the order and the total cost per product.

How we built this app

We built this app leveraging the following AppSheet features: References between tables, Spreadsheet Formulas. And managed advanced views with Slices and conditional formatting. Look for the following features in this app: 1) References between tables: Customers, Orders, and Order details are connected by references between tables. When an order is created, there's a drop-down menu listing all the customers, that list is dynamically updated every time the customer list is updated. Additionally, every time the user opens the details of a customer, a new order can be created from that point. To turn a column into a reference, change it in Advanced Editor > Data > Column Structure. Locate the column you want to change and click on EDIT. Sect REF type and select the table it should point to 2)Spreadsheet formulas. We also added formulas that are calculated once the app is synced with the spreadsheet. The Order Total formula in the Orders view is calculated once the spreadsheet is synced with the app. Copy this app for free to see all the customizations we included and replace it with your own products and customers.

Data for this app

  • Industry


  • Function

    Sales & CRM