How can I have a question on my form where the available answers pull from a data source

  • Profile Image
    dmcdermott
    Asked 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. 

  • Profile Image
    Nik_C
    Answered on September 20, 2016 at 11:37 AM

    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!

  • Profile Image
    dmcdermott
    Answered on September 20, 2016 at 01:03 PM

    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). 

  • Profile Image
    BDAVID
    Answered on September 20, 2016 at 02:59 PM

    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.