- nmc52Asked on March 17, 2018 at 11:08 PM
Hi I am using a spreadsheet to prepopulate. I am only able to pull some of the fields. For some reason the other fields are not read but they are formatted the exact same way so i am not sure what i am doing wrong.
- JotForm SupportliyamAnswered on March 18, 2018 at 01:19 AM
I noticed that on your spreadsheet to form widget, what you have uploaded is a .doc file and not a .xls or .xlsx. The spreadsheet to form widget can only read spreadsheet document files.
If the problem persists after the necessary change, please let us know.
- nmc52Answered on March 18, 2018 at 11:43 AMI updated it but it still wont read two columns. I am not sure why.
- JotForm SupportliyamAnswered on March 18, 2018 at 01:33 PM
Just to make sure, the column titles in your spreadsheet should be the same as your field labels in your form's questions. You will also need to have a Unique Code column in the spreadsheet. If you haven't read the guide yet, please read and follow the steps from this guide carefully in order for your widget to work: https://www.jotform.com/help/442-How-to-Use-the-Spreadsheet-to-Form-Widget#_