How to add a conditional price based on a calculation?

  • Rucker
    Asked on February 11, 2016 at 9:44 PM

    Hi, I see that an auto-calculation feature was added to your Use Cases document in 2010. Is it available yet? I would like to have a conditional price calculation like the following:

    1. Rug Width (in feet): 8

    2. Rug Length (in feet): 10

    3. Rug Knot Density (in knots per square inch): 30 = $60/ft^2 OR 100 = $80/ft^2

     

    Price = $4,800 (8ft x 10ft x $60/ft^2) if 30 is entered for Knot Density

    OR

    Price = $6,400 (8ft x 10ft x $80/ft^2) if 100 is entered for Knot Density

  • Chriistian Jotform Support
    Replied on February 11, 2016 at 9:50 PM

    You can do calculations in your form using the Form Calculation Widget.

    Please follow the guide below to set up the form calculation.

    1. Add 4 textbox fields that will capture the amount entered.

    How to add a conditional price based on a calculation? Image 1 Screenshot 100

    2. Add the Form Calculation widget, then click on the Wand Icon to open the calculation wizard.

    How to add a conditional price based on a calculation? Image 2 Screenshot 111

    3. On the calculation wizard, add the required fields to perform the calculation. (rugDensity * rugLength * initalPrice)

    Follow the guide below to add the fields. Then click Finish when done.

    How to add a conditional price based on a calculation? Image 3 Screenshot 122

    4. Now you can now add the conditions required for the price. Here's a guide about smart conditions that can help: Smart Forms Using Conditional Logic

    How to add a conditional price based on a calculation? Image 4 Screenshot 133

    5. Add the following conditions to your form using the Update/Calculate Field.

    How to add a conditional price based on a calculation? Image 5 Screenshot 144

    Condition 1: If Rug Knot Density is Equal to 30, output 60 to Initial Price.

    How to add a conditional price based on a calculation? Image 6 Screenshot 155

    Condition 2: If Rug Knot Density is Equal to 100, output 80 to Initial Price.

    How to add a conditional price based on a calculation? Image 7 Screenshot 166

    Click the Save button to save the conditions.

    6. The conditions should look like this.

    How to add a conditional price based on a calculation? Image 8 Screenshot 177

     

    Once that is set, your form is ready for calculation. Here's a gif of the form performing the calculation.

    How to add a conditional price based on a calculation? Image 9 Screenshot 188

     

    Here's the link to the sample form: https://form.jotform.com/60418190598967 You can clone it to your account by following this guide: How to Clone an Existing Form from a URL

     

    Do let us know if you need further assistance.