On my starting form, I have a table with a field that's hidden with CSS at the end of each row. The field contains the following formula to calculate a value:
=IF(INDEX(GLDropdown.Program,ROW()) = "101 - Unrestricted",
IF(INDEX(GLDropdown.SubProgram,ROW()) = "510 - General",
IF(INDEX(GLDropdown.GLNum,ROW())="6245 - Bank fees & service charges ",0,
IF(INDEX(GLDropdown.GLNum,ROW())="2006 - Accounts payable clearing ",0,1)),0),0)
Sometimes, this works perfectly, and sometimes it doesn't. I can't figure out why. When I test various combinations in the source fields, the field with the formula always seems to return an accurate value. However, when users submit the form, the values that should be 0 are sometimes 1, making the form travel down an incorrect path.
In some cases, none of the numbers entered on the form match the numbers being checked in the formula, so 0 should be returned. In other instances, 2006 or 6245 are used in combination with 101 and 510, which should result in 0 being returned.
No javascript is running that would modify that field.
How can I determine when and why this is happening?