Feature Request: Special Options - States/Cities Listing for each Country

  • Profile Image
    gianluca
    Asked on March 17, 2013 at 07:03 AM

    Hi,


    i have been reading your support sections and user guide but am not to sure whether the conditional formatting is the function i need (i believe it is) but need a confirmation and possibly a link to an example.

    I am looking to do a registration form online (not a survey), and found Jotform that might be the solution for my project at work. Before i present it to my bosses, i would like to be absolutely sure its the correct solution for us.

    When looking at the demo and playing around a bit, while in the form tools you offer the dropdown options for COUNTRIES, what i need is to ensure that on another field it would show me a predefined list of towns based on the previous Country selection.

    Conditional formatting (or whatever its called in jotform) seems to refer on making sections visible/hide, but doesn't seems to be clear to me if you can use it to program another dropdown list based on previous dropdown selection.

    Essentially i need a form to show me ALL COUNTRIES in the world as (Country of birth) and subsequently on selection by user (e.g. Spain), ONLY show me Spanish towns in the following dropdown section (Town of birth), hence limiting the list.

    Is this possible?  Most importantly, as you can appreciate there is a lot of countries in the world and sub towns to upload, so is there a quicker way of uploading these in a jotform? say for example via a lookup in a php file stored on a server or perhaps an import facility from an excel or csv file?

    Its the only thing that is stopping me from signing up at the moment and taking it up to my bosses for consideration.

    Thanks

  • Profile Image
    jonathan
    Answered on March 17, 2013 at 09:43 AM

    Hi,

    You can do this using the Condition Logic in the form.

    You will use the dropdown field pre-populated with country and town.

    You can custom pre-populate a dropdown field lists with values from spreadsheet or any text file list.

     

    You can also just use the special options property of a drop-down field and select Country. I used this in my test form.

    Test this form http://www.jotformpro.com/form/30753431816957

    Select United States or Spain for the Country field, and you will see that the specific dropdown field with city/town will be display.

    I am not sure how you are going to use this form, but from what we can see, it can be a lot of dropdown fields if you will put all cities/town for each country.

    In any case, you can clone my test form to understand better how I setup the condition logic.

    Here is the guide how to clone : -How-to-clone-an-existing-form-from-a-URL

    Hope this help. Please inform us if you have further inquiry.

    Thanks.

  • Profile Image
    gianluca
    Answered on March 17, 2013 at 10:08 AM
    Hi Jonathan
    thanks for the quick response and working example. Its exactly what i was looking for in an answer.
    Sadly for me there will be a lot of dropdown condition logics, but for me its a must for the form i need at work (to avoid user mistakes) , so no
    choice.
    Already the fact that i can cut and paste from any excel file or text file is a big bonus.
    May i suggest though, for JotForm to consider offering these as standard
    like you do already from the Special options (country only)? It would
    certainly add value to your product and benefit other users.
    Maybe when i complete my project i'll send you the files over so that you may put them at the disposal of other users too as standard. Food for
    thoughts!!
    Thanks again
  • Profile Image
    Welvin
    Answered on March 17, 2013 at 02:13 PM

    Hi,

    In behalf of the Jotform Team, you are always welcome. If any issue will occur during the process of setting up your conditional logic, please let us know. We'll be willing to help you anytime.

    With regards to your suggestion, I have this thread noted and will forward to our developers. Thanks for suggesting.

     

    Thanks