Cascading Dropdown Menu Question Type

The Cascading Dropdown Menu allows you to drill down through hierarchical data by using one dropdown menu as a filter into the next.

For example, a common use is the collection of the respondent's state and city. Using this question type, the respondent's state selection can be used to filter the options in the city dropdown.

When To Use It

If you need your respondents to select from a very large list, say the university/school they went to, that list can be up to 4000 items long! 

Using a Cascading Dropdown, you can filter the options in the school dropdown by the state selection. By making it easier for the respondent to locate values, you will improve your respondent's experience and, as a result, you will likely get better data!    

Some additional examples of when you might use a Cascading Dropdown:

  • Product Category, Product
  • Car Make, Model, Year
  • State/Province, Cities
  • Sales Region, Sales Representatives

Setup

  1. Click the Question link at the bottom of the page.
  2. Select Cascading Dropdown from the Question Types dropdown and enter the question you wish to ask.
  3. Go to the Answers tab and select a File Language (this will populate with all translated languages added via Text and Translations).
    Cascading Dropdown Question Setup
  4. Click Choose File and select the preformatted file you would like to upload (to see more about formatting your file click here).
  5. Click Add. *Repeat step 3-5 with pre-formatted files for all language versions of your survey.
  6. Make any other needed adjustments and Save Question.

Formatting a file for upload

The titles and answer options for the dropdown menus within a Cascading Dropdown must be uploaded via either a CSV, XLS, or XLSX file. You will need to first format your file and ensure that it meets a few requirements.

File requirements

The following limitations exist for files uploaded to your Cascading Dropdown:

  • CSV (comma separated value), XLS, and XLSX files can be uploaded.
  • If your file includes special characters use an XLS or XLSX file.
  • Double quotation marks are not supported in answer options.
  • File size is limited to 2 MB.
  • You cannot change your file. New files require new questions.

Formatting your file

Start with header rows - These will become your dropdown menu titles displayed to the respondent.

Cascading Dropdown File: Column Headers

Order the columns - The columns in the file must be in order starting with the highest level in the left-most column. For example, a very common use of cascading dropdown menus is country, state/province, city. The columns in your file should be in this same order. 

Populate all cells - All rows for each column must be populated. This creates the relationship between each dropdown that enables the survey to drill down based on the survey taker's response to each drop down.

Cascading Dropdown File: Populate All Cells

European File Format

If you are using a European version of Excel, your file will likely look like the below with data, including column headers, in a single column separated by commas

Cascading Dropdown File: European Format

Survey Taking

On a desktop and most laptops the Cascading Dropdown Menu question type looks like so.

Cascading Dropdown Survey Taking on Desktop

When optimized for mobile devices the Cascading Dropdown Menu question type displays in a very similar format. Many mobile devices have a native select interface to make it easier for respondents to select an option with their finger. Whether or not this is available depends on the device.

Cascading Dropdown Survey Taking on Mobile

By default, survey questions show one at a time on mobile devices to prevent the need for scrolling on smaller screens. You can turn off this one-at-a-time interaction if you wish.

Reporting

Cascading Dropdown Menus are available in the Standard Report. The first/highest level of the dropdown will be displayed as a pie chart. Below the chart, a row for each unique combination of your dropdown menus with a count and percent for each will be shown.

Cascading Dropdown Reporting

 See additional compatible chart types

 See what other report types are compatible

The below grid shows which of the report types Cascading Dropdown Menu questions are compatible with. If you plan to do some specific analysis within SurveyGizmo this report compatibility chart should help you choose the right question types!

Report Type
Compatible
Standard
 
Legacy Summary

TURF

Profile

Crosstab

Comparison

Exporting

You can also export the raw data in a CSV/Excel Export. Each column in the export will display the options title and then the question title.

Cascading Dropdown Exporting

Limitations

There are a few additional limitations you should be aware of when using this question:

  • The Cascading Dropdown Menu question cannot be used as the source question in Report and Export filtering.
  • The Cascading Dropdown Menu question does not allow for custom reporting values.
  • The Cascading Dropdown Menu question is not compatible with Offline surveys.
  • Other - Specify textboxes are not available with the Cascading Dropdown Menu question.
  • The Cascading Dropdown Menu question cannot be used as the trigger for question or page logic.
  • The Cascading Dropdown Menu question is not compatible with HTML or JavaScript embeds.
  • Uploaded file limitation - Double quotation marks are not supported in answer options.
  • Uploaded file limitation - File size is limited to 2 MB.
  • Uploaded file limitation - You cannot change your file. New files require new questions.


Basic Standard Market Research HR Professional Full Access Reporting
Free Individual Team & Enterprise
Feature Included In