Hi, Iโm new to AppSheet, although Iโm not new to development and design. I have a very basic order sheet for a restaurant that Iโm working on. It connects to my Google Sheet and updates an order quantity column per item. I have two simple actions (add to order, subtract from order) that show an increase/decrease in the number displayed, as well as update a โQuantity Orderedโ column. Iโve also set up a control column with all quantities equaling 0.
Where I am pulling my hair out is figuring out an expression or function to reset the Order Quantity to 0 after the user syncโs the app to the Google Sheet table. Iโve tried a bunch of combinations and even though I get close I feel like Iโm missing something here. I have the basic add and subtract actions working on the number so that it increases/decreases on tap.
Any help is greatly appreciated! Thank you!!
This is only possible if the column is a virtual column, and even then isnโt trivial. Why do you want to reset the value to zero on sync?
I believe it is going to confuse the staff when they are ordering on a daily basis. So basically, the staff member that is ordering would have a clean slate each time.
I currently have it setup with a virtual column that is taking into account the addition of the the control value + the quantity inputed (another column based on user input). This works the first time around around with blank data, but doesnโt solve an initial value =0 at the start. @Steve thanks for responding by the way.
Iโm afraid I donโt understand enough how your app works, and it sounds like youโre taking an unconventional approach. Without a lot more details, I have nothing else to offer.
What I have used with a restaurant appโฆ the quantity is reset when the order is delivered (via Workflow) with an action. Then you can change the qty as many times as you want and when you make an order, itโs time to reset the qty. Could you use that method as well?
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |