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

    Is there a way to use dropdown list that its options will be auto updated from an external source?

    Asked by mtkkwppl on September 15, 2016 at 07:46 AM

    Is there a way to use drop down list that its options will be auto updated?
    I would have client list in drop down list. But what should i do when list of clients will increase?
    Is there a way to not update it manually?

    auto update list dropdown list
  • Profile Image
    JotForm Support

    Answered by Welvin on September 15, 2016 at 10:50 AM

    You are currently using our User Contributed Dropdown widget. This widget can be useful if you want users to dynamically add an option in the dropdown. If you don't want this to happen and if you want to manually update it instead, you can use our basic dropdown field from the Basic Fields section.

    To add a client, you will have to edit the form and list it down in the dropdown options. 

  • Profile Image

    Answered by mtkkwppl on September 15, 2016 at 11:26 AM

    I used this list only for testing. I update a list of customers in the spreadsheet google and google contacts with additional applications. Is there any possibility that the value from the drop-down list have been taken from outside, for example with google spreadsheet?

  • Profile Image
    JotForm Support

    Answered by Welvin on September 15, 2016 at 12:37 PM

    We don't have such feature to populate a dropdown from an external source. You'll have to code that outside Jotform builder. You can get the form source codes and manipulate it to update the dropdown.

    https://www.jotform.com/help/104-How-to-get-the-Full-Source-Code-of-your-Form

    I cannot give you an example, I'm sorry for that. But I've found the following page that would help you achieve it.

    http://stackoverflow.com/questions/21392445/update-dropdown-from-spreadsheet-in-apps-script 

    Let us know if you need further help on this.