Skip navigation
Jellevant
Currently Being Moderated

pdf form calculation not calculating

Jul 6, 2011 4:55 PM

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.

 

 
Replies
  • George Johnson
    11,661 posts
    Aug 11, 2002
    Currently Being Moderated
    Jul 6, 2011 11:24 PM   in reply to Jellevant

    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.

     
    |
    Mark as:
  • Currently Being Moderated
    Jul 6, 2011 11:34 PM   in reply to Jellevant

    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

     
    |
    Mark as:
  • Currently Being Moderated
    Jul 7, 2011 2:59 AM   in reply to Jellevant

    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

     
    |
    Mark as:
  • Currently Being Moderated
    Jul 7, 2011 9:52 AM   in reply to Jellevant

    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

     
    |
    Mark as:
  • George Johnson
    11,661 posts
    Aug 11, 2002
    Currently Being Moderated
    Jul 7, 2011 10:11 AM   in reply to Jellevant

    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.

     
    |
    Mark as:
  • George Johnson
    11,661 posts
    Aug 11, 2002
    Currently Being Moderated
    Jul 7, 2011 10:57 AM   in reply to Jellevant

    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.

     
    |
    Mark as:
  • Currently Being Moderated
    Jul 7, 2011 2:12 PM   in reply to Jellevant

    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

     
    |
    Mark as:
  • Currently Being Moderated
    Jul 7, 2011 3:15 PM   in reply to enomail

    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.

     
    |
    Mark as:
  • Currently Being Moderated
    Jul 7, 2011 4:52 PM   in reply to Jellevant

    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.

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points