How to set up Form Calculation for Donation Form

  • loiswstern
    Asked on February 20, 2016 at 6:29 AM

    1) I would like to set up calculator on my donation form so that is calculates costs for USA shipping as follows:

    One book $3.75

    Each additional book sent to same address: $.75

     

    2)

    I tried out my Jotform at: tales2inspire.com/?page_id=2907 and got a message:

    "There s a problem with the sellers Pay Pal account" even though I thought I had already integrated the two. 

     

     

  • Mike_G JotForm Support
    Replied on February 20, 2016 at 5:03 PM

    Here's what I understand after reading your concern and checking your form embedded in your website:

    You are selling 5 types of book collection, namely: Emerald Collection, Topaz Collection, Sapphire Collection, Ruby Collection, and Crystal Collection. Each book cost $11.25. The maximum quantity for each book that can be ordered is 5. So if someone orders 5 Emerald Collection that would be $11.25 x 5 without the shipping fee.

    As for the shipping fee, it's going to be $3.75 for one book and each additional book would cost $0.75 a piece.

    So, if someone orders 1 book for each type of book collection, it's going to be, ($11.25 x 5) + 3.75 + (0.75 x4), is that correct?

    I have cloned your form and tried to create your desired computation to it.

    https://form.jotform.com/60506747364964

    I have constructed the computation in a Form Calculation widget and it looks like the one in the image below.

    How to set up Form Calculation for Donation Form Image 1 Screenshot 40

    Here's how you can create it: 

    How to set up Form Calculation for Donation Form Image 2 Screenshot 51

    Then, we need to pass the information from the Form Calculation to the payment tool which is PayPal. You may follow the instruction on this guide, How-to-pass-a-calculation-to-a-payment-field

    How to set up Form Calculation for Donation Form Image 3 Screenshot 62

    As for your other concern, I have moved it to a new thread that you may follow by clicking this link.

    Thank you.

  • loiswstern
    Replied on February 21, 2016 at 3:46 PM
    I have a couple of questions:
    1) Since all my books are priced at $11.25 plus shipping ($4.25 for the first book and $.60 shipping for each additional book ordered on the same form, would it be best for me to add an additional drop down at the end of my form asking customer to give the Total number of books ordered?
    2) Then on the payment wizard i could list one item rather than 5 (total number of Tales2Inspire titles) and maybe that would simplify shipping charges (i.e.$4.25 for the first book and $.60 shipping for each additional book.) Or do you have a different suggestion?
    3) I am so sorry but I am still totally befuddled with setting up the calculator even though I have looked at what you sent and tried to replicate it on my own. Can you help?
    Thanks so much for the hand holding!
    ...
  • David JotForm Support Manager
    Replied on February 21, 2016 at 4:52 PM

    If you only want a drop down, how would you know the amount of copies for each book? The way my colleague has explained in details how to setup the formula to calculate the total, is the best way to achieve what you want.

    You might want to read this guide about how to perform a calculation in a form: http://www.jotform.com/help/259-How-to-perform-calculation-in-the-form 

  • loiswstern
    Replied on February 22, 2016 at 8:46 AM
    Mike the form prototype form you made, below, was very helpful. Thank you.
    Could you please answer the following:
    1) What does the —1 )) at the end of the form mean?
    2) Will I get a total number of books sold of ALL titles at the end of the form? If so, that is perfect. If not, how do I achieve that?
    3) Will the final amount billed the customer via PayPal be calculated as $11.25 times total number of books sold plus shipping charge for 1st book @$4.25 (CHANGED FROM $3.75) plus $.65 (CHANGED FROM $.75) for each additional book? If so, that is perfect. If not, how do I achieve that?
    Again, many thanks for your help. Couldn’t have done this without you!
    Lois
    ...
  • loiswstern
    Replied on February 22, 2016 at 9:46 AM
    I see six calculation fields on my form right now and have a feeling there should be more. Is there a way for me to view the entire form so I can see the the construction blocks and make changes if necessary?
    ...
  • Mike
    Replied on February 22, 2016 at 11:28 AM

    Here is a link to Mike's form:

    https://form.jotform.com/60506747364964

    I would like to suggest cloning that form to your account. Please follow the next guide.

    How to Clone an Existing Form from a URL

    Then, you will be able to adjust the form:

    1) Update the calculations.

    How to set up Form Calculation for Donation Form Image 1 Screenshot 30

    2) Also, make sure to enter your PayPal account email/credentials on the PayPal tool.

    How to set up Form Calculation for Donation Form Image 2 Screenshot 41

    If you need any further assistance, please let us know.

  • loiswstern
    Replied on February 22, 2016 at 2:46 PM
    Thanks. I need guidance with updating the FORM CALCULATIONS, not the actual jotform as I already know how to do that by myself.
    How do I make that the FORM CALCULATIONS box visible to make changes to it, or do I need to rebuild it from scratch?
    Also on the actual jotform, should I first remove the one Calculations field I see at the bottom before building or rebuilding the FORM CALCULATIONS?
    Thanks,
    Lois
    ...
  • Mike
    Replied on February 22, 2016 at 4:23 PM

    It is fine to edit the current calculation field on the form. To open the Calculation Wizard, click on the calculation field to select it and then click on a Magic Wand icon.

    How to set up Form Calculation for Donation Form Image 1 Screenshot 20

    Thank you.

  • loiswstern
    Replied on February 22, 2016 at 4:46 PM
    This does not answer my question. When I click on the Calculate Fields/ magic wand I get a blank screen as below. It does not show me the calculation fields I already established. How can I actually see them to edit them?
    Add, subtract, multiply or divide fields and display them on your form, or use them in form conditions.
    Show Advanced Options
    Add Field
    +-
    */a2

    ()
    ...
    123
    456
    789
    .0
    Back
    Math Functions abs()
    acos()
    asin()
    atan()
    atan2()
    ceil()
    cos()
    exp()
    floor()
    log()
    max()
    min()
    pow()
    random
    round()
    sin()
    sqrt()
    tan()
    Math Properties E
    LN2
    LN10
    LOG2E
    LOG10E
    PI
    SQRT1_2
    SQRT2
    Other Functions
    dateString()
    date()
    nth()
    avg()
    avgNoZero()
    count()
    commaSeparate()
    Options Add field to equation as text by default.
    Read Only.
    Wait for input before including the field in calculation.
    Show empty decimal places.
    Ignore Hidden fields.
    Use commas for decimal point.
    Decimal Places in Numerical Results.
    ...
  • Mike
    Replied on February 22, 2016 at 6:10 PM

    It looks like that you have delete the 'Clone of Clone of DONATE 25% OF BOOK SALE PROCEEDS TO ONE OF THESE CHARITIES.' form with established calculations.

    You can clone Mike's form once again in order to adjust it. Please see the next animation (click to enlarge).

    How to set up Form Calculation for Donation Form Image 1 Screenshot 20

  • loiswstern
    Replied on February 22, 2016 at 7:46 PM
    There is something I am still not getting here. I go to: https://www.jotform.com//?formID=60526525359156 and click on Edit form. It brings me to the cloned jotform. I go down to the bottom to the CALCULATE FIELD and click on the magic wand. But the CALCULATE FIELDS ARE NOT FILLED IN WITH ORANGE, BLUE AND GREEN BLOCKS. The box is totally empty. What am I not understanding here?
    ...
  • David JotForm Support Manager
    Replied on February 22, 2016 at 8:59 PM

    Simply copy Mike_G's form link: http://www.jotformpro.com/form/60506747364964 

    And clone it in your account as explained on this guide: http://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL 

  • loiswstern
    Replied on February 23, 2016 at 11:45 AM
    Hooray! Finally, the calculation form is visible when I click on the magic wand. (Trust me, I did this a zillion times before and saw a blank form until now.)
    Issue 1: I modified Mike’s form calculator a bit for my purposes and would really appreciate it if you would take a look and see if it is correct. (I changed the name of the cloned form to DONATE 20 %.)
    Issue 2: My next issue is with the Pay Pal tool. Apparently I did something incorrectly and need to delete and start over. Here is the message I get: You cannot add more than one payment tool. Please delete the existing one first, but how do I delete it?
    Issue 3: I see two calculation fields at the bottom of my form. Should I delete the bottom one?
    Thank you for all your patience with me!
    Lois
    ...
  • Mike
    Replied on February 23, 2016 at 1:11 PM

    #1

    I have updated a bit the calculation formula on your form to follow the Mike's example.

    How to set up Form Calculation for Donation Form Image 1 Screenshot 30

    The calculation should be correct now.

    #2

    No need to delete the old tool. The PayPal field is already added to your form and called 'My Products', you can select it and click on the Magic Wand icon to open its settings.

    How to set up Form Calculation for Donation Form Image 2 Screenshot 41

    #3

    Yes, this is safe to delete the second calculation field.

    Thank you.

  • loiswstern
    Replied on February 23, 2016 at 8:45 PM
    Thank you for all your patience and help, Mike and others!
    Finally, hooray, I am not getting an error message when I hit SUBMIT on the form.
    BUT, and there always seems to be a BUT, I do NOT get an email with the return info from the form. Instead I get a PayPal bill, just saying one book purchased @$11.25 (even though I had inputted many books on the form), plus shipping. I am guessing this has to do with the Pay Pal field I added. Does that stop the Jotform from sending me the info inputted on the form? If so, I would rather just receive the info from Jotform and send an invoice to the customer.
    Does that sound correct or do you have a better solution?
    Thanks,
    Lois
    ...