-
gemaiAsked on November 23, 2015 at 8: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
-
Chriistian Jotform SupportReplied on November 24, 2015 at 1: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.
-
gemaiReplied on November 24, 2015 at 3: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
-
Kevin Support Team LeadReplied on November 24, 2015 at 6: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.
-
gemaiReplied on November 24, 2015 at 8: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
-
Kevin Support Team LeadReplied on November 24, 2015 at 9: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.