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.
How can I have a question on my form where the available answers pull from a data sourceAsked by dmcdermott on September 20, 2016 at 08:27 AM
I have a need to find a form building solution that will enable me to link a question being asked to a data source i.e. table of information. The end user filling out the form needs to be able to dynamically search the data source and make the appropriate selection.
Maybe we will need more information on how you would like to have the workflow of this, but I created this demo form: https://form.jotform.com/62635045311952 where I used Conditions to show/hide the answers. And for answers I used Autocomplete widget:
So you can input in Autocomplete possible answers that your customers can choose from:
Or maybe use a drop-down menu where they can just choose the possible answers from the available ones.
Hope it helps, if you have any further questions or had something else in mind please let us know.
thank you for the fast reply. Let me try to be more specific. I want a question/field where form respondents can type in a name, address or phone/fax number and for the field to search a connected data source (excel sheet or other data source) then pull up any matches with the complete row from external data source but formatted if possible/clean so responder can decide if that is correct choice and they can select it if so or try another search (of the linked external source).
That will not be possible to accomplish with our features. In order to accomplish it, you will first need to hire a developer, and download the full source code of your form: https://www.jotform.com/help/104-How-to-get-the-Full-Source-Code-of-your-Form
In that way, the developers can connect to your database, and create the proper script to automatically pull the data into your form field.
Open a new thread if you need anything else, we will be glad to assist you.