Column calculation

Question

I've created a form from a Word document that has 3 separate columns with 19 rows each that I want to calculate independently. However, when I put a number in any box it changes all the boxes in that column to the same number. Column A has a bunch of 1's for example. I can't actually enter the correct value to get a total. Each column has a different field name Column A - CO, Column B - CA, Column C - CB. I set the field calculation order for my total fields to be at the bottom of each column. Any suggestions or ideas what I might be doing incorrectly?

Thanks.

gkaiseril · Answer

To have fields work independently the form fields need unique names. It sounds like all the fields in a column all have the same name.

I would make a row of uniquely named cells. Then select the entire row, right mouse click the highlighted row, select the create multiple copies, specify the number of rows down to generate, and click OK. You will get a series of form fields with the column name a "." and a number value of 0 through the N -1 rows. This known as hierarchical named fields and make coding and selecting much easier.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded