- Prepare your Spreadsheet and Form.
Add the widget to your form.
Upload the spreadsheet you will use.
The bigger the file, the longer it will take for the data to load on the form.
Set up the other options on the widget.
Access Code Column
The Unique Code column index. This will help identify each data row you want to appear on the form. Say, your unique codes are in Column K in Excel, then type K in this section.
Labels Row
The column labels’ row number. This will identify each column label and fill in the exact question label from your form. The same idea applies if your column labels are on Row 1; then type in 1 in this section.
The other options, Fill Button Text and Loading Message, are relatively straight forward.
And here’s a screenshot of the actual data within the spreadsheet used for this form: