14 Replies Latest reply: Jul 7, 2011 4:32 PM by Jellevant RSS

    pdf form calculation not calculating

    Jellevant Community Member

      I created a form yesterday - with the extensive help of a forum member - and thought it was fine until I checked it online.  I have a column of items with quantity x price = total, and a grand total at the end that adds the individual totals. 

       

      Problem:  when I test it, it never picks up the last item entered (whichever one it is) and so the grand total is always wrong.  This obviously renders the form useless!

       

      The form is at drronaldlevant.com/new/orderform.pdf.  Can anyone find the bug? 

       

      BTW I used Acrobat 9 pro on a macbook.  Tested on mac and pcs, and friends' macs and pcs.  Same issue everywhere.

       

       

        • 1. Re: pdf form calculation not calculating
          George_Johnson ACP/MVPs

          The problem is the field calculation order is incorrect. To correct it, go into forms editing mode (Forms > Add or Edit Fields) and then select "Forms > Edit Fields > Set Field Calculation Order" and set the correct order.

          • 2. Re: pdf form calculation not calculating
            enomail Community Member

            Hi Jellevant

             

                I looked at your form here on my iMac with Acrobat 9 and it seems to total up correctly.

                Could it be  that when you enter the last quantity field you did not hit tab or click somewhere else on the page? The result doesn't show up until you hit tab or click somewhere.

                I redid some of the form to hide the zeros. Go here and see if it works.

            http://nixmailmac.com/forum.pdf

             

            Ron

            • 3. Re: pdf form calculation not calculating
              Jellevant Community Member

              Unfortunately, it's not the order that is the problem.  I need to use the Extend Usage option so that users with pcs can save the completed form.  Once I do that, calculations AND other links cease to work. 

              • 4. Re: pdf form calculation not calculating
                Jellevant Community Member

                Thanks for doing that.  My first attempt to use the form you made was on Chrome on my mac.  It did not work, so I didn't even try it on the pc.  The individual totals do change when the quantities are entered but the final total stays at 0.  The only button that worked was the Reset.  I couldn't save to computer, couldn't click through to paypal.  These are necessary functions for the intended users who will not likely own acrobat and most probably be on pcs.

                 

                What I've found is that testing correctly in Acrobat does not mean it will work once it's online.

                 

                The latest iteration is now drronaldlevant.com/new/orderform_kfmX.pdf if you have any other ideas.

                • 5. Re: pdf form calculation not calculating
                  alancard

                  I wonder if this is related to the problem I'm having (See Recent Form Calculation Problems here: http://forums.adobe.com/thread/872931?tstart=0).

                   

                  If the calculations seem to work at first and then break once you've saved and re-opened the form, you might be battling the same bug I am, in which case no amount of attention to how your calculations are set up is going to fix anything.

                   

                  For the past week, every newly-saved form I make (even just as extended-features-enabled copies of existing forms that work perfectly well) fails to calculate once I close it and re-open it.  I assume it's the result of some software update or another, but the truth is I have no idea.  --And apparently nobody else does, since no one responded to my post.-- But if you're suffering from the same problem, then your calculation set-up may be perfectly fine.  I've replicated the problem on a number of very simple test forms, as well.  They work fine... until I hit save, close them, and re-open them.  Then they're just inert.

                   

                  Good luck!

                   

                  Alan

                  • 6. Re: pdf form calculation not calculating
                    enomail Community Member

                    Hi Jellevant

                     

                        I took your latest form and gave it the extended features for Adobe Reader.

                        I still can't find any problem with the totals.

                        Here is the link.

                    http://www.nixmailmac.com/forumkfmx.pdf

                        The only related issue I know of is that my Safari was in 64 bit mode and it would not read a calculation form I have online.  I think someone here said to go to Get Info on the Safari icon and open in 32 bit mode and it works fine now.

                     

                    Ron

                    • 7. Re: pdf form calculation not calculating
                      Jellevant Community Member

                      Well, that did ring a bell.  The pc I test on is a 64 bit machine.  However, I just tried your version of the form on my mac in Chrome and the calculations do not work.  Entering a quantity updates the individual total but the final total stays at 0.

                      • 8. Re: pdf form calculation not calculating
                        George_Johnson ACP/MVPs

                        Chrome's built-in PDF viewer has limited support for PDF forms, and does not support JavaScript, which is what Acrobat uses behind the scenes when you use one of the built-in calculation options.

                        • 9. Re: pdf form calculation not calculating
                          Jellevant Community Member

                          So that mean's it will never work on Chrome?  I Think I'll just have to give up and do an html form.  I tried downloading it from Chrome to see if I could fill it in and save but the calculations were gone.  As of something I read yesterday, Chrome now has more than a 20% share of the browser-users.

                           

                          Pity.  Acrobat makes such pretty forms!

                          • 10. Re: pdf form calculation not calculating
                            George_Johnson ACP/MVPs

                            The user has the choice of using Chrome's built-in PDF viewer or configuring it so the PDF opens in the browser using Acrobat/Reader, if it's also installed. I don't know if Chrome's PDF viewer will be improved to be more compliant with the PDF standard, but there's hope.

                            • 11. Re: pdf form calculation not calculating
                              enomail Community Member

                              Hi Jellevant

                               

                              If it was my form I would put a note at the top;

                              This form does not work with Chrome.

                              Please use FireFox, Safari, InternetExplorer or Adobe reader.

                               

                              Ron

                              • 12. Re: pdf form calculation not calculating
                                Phillip M Jones Community Member

                                On FireFox, SeaMonkey, and any other Gecko Based Browsers. There is no support on the Mac OSX platform. Never has since X.2. (first Usable version on Mac) . Did in Classic. The Only Browser that does work on Mac is the PDF Browser Plugin and it has no support for forms.

                                 

                                So Safari is your only choice or any Webkit Browsers. It’s a Personal and intended snub to gecko Based Browsers.

                                • 13. Re: pdf form calculation not calculating
                                  Jellevant Community Member

                                  But it's not my form.  It's for a client whose clients are not web savvy and probably don't even know what browser they are using!  If it won't work out of the box, I won't offer it.  Meanwhile, I learned a LOT!

                                  • 14. Re: pdf form calculation not calculating
                                    Phillip M Jones Community Member

                                    Well if you do either be sure they use Safari on Mac Or PC if they want to file out the form on line or IE for PC.

                                    Or, Have them fill out , save  then email back. You can  do that for up to 500 instances.