Dependent lists

"+" button:

"Import" button:

You can read about regular lists here. Users are also able to create Dependent lists. This is useful if you want the answer of a previous question to trigger a new answer - so that, in effect, the answer to question A leads to answer B, and so on. For example, the selection of what language future contracts will be in will be dependent on the country of which the current agreement is based in.

To create a new Dependent List, click using the “+” button and tick the “Dependent” box. You will be able to see 2 columns, one named “Key” that will trigger the values of the list and the other one named “Values”. You can learn more about how Keys and Values interact below.

You can also make an existing List Dependent, by ticking the “Dependent” box. This will add a new column named “Key” that will trigger the existing values of the list.

To add in dependent list values one by one, click “+Add” and type in the key under the “key” column, this will be the specific answer chosen which will then lead to your dependent value appearing. Then you will have to type in the dependent value under the “value” column. Taking the example above, we can create a dependent list of various language options that future contracts will be based on the country which the current agreement is created in. As shown in the image below, for our example, the “key” will be Italy and the dependent “value” will be Italian. Therefore, if a user selects the country of the agreement to be Italy (key), the option Italian (value) will appear as a language option for all future contracts to be in. Note, to create multiple dependent options, simply repeat the key name and add in a different value.

This feature can also be used to add additional values after uploading a pre-existing list of dependent values from Microsoft Excel (note that only profile admins are able to edit organisation level lists. A profile-level user only can edit the profile-level lists).

Once completed, click “Update List” and if saved correctly, your value will appear. This feature can also be used to add additional values after uploading a pre-existing list of values from Microsoft Excel (note that only profile admins are able to edit organisation level lists. A profile-level user only can edit the profile-level lists).

To create a Dependent list from an excel file, go “Lists” page and select “Import” button. Since this feature also operates on a profile-level and an organisation-level, depending on what admin rights a user has, users are able to create a dependent list for various profiles and organisations.

To upload a list of values from Microsoft Excel, users can download the example import file found after you choose the “Import” button.

The excel file will have the following fields that you will need to update (highlighted in red in the image below):

Name: Add the name of your list here (B1).

Profile name: Add the name of the Profile here (B2).

Organisation name:Add the name of the Organisation here (B3).

Key: Add here all the applicable key. Only applicable for dependent lists (A6 and onwards).

Value: Add here all the applicable values (B6 and onwards).

To upload an Excel sheet of a dependent list, users will first have to create the answers to the dependent list in an Excel sheet. “Name”, “Profile name” and “Organisation name" must be filled out. This sheet must have the answers of the “select list” in column A, under “key”, and the dependent list answers in column B under “value”. In effect, column A (key) triggers column B (value) – with column B being the answer questionnaire users will get. So in the dependent list below, Italy (key: column A) triggers Italian (value: column B) – and column A, the country names, would have been the initial select list you uploaded.

Note, the countries themselves in column A (key) do not have to be in the same order as your initial list for the dependent list to work, however, the system is case sensitive so all countries must be in the same casing as your initial list.

After creating the relevant dependent list, users can select the dependent list by selecting ‘dependent list’ when creating the questions in the Questionnaire. Type in the name of the dependent list and the name of the attribute of which the answers in the dependent list are dependent upon in the ‘Depends on’ textbox.

The image below demonstrates the interaction between the two lists – where selecting “France” in the “select list” question, triggers the answer “French” in the dependent list question.

Did this answer your question?