What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

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.


  • Profile Image

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

    Asked by Jared  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?

    populate field
  • Profile Image
    JotForm Support

    Answered by jonathan 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.