Expand my Community achievements bar.

General Question about Computations within Table Cells

Avatar

Level 4

A general question on the efficiency of coding in a form.

I have a page in a complex form that has 33 static rows (that size will not change). The fifth column of the table is dependent upon a radio group selection. If the radio group value is 1, then do computation in this cell. If radio group value is 2, 3, or 4,  do another computation in that cell. I have the formcalc code written do that computation and was about to copy the formula to all 32 other rows in the table when i hesitated.

Is there a better, more efficient way to handle this task? Is this a situation where some type of Formcalc loop be a better way (all other computations in the table are in Formcalc)? I have not dealt with this topic in many, many years and do not know the right path to follow.

Advice from the programmers here would be helpful. Just copy the formula or do more advanced programming? Thanks in advance.

0 Replies