All of our inventory has barcodes, for example for Item: PF1234 the barcode in physical tag is PF1234--Red--XXL
I am trying to create a view where I can scan my product barcode and the app can tell me what is the quantity of the stock from Google Sheet
My Sheet Contains:
Product Name, Sale Price, Current Quantity
Can anyone help, I am unable to complete this Use Case.
Thanks,
You may want to start from this:
And replace the main table with your data. Make sure the column containing the Barcode has the property "Key" set on.
Otherwise, please share screenshots of your data structure from the app editor (Data>Columns)
User | Count |
---|---|
35 | |
31 | |
30 | |
20 | |
17 |