Looking to create an app for my business. Does not seem to complicated but im running into trouble. Here is the basics:
-
We keep a running list of customer orders in Google Sheets, each document has a list of all items purchased in 1 week. Columns are customer name, item name, description, and price.
-
I want to create an app where it lists (or is a search) of all customers, when clicking into a customer it shows all orders (the dates) and their status. Clicking into an order brings up a list of all items purchased (which is a filtered listing from the specific list of orders for that week).
-
The user can change the status of the order level to indicate it was picked up.