Hey all.
New to appsheet here, but lots of experience with google spreadsheets and scripting in them.
This is seeming to be a hard thing to search for so I will ask it here. I have an inventory spreadsheet, each row an item, 3 property columns (id,name,amount). I have a form for a user to fill out where they pick an inventory item from an Enum list, and input an amount (negative or positive). Is there some easy built in way that I am missing to use the data from the filled out form, to add or subtract to the inventory? Thanks!
Edit: An example. Say item 1 has an amount of 5. A user uses 1 of this item, so they fill out the form, selecting item 1 from the list, and inputting -1. I want the amount in the inventory sheet for item 1 to be automatically update (subtract 1 from it). I do not want the user to have the directly edit the inventory amount (that is easy app-wise, but hard on the user).
User | Count |
---|---|
35 | |
35 | |
27 | |
23 | |
18 |