I'm working to create a form that will eventually have a several hundred fields with roughly two hundred calculations based on those fields. This form spans 8 pages. However, I can't even get the first page 100 fields and 37 calculations to work correctly.
Page one has 36 lines of fields. Each line with a price field, a quantity field, and a total $ amount field. The total amount field is the product of the price field and the quantity field. Simple enough.
Next is a field that totals up all of the line-items into a grand total for that page. This grand total field is the first of the issues. It will not calculate correctly. Despite having all of the fields selected to generate the correct total, those field specifications don't make it out to the interactive form. I have to re-specify the fields used to calculate the total once the form is open in Acrobat.
After specifying the fields again in Acrobat, it generates a total, but it doesn't calculate it correctly, and this is where it gets really messy.
It seems that the final four fields this grand total field is getting data from screw everything up - despite being set up to correctly generate their own individual totals. Entering data into the fields yields a correct line-item total, but that total doesn't correctly roll up into the grand total field. It seems that sometimes the grand total field is based on the data entered in one of the QTY fields as opposed to pulling from the Total $ amount for that line-item. It's a MESS.
Utilizing the script available from IDExtras was supposed to make this easier and avoid the need to do all of this in PDF. However, after spending nearly 6 hours on this ONE page, I'm beginning to feel otherwise. I'd upload the resulting PDF, but the forum won't let me attach a PDF.