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

    How to create dropdowns that depend on other dropdowns

    Asked by redeemedbook on January 31, 2017 at 04:58 PM

    I have columns in spreadsheet that contain the state of Nigeria and some other countries. if a user select Nigeria in the first drop down in a form , the second dropdown in the form  should be populated with state already in the column of the spreadsheet

  • Profile Image
    JotForm Support

    Answered by Jim_R on January 31, 2017 at 05:53 PM

    There's no way to populate a Dropdown Field (or any field in particular) from an external source, like a spreadsheet.

    If you will be using the regular Dropdown menu for the country,

    then you would need to use Conditions to conditionally show another Dropdown menu for the states.

    Complete guide: How-to-Show-or-Hide-Fields-Base-on-User-s-Answer

    It's also worth mentioning that there's no way to conditionally change the options within the Dropdown menu. So, you're limited to setting them up manually on the Form Builder.

    Another approach is to use a widget. The Dynamic Dropdowns Widget might fit your requirements.

    Related guide: How-to-Add-a-Widget-to-your-Form