Preload data by reading a barcode

Hello @Ajmerry_Hossain

Apologies for the late reply, I just visualized your message.

Please find attached an example form using the csv preload feature.
It works as follows:
a- Scan a qr code (type 'barcode' in xls).
b- The value contained in the QR code is looked-up in the support file column 'qr'
c- The value of the 'field' variable in the corresponding record is pulled (calculation, appearance pulldata())
d- The 'field' value is displayed in a note message
e- if b) or c) fail, an error message is displayed

Note that you can customize the steps as needed, e.g. pull information directly from the qr code, or manipulate the info of the barcode (example substring) and pull data only using that bit, etc.

I hope this helps.

Best,
Andrea

preload_data_form_QR.xml (1.7 KB)
support.csv (111 Bytes)
preload_data_form_QR.xlsx (57.6 KB)