Solution for the 15 Column Limit in the Builder

Have more questions? Submit a request

If you have hit the 15 column limit for your Reference Data and need additional space, there is a solution for connecting the data across files, or linking multiple Reference Data files to each other within one form.

15 Column Limit Solution

This solution applies to the example we will use in this article, showing how a simple list in one file can be connected to a more detailed list in another file.

GoCanvas has several file creation methods available: comma separated value (also called CSV) files, the Google Sheets integration, integrating with Procore or other database software, or using GoCanvas Web Services

Step 1: Creating your Reference Data Files

Reference Data files are most easily created using Google Sheets. If you use Excel, you will need to Save As a Comma Separated Values (.csv) file type. 

Please Note

Do not use the CSV UTF-8 (Comma Delimited) (.csv), or any specialty .csv file (i.e. Macintosh Comma Separated, MS-DOS Comma Separated, etc.) as these file types may introduce random characters or not work as expected.

This solution uses two or more files. For simplicity sake, our example singles out the parent field and consolidates the options. Your own file may have up to 15 columns.

RD&I_Spreadsheet Example.png

You will need to repeat one of the columns in the first spreadsheet in the second spreadsheet to connect the two datasets. In our example, although consolidated in the first spreadsheet, the manufacturer is listed as many times as there are items that are produced by that manufacturer in the second. This is considered dependent reference data.

If you hit the 15 column limit, your connecting column will just be the column that the 16th column is referencing. You’ll need to ensure that the column header you create in the first file matches the column header you use in the second.

RD&I_Spreadsheet Example 2.png

Step 2: Uploading your Reference Files to GoCanvas

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 Legacy Builder or on the Reference Data & Images page. If you are using the Builder or Google Sheets, all reference data files must be uploaded on the Reference Data & Images page. Please visit the Help Center article, "Upload a Google Sheet as Reference Data" to learn more.

Step 3: Mapping the Fields in your Form to your Reference Files

From the Forms page, open the particular form where you will be mapping your reference files OR select Create New if you are building one from scratch.

Mapping your First Reference Data File

First, you will need to map the file that contains the connecting column. In our example, our file containing the connecting column also happens to be the parent field, so it is fairly straightforward. As has been mentioned throughout the article, your connecting column may not be the parent field.

  1. Select the field where the first file will be attached 
  2. Go to open the Field Settings panel on the left side of the builder.
  3. Toggle to the Reference Data tab.
  4. For the Reference Data File drop down select the file you uploaded for the first list.
  5. Reference Column is the column header from the spreadsheet that this field is referencing. In our example, the column is "Manufacturer" and is the only column in the file. The remaining drop down fields remain empty, as this is also our parent field.

B3_Two File Method_Parent Field.png

Mapping the Second Reference Data File

  1. Select the field where the first file will be attached.
  2. Go to open the Field Settings panel on the left side of the builder.
  3. Toggle to the Reference Data tab.
  4. For the Reference Data drop down select the file you uploaded for the second list.
  5. In the Reference Column option, select the corresponding header that this field will reference. In our example, that will be "Item."
  6. For Reference Screen select the screen in your form that contains the field mapped to the connecting column. In this example, the Item list is determined by the selection from the Manufacturer list. So the screen that contains the Manufacturer field should be chosen here, i.e. "Item Details."
  7. In the Reference Field drop down select the field mapped to the connecting column, i.e. "Manufacturer."                                       
  8. Save and Publish to test on your device.

B3_Two File Method_Second Field.png

Did we answer your question?

We'd really appreciate your feedback! Please leave your suggestions for improvement in the comments or let us know what you're looking for so we can assist you better. We want to help, but we need to understand your needs!

Articles in this section

Share

Comments

0 comments

Please sign in to leave a comment.