Problem with a check box form

[mfphotography99]

Hi Guys

I have created a form with 20 check boxes  each check box is named vital signs 1-20 what I have managed to do is add up all the check boxes and display the answer as a percentage using the following:

var total = 0;

for (var i=1; i<=20; i++) {

if (this.getField("vital signs "+i).value!="Off") total++;}

event.value = total/20;

my problem is that if 2 particular check boxes (Vital signs 3 & Vital signs 6) if either is not ticked then the percentage total  needs to be 0% but if they are both ticked then the true percentage for all 20 check boxes needs to be displayed

also if the percentage is less then 80% the total box needs to be red

please can anyone help

[Thom Parker · Accepted solution]

To handle special conditions, just add a conditional.

if((this.getField("vital signs 3").value=="Off") || (this.getField("vital signs 6").value=="Off"))
{
  event.value = 0;
}
else
{
   var total = 0;
   for (var i=1; i<=20; i++) {
         if (this.getField("vital signs "+i).value!="Off") total++;
    }
    event.value = total/20;
}

// this bit really belongs in a format event, but it works here in the calculation just fine.

event.target.strokeColor = (event.value<.8)?color.red:color.black;

[mfphotography99]

thanks Tom that works great I appreciate your help