Populate Dropdown list using SQL query

  • Profile Image
    foobar297
    Asked on January 19, 2017 at 07:28 PM

    Can I do a SQL query from a database to make a dropdown menu?

  • Profile Image
    jonathan
    Answered on January 19, 2017 at 11:35 PM

    You can achieve this by using the full source code of the form and then create your own custom SQL query script that will populate the Dropdown list field.

    This process will require custom programming on your part (the SQL query data injection code)

    Here is a similar discussion thread you can review

    https://www.jotform.com/answers/369587-How-do-I-populate-a-dropdown-menu-with-items-from-a-Google-Sheet

    Although in that discussion the source data is from a google spreadsheet. But the concept is very much the same to what you need.

    Hope this help. Let us know how we can be of further assistance.