I’ve created an inventory app using the template for inventory management. I’ve made some work arounds to do what i need. essentially it is a check out app. if a person checks out an item then it drops the item amount by 1 ads it to a check out list and logs all history. there is also a check in process.
it’s fairly basic and uses a google sheet with each item on its own with product id codes.
Is there any way to connect multiple items together to an item code and have them all drop by a value of 1 even though you only select one.
The plan is essentially to assign items to kits and if a kit is selected all the items in that kit are checked out VS selecting every item. it total there will be 500 items so this would be helpful.
also i would like to retain the ability to check out individual items.
Any ideas? i tried using IF then statements in sheets but my luck wasn’t so good.