How to set up a barcode scanner with QR codes

Prev Next

In the FastField app, you can use a barcode scanner to retrieve code and populate data based on a pre-defined lookup list. To do this, you will need a list of your barcodes or QR codes with corresponding data in the same row for each column.

For example, I want to make QR codes and attach them to my equipment to be scanned for an inspection. If you prefer to make a Barcode the same goal can be achieved.

  • I created a spreadsheet of my equipment for data mapping:

    Spreadsheet of equipment with serial numbers for data mapping

  • Next, I will need to generate QR codes based on the serial numbers. There are many free third-party software applications that can be used to generate QR codes. Upload your list and generate the corresponding codes.

    QR code generation tool interface showing serial numbers

  • Next, in the List section of the portal, save and upload the equipment sheet into your account as a lookup list (only .xlsx and .csv file types are accepted).

    List section of the FastField portal showing lookup list upload

  • Create a form with the barcode field along with static text fields that will display data when the barcode is scanned. I'll need to map the barcode in the form.

    Legacy Form Builder showing barcode field with static text fields

  • Go into the advanced options and select Lookup Mappings.

    Advanced options showing Lookup Mappings setting

  • Create a new mapping, using the data lookup mapping example as a reference. 

  1. Create a new lookup list (named Moving Company Equipment)

  2. Select your list of lookup data

  3. Assign the search field, in this case it will be the barcode field looking for the serial # that represents the QR.

  4. Set the display fields — these fields will populate the static text fields.

    Lookup mapping configuration with search field and display fields

    If you have mapped your data correctly, it should auto-populate the corresponding fields on your form.

    Form auto-populating fields after QR code scan