Look up a value from QR Code Scanner, and get a list of associated variables

[korfanidi]

Hi there!

Newbie here, sorry if this seems too easy. I have been looking on forums and YouTube and I can't seem to get it right!

I have an excel sheet with format:

Car Pass Code	Team Assigned to	Valid	Lost	Number Plate
12 34 56 78	Bob	Y	N	1-NUMB-PLATE
34 56 78 89	Mary	N	Y	2-PLATE-NUMB

My goal is to scan the QR code (that just codes the number from the first column) i.e. 12 34 56 78 and to get as a result a list like:

Car Pass code: 12 34 56 78

Team Assigned to: Bob

Valid: Y

Expired: N

Number Plate: 1-NUMB-PLATE

and then the possibility to:

a) edit this data

2) go back to scanner and scan another QR code.

I manage to have the results by typing the code, but I can't by scanning it.

Can someone help with the coding please??

Thank you in advance,

Katerina

[WarrenBelz]

Hi @korfanidi ,

The Item of the Form (ensure also the DataSource is set to the table name) would be

LookUp(
   ExcelTableName,
   'Car Pass Code' = BarcodeScannerName.Value
)