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
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
)