Using External List Sample

Using External List

First, download the attached survey and import it into your organization:

http://support.dooblo.net/entries/22388573-How-to-import-a-survey

Add the attached subject store called: ‘Drinks’
as a subject store to the survey:

http://support.dooblo.net/entries/22793802-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.

 subject_store.jpg

Create a new List Source in the survey “Advanced”.

In our case we created 2 lists: Brands, Variants.

 list_sources.jpg

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

In our example:

 edit_source_list.jpg

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.

External_List.jpg 

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:

 advanced_script.jpg

In this script we used the function: ‘dblGetSubjectStoreRow’  that retrieves a single row from a subject store, see more about this subject here: http://support.dooblo.net/entries/23219682-How-To-retrieve-a-single-row-from-a-subject-store

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

validation.jpg 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

2 comments
  • This demo doesn't work. 

  • Hi Arindom,

     

    We are sorry for the late reply. This comment was mistakenly identified as Spam.

     

    Can you let us know what do you mean by doesn't work in your context?

     

    Regards,

    Michael

     

Please sign in to leave a comment.