Using External List Sample

Using External List

Online Video

Direct Youtube link (for full screen): https://youtu.be/LRFz72SpDbY

Direct Youtube link (for full screen): https://youtu.be/yO9CRGcxb2Q

Steps

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. 

    0
    Comment actions Permalink
  • 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

     

    0
    Comment actions Permalink

Please sign in to leave a comment.