An app for managing customers, products, and orders.
How we built this appWe 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.
Sales & CRM