Survey 123 Inventory Manager

165
1
01-17-2023 05:07 AM
AntonioBrcković
New Contributor

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.

 

0 Kudos
1 Reply
jcarlson
MVP Honored Contributor

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.

- Josh Carlson
Kendall County GIS
0 Kudos