How to calculate total price based on different product selection?

  • Profile Image
    rsgrafica
    Asked on December 15, 2016 at 04:42 AM

    Hi, i have a printing site and I would need a form that allows me to choose the type of product, paper and quantity.

    according to these characteristics, the form will have to calculate the price of the product.

    Just as on this website:

    https://www.pixartprinting.co.uk/digital-litho-printing/printing-business-cards/

     

    Thank you

     

     

     

  • Profile Image
    Chriistian
    Answered on December 15, 2016 at 05:15 AM

    Thanks for contacting us.

    If you would like to create a form based from your requirements, I would suggest you to create an Order Form. In this guide you can see the different types of Order Form: Order Form Types

    Here's a guide on Setting Up Your First Order Form.

    You can also check our available Order Form Templates in this link: https://www.jotform.com/form-templates/category/order-form.

    Do let us know if you need further assistance.
    Regards

     

     

  • Profile Image
    rsgrafica
    Answered on December 15, 2016 at 05:45 AM

    thanks for the answer but i need a database that calculate the price of the every single product.

    for example:

    select: 1000 or 2000 or 5000 

    select: type paper1 / type paper 2 / type paper 3

    select: delivery fast / delivery slow

    total price $100

    each product has a different price and needs a database that calculates the final price depending on the selected image.  

    because if I select 5000 cards will have a different price from 5000 flyers

  • Profile Image
    emily
    Answered on December 15, 2016 at 06:22 AM

    Hi,

    Unfortunately, we do not offer that feature. However, you can achieve your request by using Conditional Logic. 

    1. I created a simple demonstration with 2 Drop Down fields and a Form Calculation widget.

     

     

    There are three options for both first Drop Down menu; 100, 200 and 500 and second Drop Down menu; paper1, paper2 and paper3.

    2. Kindly click on Conditions.

     

    3. Create New Condition and select Update/Calculate Field.

    4. For each option, you need to create different condition. In the below screenshots, 

    For the first option;

    If the number of cards equal to 100 AND paper type is paper1 calculate its price.

    If the number of cards equal to 100 AND paper type is paper2 calculate its price.

    If the number of cards equal to 100 AND paper type is paper3 calculate its price.

    You need to apply these conditions to 200 and 500 as well.

    if the number of cards equal to 200 AND paper type is paper1 calculate its price.

    If the number of cards equal to 200 AND paper type is paper2 calculate its price.

    If the number of cards equal to 200 AND paper type is paper3 calculate its price.

     

     

    If the number of cards equal to 100 AND paper type is paper1 calculate its price.

    If the number of cards equal to 100 AND paper type is paper2 calculate its price.

    If the number of cards equal to 100 AND paper type is paper3 calculate its price.

    You can add more fields and add more conditions according to those fields.

    I hope this helps. Please have a look at the user guides below. 

    https://widgets.jotform.com/widget/calculation 

    https://www.jotform.com/help/57-Smart-Forms-Using-Conditional-Logic 

    https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget 

    Thank you.

  • Profile Image
    emily
    Answered on December 16, 2016 at 09:34 AM

    Hi again,

    Here is the video of the form I created in the previous post.

    I also created a demonstration including PayPal integration. Please have a look at the screenshots below.

    1. Add PayPal integration to the form. 

    2. Fill out the credentials needed for the integration and click on Create New Product.

     

    3. I created 2 products named PaperType1 and PaperType2. 

    4. To add quantity for your product, click on Add Quantity button. You will be able to select the number of the items you want to purchase.

    5. Click on Add Option button of the product. Enter the price for the paper type + delivery type as shown in the screenshot below.

    6. Kindly do these steps for the second product. 

    Enter the price for the paper type 2 + delivery type.

     

    Please have a look at the video below to see the resulting form.

    If you need further guidance, please let us know.

    Thank you.