13 Replies Latest reply on Jun 10, 2012 8:08 AM by gkaiseril

    Help with custom calculation script and auto tab

    BeardedLady Level 1

      I have put together a two page order form in Acrobat, based on an InDesign form exported as a PDF and populated it with fields for 30 items that can be ordered.  Each item that can be ordered has a Color, Size, Quantity, Unit Price and Item Total (the last two are read only) field.  For the Item Total, I have used "the value is the product of Quantity.x, Unit Price.x") calculation and for the SubTotal, "value is the sum of Item Total."

       

      My first problem is that the subtotal field does not reflect the correct amount until I tab out of a Quantity field and enter data further down the order form.  I would like for the date to be reflected in the subtotal as soon as it's entered.  I have read of a custom keystroke script (auto tab the cursor to subsequent fields after form recipient types data in a field) that might take care of this problem, but a) I can't find the script and b) that would require Custom formatting for a field that needs to be Number formatted.

       

      My second problem is coming up with a custom calculation script for the variable shipping rates, based on the subtotal:

      up to $25 - $6; $25.01 - $75 = $11.50; $75.01.00 - $125.00 = $15.00

      $125.01 - $200.00 =$20.00; $200.01- $300 = $25.00; $300.01 - $400 = $30.00

      $401.01- $600 = $50

       

      I would like to have two radio buttons, one to select Pickup (no fee) and the other to select Priority Mail shipping - the radio button that selects Priority Mail shipping will show the shipping amount in a separate text box, named shipping fee.

       

      I also need a calculation that adds 5% to the SubTotal plus ShippingFee, if people are paying by credit card.  I was hoping a simple field calculation would take care of that.  (SubTotal + ShippingFee) * .05)

       

      Any help or suggestions would be appreciated.  If I need to upload the form, I can do that, although I need to know how to do that.