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

    Feature request: Populate dropdown options with value from google spreadsheet.

    Asked by Atbam on February 17, 2015 at 08:16 AM

    so if i have a1,a2,a3,a4,a5, as items in a spreadsheet and i then add a6,a7,a8,a9 . it will update my jotform dropdown list from a1,a2,a3,a4,a5 too a1,a2,a3,a4,a5,a6,a7,a8,a9, automatically




    dropdown list
  • Profile Image
    JotForm Support

    Answered by ashwin_d on February 17, 2015 at 09:38 AM

    Hello Carl,

    Unfortunately it is currently not possible to populate your dropdown field from any external sources. The only option is to manually input the values in the dropdwn question of your form. 

    Let me create a feature request and send it to our back end team. Please be noted that creating a feature request does not ensure that feature will be implemented but it completely depends upon the feasibility and priority of our back end team. We will get back to you as soon as we have any update form them.

    Thank you!

  • Profile Image

    Answered by Atbam on February 23, 2015 at 02:54 PM

    Thank You

  • Profile Image

    Answered by suuwebservices on February 22, 2016 at 11:44 AM

    I'd love to see this feature a reality as well!

  • Profile Image

    Answered by lafhab2 on May 19, 2016 at 02:38 PM

    Without doubt, being able to create and use common lists (either on Jotform or external) for a dropdown would make Jotform so much easier to use.  In short it's a feature of being able to use common drop-down options across forms which use an external list - live - as the options.  

    From an end user perspective it's hard to see either a) a reason not to, and b) a technical issue in implementing, and there is clearly demand for this.

    To clarify, we would be able to create a number of 'lists' then create forms which refer to the list, and we could edit the lists at any time which would be instantly reflected in the relevant forms.  IE: form options = LIST X.

    We are in education and training, with students using multiple forms.  Because repeatedly updating commonly-used lists across many many forms is not feasible, we have to use text boxes and let them type their name, manually.  This leads to spelling errors and Capitalisation issues.  For us, we would create a dropdown across our relevant forms called 'Student' which would then always refer to a 'live' list (which can be updated at any time) would be a very welcome feature, Jotform.
  • Profile Image
    JotForm Support

    Answered by Mike on May 19, 2016 at 02:56 PM


    I have moved your post into a separate thread to be able to forward an additional feature request ticket to our developers.


    Thank you.

  • Profile Image

    Answered by ExplorationSociety on September 20, 2016 at 08:12 AM

    I would

    also like to be able to use this feature for use in creating a payroll for freelance staff. I want to update the events so that requests for payment are matched to event codes. Updating the jot form manually every time we add a new event is a pain.




  • Profile Image
    JotForm Support

    Answered by Chriistian on September 20, 2016 at 10:34 AM

    Hi @ExplorationSociety,

    I created a separate for you so we can attend to your concern properly. Please see the thread here. https://www.jotform.com/answers/936932.

  • Profile Image

    Answered by miguelben on December 08, 2016 at 01:32 PM

    I would also love this feature. Please add it! I'd use it all the time.



  • Profile Image
    JotForm Support

    Answered by John_Benson on December 08, 2016 at 02:13 PM


    We will update you once the feature request is complete. Thank you.