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

    Drop Down list depending on the value selected in a previous drop down list

    Asked by gemai on November 23, 2015 at 08:58 PM

    Hi there

    In the address area, I have 2 fields with drop down lists: City and Suburb.

    City shows all the values available. Then, depending on the city chosen by the user, the list of suburbs varies, showing only the suburbs included in that city.

    What's the best way of doing so in JotForm?

    Cheers

        Gema

  • Profile Image
    JotForm Support

    Answered by Chriistian on November 24, 2015 at 01:52 AM

    Hi,

     

    I would suggest you to use Dynamic Dropdowns widget. You can find it here: http://widgets.jotform.com/widget/dynamic_dropdowns. A demo is provided here: http://form.jotformpro.com/form/43514646570961.

     

    Do let us know if you need further assistance.

    Regards.

  • Profile Image

    Answered by gemai on November 24, 2015 at 03:56 PM

    Hi Chriistian

    As suggested, I have used the dynamic dropdown widget in the form https://form.jotform.co/53276556492869

    The form works fine but in the integrated Google Sheet, both fields come together in the same column 'City & Suburb'. How can I have that information stored in 2 different fields?

    Cheers

        Gema

     

  • Profile Image
    JotForm Support

    Answered by Kevin_G on November 24, 2015 at 06:11 PM

    Hi,

    There is now way to split it in different fields, since both values are in the same field, if you want to get the values in different fields , you should use the selct fields and add some conditions, hide or show the Suburb field depending on the selection of the City field.

    Take a look to my sample form, you can see the conditions I'm using : 

    https://form.jotform.com/53277013820954

    Refer to this guide to clone a form : 

    http://support.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

    Hope that helps.

    Let us know if you need further assistance, we will be glad to help you.

    Thanks.

  • Profile Image

    Answered by gemai on November 24, 2015 at 08:26 PM

    Thanks Kevin! With this solution I have the suburb field more than once, depending on the number of cities. hmmmm, a workaround, I guess. Cheers

  • Profile Image
    JotForm Support

    Answered by Kevin_G on November 24, 2015 at 09:37 PM

    Hi,

    You're welcome.

    Yes, you have the City and Suburb in different fields, and you need to add a Suburb field for each City, i.e if you have 4 Cities, you have to add 4 Suburb fields.

    That is the only way I could find to achieve what you want,but if you want can keep using the widget.

    Let us know if you have more questions, we will be glad to assist you.

    Regards.