Using Continuous Sum Total in a Merge Code

There isn't a built in way to use the total of the Continuous Sum question in another question. Fret not! There's a custom script for that! In this tutorial we'll show you how to use a custom script to populate a hidden value so that you can use the total later on in your survey. These steps assume a basic familiarity with SurveyGizmo and Custom Scripting.

Check it out in an example survey!

OR

Add a survey with this setup to your account.

Setup

Features used in this script:

• Custom Script Action
• Continuous Sum Question
• Hidden Values
• sgapiGetValue
• sgapiSetValue
• sgapiJumpToPage

Start by building all of your survey questions. In this example survey we have a continuous sum question on the first page.

On the next page we have a custom script action with the script below followed by a hidden value.  This hidden value will be populated by the script.  You can then use the merge code for the hidden value in later questions or text. In this case the merge code would be for question ID 5: [question("value"), id="5"].

%%contsum = 2; // The continuous sum questionID
%%hiddenvalue = 5; // The hidden value questionID

%%array = sgapiGetValue(contsum); 
%%moveto = %%hiddenvalue; 

foreach (%%array as %%key => %%value)
{

  %%chars = array(',','%','$','₠','₡','₢','₣','₤','₥','₦','₧','₨','₩','₪','₫','€','₭','₮','₯','₱','₲','₳','₴','₵','₶','₷','₸','₹');

  %%val = sgapiStr_Replace(%%chars, '', %%value);  
  
  %%finalval+= %%val;
}


sgapiSetValue(%%moveto,%%finalval);


sgapiJumpToPage(4); //Change this number to the page ID of the following page.

Required Customizations

In the script above you will need to customize variables highlighted in yellow in order to make the script work the way you'd like.

%%contsum - This is the Continuous Sum questionID.

%%hiddenvalue - This is the Hidden Value question ID where you wish to store the total.