Automaticly fill in field out of database in a form

[Mark1]

Hi,

i am trying to use the bar code scanner to fill in my data.
i have a database and from that database i can retrieve all the information i need.
that database is located on a google sheet.

when i scan the bar code the app needs to located the same bar code in the sheet.
then it needs to retrieve internal name and production date.
the database only shows the first 10 digits of the barcode because the rest of the barcode gives qty and pallet number.

background for this app:
i am making this app to maintain my inventory.
some of the products need to be quality checked before it go’s on stock.
the app will let me know if items need to be checked because they are not in the database.
i also keep track what comes in and what go’s out of stock.
pallets are identified by item, production date , pallet number,.

hopefully some one can help me because i can not find a sample app that does this
thanks

[Marc_Dillon]

Let’s assume your database sheet is loaded into the app with the name ‘database’

You would set LOOKUP() expressions for each subsequent column (after barcode) in your scanner table. And use the LEFT() expression to only get the first 10 digits.

help.appsheet.com

LOOKUP()

Get column value from row in table or slice

LOOKUP( LEFT([barcode] , 10) , “database” , “barcode” , “internal name/qty/etc”)