How to Pair Reference Data to a Barcode in the Builder

Have more questions? Submit a request

Using reference data, barcodes can automatically populate information about the item scanned, saving precious time in the field and reducing errors. 

Format the File

The process for formatting a file containing a barcode is exactly the same as any other reference data file. Examples for this use case will be included in this article but the details have been laid out more thoroughly in the article, "How to Properly Format a Google Sheet or CSV File for Reference Data."

In the example below, we are using barcodes to identify products in a grocery store, what aisle the item can be found in, and the remaining inventory.

RD&I_Barcode Example.png

Upload the File

There are several methods to upload your file to GoCanvas. If you are in the Legacy Builder, a .csv file can be uploaded from within the builder or on the Reference Data & Images tab. If you are using the Builder or Google Sheets, all reference data files must be uploaded on the Reference Data & Images tab. Learn more the Google Sheets integration here.

Mapping the Fields

The steps to map the columns in the file to the fields in the form follow the same process as is detailed in, "How to Add Reference Data in the Builder." In this example, the barcode field is the parent field and will determine how the remaining three fields populate. 

Note

Barcodes are not limited to only being parent fields, they can also be used in dependencies, which you can learn more about in the article about dependent reference data.

  1. Edit an existing form or select Create New to start a new form.
  2. Find or create the barcode field that will be the parent field. Select the Settings gear to open the Field Settings modal.
  3. Toggle to the Reference Data tab.
  4. Select the correct reference data file from the first drop down menu.
  5. The Reference Column is the column of data from your file that you want to appear in this field. We named both the column and field "Barcode" so this step is easier. The parent field is complete after the reference column is selected.Builder_Barcode Example_Parent Field.png
  6. Find or create the next field that will be attached to the reference data. Select the Settings gear to open the Field Settings modal.
  7. Toggle to the Reference Data tab.
  8. Select the same reference data file used for the parent field from the first drop down menu.
  9. Choose the column of data from your file that you want to appear in this field. The next column in the file is "Product."
  10. In order to have this field know automatically what field value is needed based on the selection in the parent field, we need to tell it where the parent field is located and what it is called.Builder_Barcode Example_Second Field.png
Reference Screen
This is the name of the screen where the parent field is located. The parent field could be located either on the same screen or on an earlier screen.
Reference Field
The name of the parent field.

Repeat steps 6 through 10 until all columns are mapped to the reference data file. Save and Test to make sure your form works as intended.

Articles in this section

Was this article helpful?
0 out of 0 found this helpful
Share

Comments

0 comments

Please sign in to leave a comment.