-
nathanday366Asked on June 30, 2024 at 4:04 AM
-
Mary Eden JotForm SupportReplied on June 30, 2024 at 5:55 AM
Hello Nathan, Hello Nathan,
If you have your respondent's details in an Excel file already, you can use the Spreadsheet to Form Widget to prefill all of the fields when the respondents enter a keyword as an access code. Let me show you how to use it:
1. Create a spreadsheet that includes your data in the structure you see below. The column names in the spreadsheet and field names on the form must be the same.
- In Form Builder, click on the Add Form Element menu on the left side of the page.
- Under the Widgets tab, search for the Spreadsheet to Form widget and add it to your form.
- In the Widget Settings window that opens up, upload your data file and customize the other options.
- Then, click on Update Widget.
Check out the screencast below to see my results:
Give it a try and reach out again if you have any other questions.