Here are some limitations and key points you should be aware of:
- The widget requires XLS, XLSX, or CSV files; it will not accept any other format.
- The Unique Code on your sheet does not necessarily need to be in the 1st column. You can place it anywhere for as long as you configure the widget with the respective column index.
- The Unique Code is case-sensitive.
- The Column Names on your sheet should match the Field Labels on your form.
For example, if your form fields were labeled like this:
Then, the column names on your sheet should be labeled exactly the same.
- The arrangement of the form fields on your form won’t matter even if you have other fields in between.
- What’s important is to ensure that the Field Labels and Column Names match.
- The widget only supports the following fields:
- Full Name
- Time
- Short Text Entry (Textbox)
- Long Text Entry (Textarea)
- Dropdown
- Single Choice (Radio Button)
- Multiple Choice (Checkbox)
- Scale Rating
- Star Rating
- When the Unique Code is correct, the values inside the fields to be populated will be
cleared and replaced by the values fetched from the spreadsheet.
If everything above looks good, let us get on with it!