Using LiveCycle to create a form containing a table. This table has 3 columns with 15 check boxes in each column.
Below these 15 rows are 3 more check boxes that have calculated values. In each row of the table only one of the check boxes can be checked at a time.
Based on the majority of choices in a certain column, the corresponding calculated check box should be checked. (If the most choices are made in column 1, then the 1st calculated check box must be checked, etc...)
Ex. of table: (Bold represents calculated)
[ ] CheckBox66
[ ] CheckBox67
[ ] CheckBox68
Here's the code I've come up with so far but it doesn't work right whatsoever, although when I used it just for 2 columns it did work. (just added the part about the third column with the "or" statements)
Here's an example using only two rows and three columns. The rawValues are 0 and 1 for each checkbox. I've set it so that if column 1 has more checkboxes, then Col1 gets checked. Similarly, the col2 or 3 boxes get checked if their columns are the highest populated. I didn't include the possibility of having multiple checkboxes marked if there are two columns that have the same number of boxes checked. (You could do that by just changing > to >= in the conditions.)