Can a field be autofilled from a database based on another field's user selected value?

  • Profile Image
    Jared 
    Asked on September 19, 2016 at 06:02 PM

    Can I create a drop down list of 'Locations' and have the address autofill using values from a database table?

  • Profile Image
    jonathan
    Answered on September 19, 2016 at 10:25 PM

    Hi Jared,

    You will need to manually populate the Dropdown list from your data source (database table). Example, if your database is a spreadsheet, you will need to copy those data from the spreadsheet and then just paste it to the 'options. of the Dropdown list field.

    There are some workaround available but it requires knowledge of javascript. Here is a discussion thread were another user have suggested a solution.

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

    --

    But if what you are after is just a basic process of population a field base on another field, then, that can be achieve within the Form Builder.

    Check this user guide: https://www.jotform.com/help/71-Prepopulating-Fields-to-Your-JotForm-via-URL-Parameters

     

    Hope this help. Let us know if you need further assistance.