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.
Auto Populate form with data from a Spreadsheet.Asked by pacollins on November 10, 2016 at 07:49 PM
Hey JotForm Support!
Is it possible to use a spreadsheet (either Excel or Google Sheets) to conditionally and automatically fill data in a specific field?
I'm using my form to as a means of collecting internal data. Ideally I would like then when a customer fills in the Product # field (Red) that the Product Description field (Blue) automatically fills. I have a few hundred descriptions, so using the conditions menu doesn't seem like a good option.
I have a spreadsheet that lists all of the product #'s and the description in different columns.
BTW - Really enjoying working with your site so far!
a JotForm excel JotForm Support product excel Google Sheets populate automatic
I am glad to know that you are enjoying jotform. Please allow me to inform you that unfortunately it is not possible to populate a form based on data from a spreadsheet when a customer enters a product number. Our forms do not have the ability to query different sources and import data automatically while the user is filling the form.
You would be able to populate fields to your form by using a URL parameters. When a user clicks that url, the form will have the data from the url parameters populated in the form. You can set it up by following our guide here: Prepopulating Fields to Your JotForm via URL Parameters.
If you need further assistance, please let us know.
Thanks. I just skimmed through the link you've provided and I think I can make this work.
I appreciate your prompt response!