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.
Create a new List Source in the survey “Advanced”.
In our case we created 2 lists: Brands, 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: 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:
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.