
Looking for a way to use a bar code scanner app to affect inventory stock automatically
Reposting because I accidentally deleted the original post out of sheer stupidity.
I'm trying to use google sheets as a cloud based inventory for stock we keep at work. I have an app on my phone that can be used to scan barcodes and automatically log data into a google sheets with varying data that I would like to link to our online inventory.
here's a link to a test inventory I've been playing with.
on the first sheet you can see a very crude version of an inventory with basic garments and stock levels, on the second sheet you can see an example of the data that can be logged by the app as you scan a barcode.
I'm basically trying to link the first sheet so that when a barcode gets populated into the second sheet with the quantities, it automatically subtracts the items from the main inventory.
don't know if that's possible with just formulas or if I need to figure something out with Javascript.