These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Can't make form field calculate properly

Forum Index > Forms: Acrobat > Can't make form field calculate properly
2011-09-26 14:08:13
jfelt
Registered: Sep 26 2011
Posts: 3
Answered

I'm creating an order form, and having trouble making the fields calculate properly.
I will try to explain the form as best I can.
We are selling 10 different products.
I need to tabulate the following:
Total # of cartons sold (odd fields 1-19). This tabulates correctly.
Total # of items being sold (odd # fields 1-19 each x # of items/carton).
I also need total Product cost (even# fields 2 - 20). This total product cost field acts especially strange - it is always off, UNTIL I add any $ amount of shipping... then it self-corrects.
 
I have uploaded a sample of the form, if that helps:
www.printproofing.com/jfelt_order
 
Thank you

My Product Information:
Acrobat Pro 8.1.2, Macintosh
Top
2011-09-26 15:59:59
#1
George_Johnson
Expert
Registered: Jul 6 2008
Posts: 1875
The field calculation order is incorrect. Note that this is different from the tab order. Just set it to what makes sense for your form.
Top
2011-09-27 01:07:21
#2
try67
Expert
Registered: Oct 30 2008
Posts: 2398
To do it, go to Forms - Edit Fields - Edit Field Calculation Order...

- AcrobatUsers Community Expert - Contact me personally at try6767 [at] gmail [dot] com
Check out my custom-made scripts website: http://try67.blogspot.com

Top
2011-09-27 05:49:04
#3
jfelt
Registered: Sep 26 2011
Posts: 3
Thanks for the input ... unfortunately, when I set the field calc. order (and click OK), it reverts back to the previous order immediately.

My # for Total Items remains non-existent, and the Total Product cost continues to have the same error.

As for the total product cost, it seems that the second item a customer might choose, be it a calendar, card, or other product, won't calculate. However the Total product cost is always off by $25 or $50 dollars, depending if the number of cartons chosen is 1 or 2. I know this is "clear as mud"... I'm having a difficult time explaining the problems.

If it makes it any easier for anyone, the order form can be accessed at www.printproofing.com/jfelt_order

Again, I really appreciate the help!

Top
2011-09-27 05:52:23
#4
try67
Expert
Registered: Oct 30 2008
Posts: 2398
Accepted Answer
Could you share the file somewhere? If you want, you can email it to me directly and I'll have a look at it.

- AcrobatUsers Community Expert - Contact me personally at try6767 [at] gmail [dot] com
Check out my custom-made scripts website: http://try67.blogspot.com

Top
2011-09-27 06:03:38
#5
jfelt
Registered: Sep 26 2011
Posts: 3
Thanks ... I'll send it right away.
Top