Today I am going to share with you a trick in providing graphical information to the work force.
Imagine you are in the shop fitting business with lot of people out in the field. Your fitters are given a job, and they require information about the products they are using or fitting.
By adding the product images and using some basic formulas, you can scan a barcode of a given item – it is possible to bring back various information on the product.
Here’s how to do this!
• First create a Data Link Drop Down with all your product information, you’ll need this later. Here’s one to give you an idea.
• Now add a barcode scanner control to the form. I’ve called mine ‘QR Code Scanner.’
• For each product add an image control on to the form, and give each one a different name.
• You want the right image to appear depending on the bar-code, so add formulae to hide images depending on the bar-code. I’ve used;
‘QR Code Scanner'<>”1111111111“.
Highlighted in Bold is the code for a given stock or asset item.
• Add a text box control and make it hidden – This control captures the information from the bar-code scanner before passing this into the Data Link Drop-down as a lookup.
• Now add a Data Link Drop Down control to the form.
• On the Data Link Drop Down control you will need to insert the following formula =‘QR Code Scanner’.
This formula is pointing to the barcode scanner, and when there is a successful match the associated information on the Data Link Drop Down is selected on the form.
And this is how it will look on the device