Using External List Sample

Overview

The guide includes information on setting up your external list, integrating it with your survey, and troubleshooting common issues.

Steps

1. First, download the attached survey and import it into your organization: How-to-import-a-survey
2. Add the attached subject store called: ‘Drinks’ as a subject store to the survey: How-to-use-an-excel-file-as-a-data-list-in-a-survey

Make sure you configure the ‘ID’ column as ‘Is User Tag’ and the ‘Brands’ column as ‘IsName’, in this specific example.

In the survey sample, create a new List Source in the “Advanced” tab. In our case we created 2 lists: Brands and Variants.

In each list we created a code to pull the specific column from the subject store. In our example:

Then, define the Question as ‘External List’.

Define the answer settings according to the question.

In our case we define “External List”: <List Source> and “Select Source”: Brands.

In the last question (Q(4)) we asked: “price per unit?”

We want to create a Validation Rule that will be within the price range. See the price range in the subject store as columns:

‘PriceMin’ and ‘PriceMax’.

In order to do that we created this Advanced Script:

In this script we used the function: ‘dblGetSubjectStoreRow’  that retrieves a single row from a subject store, see more about this subject here: How-To-retrieve-a-single-row-from-a-subject-store

Finally, we entered this Validation Rule to Q(4) Rules:

That's it!