Need a more complex order form

  • RimshotCreative
    Asked 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.

  • BJoanna
    Replied on April 10, 2017 at 1: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.

    Need a more complex order form Image 1 Screenshot 20

    You will also have assign calculation values and to perform calculation inside of the form.

    How to Assign Calculation Value

    How to Perform Form Calculation Using a Widget

    You will also have to add separate calculation for shipping. Once you calculate the total you can pass it to your payment field.

    How to Pass a Calculation to a Payment Field

    To calculate number of selected items you can use count() Math Function. 

    Form Calculation - Math Function Reference

    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. 

    How to Set up Paypal Along with Other Payment Options

    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. 

  • RimshotCreative
    Replied on April 17, 2017 at 6: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.

  • jonathan
    Replied 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.

    Need a more complex order form Image 1 Screenshot 20

     

    This will allow the payment field to use the integrated Shipping Cost, Coupon Code and as well as Tax option.

    ---

    You can build your items/products price matrix using also Sub Products and Special pricing.

    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.