I have a few problems with the form I created.
My form has many fields, rows and columns.
example:
row 1: entervalue1 entervalue2 entervalue3 addvalues 10%values
row 2: entervalue1b entervalue2b entervalue3b addvaluesb 10%values
total total total total total
My form has many more rows and columns. At first glace when I type in values everything seems correct but i can spot 2 problems so far. when I go back and change a value sometimes the calculation doesn't refresh. And 2 if I skip a field it adds really weird. ex: 10 + 10 + 10 + blank + 10 = 3010
I have been reading the forms and noticed I needed to make sure the calulation order was correct. I set the calculation order like this: row1 left to right then row2 left to right then left to right on the totals. I am still experiencing problems. Any ideas?
var a = this.getField("E1").value;
var b = this.getField("E2").value;
var c = this.getField("E3").value;
var d = this.getField("E4").value;
var e = this.getField("E5").value;
var f = this.getField("E6").value;
var g = this.getField("E7").value;
var h = this.getField("E8").value;
var i = this.getField("E9").value;
var j = this.getField("E10").value;
var k = this.getField("E11").value;
var l = this.getField("E12").value;
var m = this.getField("E13").value;
var n = this.getField("E14").value;
var o = this.getField("E15").value;
var p = this.getField("E16").value;
var q = this.getField("E17").value;
var r = this.getField("E18").value;
var s = this.getField("E19").value;
var t = this.getField("E20").value;
var u = this.getField("E21").value;
var v = this.getField("E22").value;
event.value = a + b + c + d + e + f + g + h + i + j + k + l + m + n + o + p + q + r + s + t + u + v;
if (event.value==0)
event.target.display=display.hidden
else event.target.display=display.visibleand another::
var h = this.getField("H5").value;
event.value = h * .10;
if (event.value==0)
event.target.display=display.hidden
else event.target.display=display.visible