Your Order Management App allows your sales team to streamline administration of business processes related to orders for goods or services. Customers or sales teams can get accurate information and status on their orders in real time on mobile. Sales people can create orders to include lists of products for each order.
Use Order Management App to:
- Create and edit customer lists
- Create customer orders with statuses such as: Open, Complete, or Canceled
- Add additional product items for each order including price. The total cost of order and cost per product can be calculated automatically.
– Perform order management for products by having real time visibility of available inventory.
We built this app leveraging the following features: references between tables, app formulas, spreadsheet formulas. Advanced views can be managed with Slices and by using conditional formatting.
References used to connect tables Customers, Orders, and Order details. Once you placed an order, there’s a drop-down menu showing all your customers. This drop down menu is dynamically updated every time the customer list is edited. Additionally, every time the user opens the details of a customer, a new order can be created from that point. In order to change a column into a reference, change it in Advanced Editor > Data > Column Structure.
Find the column you want to edit, than click on EDIT. Sect REF type and table it should point to
Additional formulas used to perform calculations once the app is synced with google spreadsheet. The Order Total formula in the Orders view is calculated once the spreadsheet is synced with the app. Use Order Management App modify it with your own products and customers.