Populating dropdown menu items from a google spreadsheet

  • Profile Image
    coskun.ozgur
    Asked on June 15, 2020 at 09:33 AM

    Hi,

    Please let me know if Jotform can populate dropdown questions menu items from a Google Spreadsheet? If yes please describe how.

    Thanks,

    Coskun Ozgur

  • Profile Image
    Anita_K
    Answered on June 15, 2020 at 10:14 AM

    Hi,

    Unfortunately, it is not currently possible to populate dropdown options from external sources.

    I will raise a feature request for this by our developer team, however, please note that we cannot give an ETA on if or when this feature gets implemented.

    Please do not hesitate to reach out to us with any further questions.

  • Profile Image
    AgilityAssoc.Canada
    Answered on June 15, 2020 at 10:27 AM

    Hi,

    Although it is possible to set check-boxes and radio-buttons. I do this frequently. Perhaps this is an option that works for you.

    Just my 2 cents worth.   Robert

  • Profile Image
    Richie_P
    Answered on June 15, 2020 at 11:12 AM

    Hello Robert, can you please share more information regarding your work around? Would it be using the Spreadsheet to form widget?

    Thank you.

  • Profile Image
    AgilityAssoc.Canada
    Answered on June 15, 2020 at 12:22 PM

    Hi, Yes that is what I use on form 201636325537959. It works very well. There are three radio-boxes on this image that are matched by the text in the options. Clubs are usually selecting the same for their events. The sheets has a record of these selections and inputs option automatically. The options can be overridden. If user wants a change they send me an email with all they want to be done automatically. This helps them fill the form quicker and not have to keep answering the same questions over and over.

    Example of a section of the form:

    159223809506-15,20-JotForm-s2f.jpg 

    I hope this helps.

    Robert

  • Profile Image
    Anita_K
    Answered on June 15, 2020 at 01:35 PM

    Hi Robert,

    thank you for providing this workaround!

    @coskun.ozgur

    I have forwarded your feature request for prepopulating dropdowns to our backend team.

    Meanwhile, you could consider using radio buttons instead of a dropdown and populating them with a Spreadsheet to Form Widget.

    Please let us know if you have any questions about this.