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.
How to create dropdowns that depend on other dropdownsAsked 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
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