Survey 123 Inventory Manager

[AntonioBrcković]

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.

[jcarlson]

Referencing existing fields will only work if you are using the form to edit rows. Can you confirm if you are doing that? You'd need a single row in your table for each asset type, and your form would simply be editing the attributes.