Barcode Scanning Inventory Management

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,

0 1 71
1 REPLY 1

Aurelien
Google Developer Expert
Google Developer Expert

Hi @Kaushal_Didwani 

You may want to start from this:

Filtered Dashboard

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)

Top Labels in this Space