For the current client and they way it needed to work here, I created a new table for the Risk / assessment questions
each question has its answers as a numerical value
A onload script does nothing, but has a calculation script
function onLoad() {
//Type appropriate comment here, and begin script below
// call the function below to check Risk
calculateRiskFromQuestions()
}
function calculateRiskFromQuestions()
{
// set our initial score and a boolean field to determine if we have any empty questions
// Then go off and check each question. if not empty, get its value into Integer and add to the intScore
// If empty, add the marker and we then do not read any further questions
var intScore = 0;
var bolEmpty = false;
if (g_form.getValue('u_testing_level') != '')
intScore = intScore + parseInt(g_form.getValue('u_testing_level'));
else
bolEmpty = true;|
// repeat as needed
// see if we had any unanswered questions
// if not, check the score value and then set the risk
if (bolEmpty == false)
{
if (intScore < 15)
g_form.setValue('risk',2);
else if (intScore > 23)
g_form.setValue('risk',4);
else
g_form.setValue('risk',3);
}
This same calculation function is called as an onChange script by each of the fields that change on the form. Makes the calculation dymanic, does not bother if a value is empty
Cheers
