Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
That was the issue. Thanks so much!
Find more inspiration, events, and resources on the new Adobe Community
Explore Now