Populate dropdown from an external database.

  • Dusty
    Asked on November 28, 2018 at 12:57 PM

    Hello, 

    Is it possible to connect a form to a mysql database to auto populate the dropdown? For example, if you type in "honda"... the form would search our wordpress database and for all of the honda makes, models, etc. 

    Thanks in advance,

    Dusty

  • jherwin
    Replied on November 28, 2018 at 1:06 PM

    You may prepopulate the form fields via the URL, here's a guide: Prepopulating Fields to Your JotForm via URL Parameters.

    Currently, it is not possible to prepopulate the form fields from an external database.

    However, you can use the Spreadsheet to Form widget. This widget allows you to upload your spreadsheet to your form and use the values you have in the spreadsheet to pre-populate your form. Please check this user guide: How to Use the Spreadsheet to Form Widget.

    Hope that helps. Let us know if you have any questions. Thank you.

  • Dusty
    Replied on November 28, 2018 at 1:43 PM
    Thank you for your quick response!
    That's not quite what I need though. Basically, we need to build a lead capture form for auto shipping. The customer need to enter their vehicle information (year/make/model). Our mysql database currently has thousands of combinations. The idea is if they enter the year and make, then the dropdown gives them the available models and trims.
    We have another table that this works for with city/state/zip.
    Is something like this possible?
    -Dusty
    ________________________________
    ...
  • Kevin Support Team Lead
    Replied on November 28, 2018 at 3:16 PM

    We do not have an element that will display data from a mySQL database, the only thing you may do is to manually list the options in a drop down and change it according to the previous selection, this widget will help you doing that: https://widgets.jotform.com/widget/dynamic_dropdowns 

    This guide will help you adding the widget to your form: https://www.jotform.com/help/252-How-to-Add-a-Widget-to-Your-Form 

    If you need to have the data pulled form a database, then you may develop your own code and implement it on the JotForm form's source code, this guide will help you getting the form's source code: https://www.jotform.com/help/104-How-to-get-the-Full-Source-Code-of-your-Form 

    Thanks.