JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Is it possible to populate fields using an Excel Spreadsheet?Asked by chrisjsills on June 18, 2015 at 07:32 PM
I'd like to create a form with a populated drop down list of account numbers, and based on what account number is selected from drop down list have corresponding fields populate with data from either an excell spreadsheet, google sheets or some other solution you could recommend.
Any assistance is much appreciated.
Unfortunately, we don't have such feature.
You can prepopulate the fields in your form using URL parameters as described here: http://www.jotform.com/help/71-Prepopulating-fields-to-your-JotForm-via-URL-parameters, but you would need to create an external script in order to create the appropriate URL.
So, for example, you could create a form with the dropdown you want to use, submit it and capture the selected value using POST or web hooks then you can use a custom script to do the searching on the spreadsheet, database, etc based on the selected option and redirect your users to a second form with the URL parameters for the prepopulated fields.
I hope this makes sense.
If you've further questions, please let us know.