Order Capture WApp

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 statuses: 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.

We built this app leveraging the following AppSheet features: References between tables, Spreadsheet formulas, advanced views with Slices and conditional formatting, and a workflow rule to send email to the customer.
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. Select 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.

3) A workflow rule sends email to the customer. The email includes information regarding the customer, the customer's orders, and the order items included in each order.

Copy this app for free to see all the customization we included. You can replace it with your own products and customers.

Basic data automatically connected: 

Check out this app with our public photos:

• English (EN) interface version:

• Phiên bản giao diện tiếng việt (VI): giao diện đã được cập nhật chỉ dành cho đơn đặt hàng.

• 中文（CN）界面版：該界面僅針對訂單進行了更新.

• เวอร์ชั่นอินเทอร์เฟซภาษาไทย (TH): อินเทอร์เฟซได้รับการปรับปรุงสำหรับการสั่งซื้อเท่านั้น

• 日本語インタフェースのバージョン:インタフェースは注文に対してのみ更新されました。

• Deutsche (DE) Schnittstellenversion: Die Schnittstelle wurde nur für Bestellungen aktualisiert.

Check this app with ID Worldgroup: ( ***Note: You can not check this application if you do not have ID Worldgroup).

Become our Partner, please call us: (+84)939.335.835 (mr Xuan Tran)- Email: admin@worldgroup.com.vn