Hello,
We are trying to make an inventory manager that scans QR codes and displays the current stock of equipment. Is there a way to make a formula or something in Survey123 Connect that allows us to instantly calculate and display the current stock after we add or subtract a piece of equipment?
We tried using the calculations field and the formula (Quantity_IN - Quantity_OUT) + Stock and although we received no errors the Stock field in our Inventory on the Server is always empty.
Appreciate all the help you can give us.