- loiswsternAsked 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
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.
- JotForm SupportMike_GAnswered on February 20, 2016 at 05: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.
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
As for your other concern, I have moved it to a new thread that you may follow by clicking this link.
- loiswsternAnswered on February 21, 2016 at 03:46 PMI 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!
- JotForm SupportBDAVIDAnswered 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
- loiswsternAnswered on February 22, 2016 at 08:46 AMMike 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!
- loiswsternAnswered on February 22, 2016 at 09:46 AMI 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?
- JotForm SupportMikeAnswered on February 22, 2016 at 11:28 AM
Here is a link to Mike's form:
I would like to suggest cloning that form to your account. Please follow the next guide.
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.
- loiswsternAnswered on February 22, 2016 at 02:46 PMThanks. 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?
- JotForm SupportMikeAnswered 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.
- loiswsternAnswered on February 22, 2016 at 04:46 PMThis 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
Math Functions abs()
Math Properties E
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.
- JotForm SupportMikeAnswered 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).
- loiswsternAnswered on February 22, 2016 at 07:46 PMThere 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?
- JotForm SupportBDAVIDAnswered 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
- loiswsternAnswered on February 23, 2016 at 11:45 AMHooray! 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!
- JotForm SupportMikeAnswered on February 23, 2016 at 01:11 PM
I have updated a bit the calculation formula on your form to follow the Mike's example.
The calculation should be correct now.
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.
Yes, this is safe to delete the second calculation field.
- loiswsternAnswered on February 23, 2016 at 08:45 PMThank 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?