# How to set up Form Calculation for Donation Form

• loiswstern
Asked on February 20, 2016 at 06: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

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
Answered on February 20, 2016 at 05:03 PM

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.

Here's how you can create it:

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

Thank you.

• loiswstern
Answered on February 21, 2016 at 03: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!
...
• BDAVID
Answered on February 21, 2016 at 04: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
Answered on February 22, 2016 at 08:46 AM
Mike the form prototype form you made, below, was very helpful. Thank you.
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
Answered on February 22, 2016 at 09: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
Answered on February 22, 2016 at 11:28 AM

Here is a link to Mike's form:

https://form.jotform.com/60506747364964

How to Clone an Existing Form from a URL

Then, you will be able to adjust the form:

1) Update the calculations.

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

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

• loiswstern
Answered on February 22, 2016 at 02: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
Answered on February 22, 2016 at 04: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.

Thank you.

• loiswstern
Answered on February 22, 2016 at 04: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.
+-
*/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.
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
Answered on February 22, 2016 at 06: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).

• loiswstern
Answered on February 22, 2016 at 07: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?
...
• BDAVID
Answered on February 22, 2016 at 08: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
Answered 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
Answered on February 23, 2016 at 01:11 PM

#1

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

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.

#3

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

Thank you.

• loiswstern
Answered on February 23, 2016 at 08: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
...