Important Update to Custom Scripting
SurveyGizmo's CustomScript Action now supports the LUA programming language. Visit our NEW Lua Scripting Resources!
Legacy Custom Scripting Language Deprecation Plans
- New accounts (created after October 29, 2018) will only have the option to use Lua in scripts.
- As of October 29, 2018 Custom Scripting Actions will default to Lua as the scripting type in the Custom Scripting Action for accounts created before this date. You will be able to switch to the Legacy Custom Scripting; though we highly encourage using Lua.
- In the long term, Legacy Custom Scripting Actions will be switched to read-only. The exact date on this is to be determined; we will send notifications well ahead of time.
This returns the cumulative sum of all the numeric values answered for the given question ID from responses that have already been processed.
This function requires numeric reporting values. The sum that is returned will not include data from any responses that haven't been processed; this includes the current response when the script is run. For instance, if you ask, in a textbox question, for the number of guests this function can be used to get a total number of guests entered so far by all previous respondents whose responses have been processed.
In this example, we display the sum of all numbers entered into the question with ID 2.
%%output .= 'Total meals ordered: '.sgapiResultsQuestionTotal(2);
Output would be: Total meals ordered: 6