Multi-tier lookup table question

Multi-tier Lookup Tables are used to represent hierarchies of data. For example, if you needed users to select from a very large list, say the university/school they went to — the list can be up to 4000 items long. In such cases, Multi-tier lookup tables can be used to segment the data. For example, users could choose the state and then see a list of all universities in that state from which to select the university.

This can apply to any kind of hierarchical data — Product Category, Product, etc.

How do I create a Multi-tier lookup table?

The Multi-tier Lookup Table tool can be accessed under the Advanced Question menu:

    • Login »  Surveys »  Edit
  1. Click Add question to add a new question.
  2. Go to Advanced Question Types, and then Data/ Reference
  3. Select the Multi-tier Lookup Table.option
  4. Survey Software Help Image
  5. Enter in the Question text and answer options. Enter in the answer option text for the primary drop down menu and separate the options for the secondary drop down menu using comma as shown in the below screenshot.
On the survey, the primary drop-down select menu will have the options West and Mountain West.

Survey Software Help Image

Dynamic Lookup Table type question cannot be edited due to technical limitations. If you want to make changes to the question, you will need to delete the question and add a new Dynamic Lookup Table type question with required changes. Please note that if you delete a question all data collected for that question will also be deleted.

On the survey the question will be displayed as follows. Respondents can select an option from the first drop menu and based on the option selected then next drop menu will be displayed.

On the survey the primary drop down select menu will have the options: West and Mountain West. Once you select an option for the primary drop down list, the secondary drop down select list with corresponding options will be displayed.

Survey Software Help Image

I have a large list I am using in the Multi-tier lookup question and do not want to have to retype this every time I need to make delete and re-add this question back into my survey. What can I do to make this easier to change?

A best practice when using a Multi-lookup table in a survey is to have your question and answer list saved in a word or text document that you can use for making changes. Then, you can delete the old question and easily replace it with the new Multi-tier lookup question.

Settings:

There are various settings available with this question type:-

Survey Software Help Image

1. Validation & Display settings:

Survey Software Help Image

Validation: You can enable validation and make the question mandatory. You can also validate a character limit as soon as you enable the option.

2. Tips:You can add tips on how to take the survey or what exactly the question means so that the respondent finds it easier to respond without any confusion. Check how

Survey Software Help Image

License & Access Options

This feature/tools described here are available with the following license(s) :

Team Edition

Unlimited Surveys, Questions, Responses

Advanced Toolset and Features

No Long Term Commitment