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.
Drop Down list depending on the value selected in a previous drop down listAsked by gemai on November 23, 2015 at 08:58 PM
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?
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.
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?
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 :
Refer to this guide to clone a form :
Hope that helps.
Let us know if you need further assistance, we will be glad to help you.
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
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.