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!!
User | Count |
---|---|
42 | |
33 | |
24 | |
23 | |
14 |