Many customers are looking for a way to set up logic based on the answers to Continuous Sum questions. While there's not a built-in way to achieve this, there is a pretty simple workaround! Using Hidden Values you can store the values entered in your continuous sum question and then use these fields to base your logic off of. Here's how!
Setup
- Start by setting up your Continuous Sum question and make sure that the Answer Format is set to Number on the Validation tab.
- On a page that follows your Continuous Sum Question add a Hidden Value for each row of your continuous sum question.
- To pull the value from the Continuous Sum row click the Select a Merge Code link below the Populate with the following field and select a single row/option from your Continuous Sum question.
- Then click the Insert button to insert the merge code; this merge code will be populated with the value the respondent entered in this specific row.
- Once you have a Hidden Value per row, the data stored in each of these will be available for logic setup for questions on the same page or later pages as the Hidden Values. To set this up edit your question and go to the Logic tab. Select the appropriate hidden value and complete your logic rule.
What If I Want to Use Percent or Currency Formatting?
If you are planning to use any of the greater than, greater than or equal, less than, or less than or equal operators these will not work in combination with the percent or currency validation as the characters are stored as part of the data. Your best bet is to use the number validation!
Admin
— Dave Domagalski on 08/09/2019
@Matt: Thank you for your question!
What you are looking to do is not available as an out-of-the-box feature. Having said that, we have documented a workaround using Custom Scripting:
https://help.surveygizmo.com/help/setting-max-total-value-dynamically
I hope this helps!
David
Technical Writer
SurveyGizmo Learning & Development
— Matt on 08/09/2019
I would like to set a max total for a continuous sum based on an answer from a previous question. For example, If I ask a respondent "How many pieces of candy did you eat?" ...and they respond with the number "5". I would like to follow up with the continuous sum question "What types of candy did you eat?" and give the options of "Chocolatey, Sugary, or Other". How do I force them to include three numbers that equal 5?
Admin
— Dave Domagalski on 06/19/2019
@Nikki: Thank you for your question!
I'm afraid that there is not a built-in feature to force a '0' value in a Continuous Sum field. This scenario would require a custom solution via JavaScript.
One potential workaround would be to use the 'Default Value' column on the Continuous Sum's Question tab (when editing). The default value could be set to 0 for all answer options and perhaps some clarifying instructions for respondents could be added.
I'm sorry for the trouble and hope this helps!
David
Technical Writer
SurveyGizmo Customer Experience
— Nikki on 06/19/2019
Hey there!
Am trying to use the method above to terminate based on a few specific fields in a continuous sum.
Is there a way to force a '0' value in a continuous sum option field if a field is left blank so the 0 can then be used for logic afterwards?
Have applied 'must equal' value and validation to allow values between 0-10, forcing whole numbers, but blank is still allowed.
Pulling the values via merge code to then use logic on doesn't count empty fields as a numeric value to use logic on.
Also pulling the blank field means I can't require the hidden value questions and auto submit the page as it keeps auto submitting itself in a loop looking for an answer.
Any ideas?
Thanks, Nikki