- RimshotCreativeAsked on April 10, 2017 at 11:35 AM
My client needs a more complex order form and I think it can be done in jotform, but I'm not certain how. Also she is using Stripe for cc processing.
The form I've been working on is https://form.jotform.com/70136720772150
What she needs now is for each item that can be purchased to be able to have individual prices. Then the form needs to total bot the cost and the number of items orders, and then add the appropriate shipping amount to the order based on the number of items purchased. To make things more complicated, she wants to offer her clients the option of sending in a check/p.o by mail or using a credit card for payment.
Any insights you might have would be greatly appreciated.Page URL:
- JotForm SupportBJoannaAnswered on April 10, 2017 at 01:04 PM
You will have to create your product form using basic fields, to be able to calculate the total cost and the number of items orders.
You will also have assign calculation values and to perform calculation inside of the form.
You will also have to add separate calculation for shipping. Once you calculate the total you can pass it to your payment field.
To calculate number of selected items you can use count() Math Function.
Considering that your form needs to have three payment options (Credit Card , Check (Mail) and Purchase Order (Mail))you will have to create a form that can accept all options. Inside of this guide it is explain how to do it with Paypal, but same can be done with Stripe.
Here is my demo form, with basic calculation: https://form.jotformpro.com/70995257922973
Feel free to test it and clone it.
Hope this will help. Let us know if you need further assistance.
- RimshotCreativeAnswered on April 17, 2017 at 06:41 PM
Thanks for your response. It got me well along the way. However, I don't think that the pricing model that you've described will accomplish what I need. If I choose user defined price then I don't have any other options to add shipping costs. It gets a little more complicated in that the shipping cost changes depending on how many products get shipped.
So for example, she has a product that sells for $15 and another that sells for $5, the total price calculation field spits out $20. The total quantity spits out 2. Then I need to calculate shipping. If the customer just bought 1 item, the shipping would be $8.40. But if they bought 2 items, the shipping would be $8.80. If they bought 15 it would be $20. It doesn't matter which items are purchased to calculate shipping, it only matters on the quantity. Shipping is dependant on the total number of items being shipped.
Is there a way to make this work? If I'm not clear on anything, please let me know.
- JotForm SupportjonathanAnswered on April 17, 2017 at 10:14 PM
Since the Shipping Cost was actually an important piece in the payment, it is best to have it integrated in the Payment field instead. This means the custom defined payment calculation (custom pricing model) will not work for this case.
My suggestion is to just use the Payment field with the Payment type of Sell Products.
This will allow the payment field to use the integrated Shipping Cost, Coupon Code and as well as Tax option.
I suggest you try test this also. You will be able to understand how the features work once you used it on your form.
Don't hesitate to let us know if you encounter any difficulty building the items/products list.