How to accsses from a script data from previous rounds of the same survey

Overview

When conducting a survey in rounds you might want to present collected data from the previous round to the surveyor.

 

In this how to we will use the following example in order to demonstrate this method- we have a list of SKUs for which we keeping track of ‘available stock’ in our survey we are iterating over all SKUS and we want to display their previous stock amount and ask for the current one.

Steps:

Step 1: creating the SKU list

Create an additional data list that will hold the data that needs to be carried from one month to the next (see here on how to add additional data lists:http://support.dooblo.net/entries/22793802-How-to-use-an-excel-file-as-a-data-list-in-a-survey).

For example, this list can be composed of the SKU, SKU_code and PreviousStock columns. In the first month the value of PreviousStock will be 0 for all SKU's.

So the list should resemble this list:

 1.png

Step 2: Create a loop chapter which will loop over all the SKUS and Add a question to the survey which will ask for the new stock count and will display the previous one

  1. Add a loop chapter which will iterate over a scale, the scale will contain all the SKUS as they appear in the list.
  2. Add a numeric question to the survey:

 2.png

     3.  Add the script to display the previously noted stock:

 3.png

Step 3: After a round is over, update the list using the collected data

  1. Export the data to excel.
  2. Add the exported data to the SKU additional data list, you can either edit it manual in the studio or edit the original excel file and then replace the original list in the studio (right clicking the store and choosing ‘replace’):

 4.png

Now the surveyor will see the previously collected data presented in the interviews:

 5.png

 

That's it!

 

Visit us at:  http://www.dooblo.net

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

Comments

0 comments

Please sign in to leave a comment.