Why my calculation is not working properly?

  • fklinkert
    Asked on June 16, 2017 at 12:24 PM

    Hi guys!

    I want to create an instant price quote form for my customers. We are selling perfume lines. Right now the form looks like this:

     

    1. Choose flacon size (7 options)

    2. Choose special add-on (6 options)

    3. Choose packaging (3 options)

    4. Specify order quantity (20 options)

    5. Select shipping location (8 options)

     

    The calculation behind the form should to be like this:

    (("1.PRICE OF FLACON" + "2.SPECIAL ADD-ON" + "3.PACKAGING TYPE") * "4.ORDER QUANTITY") + 5.SHIPPING COST = TOTAL PRICE

    I tried for hours but now I'm a little bit helpless in finding the right way to setup a proper calculation with the right formula. Is it even possible to create a calculation like this with JotForm?

    I really hope you can support me!!!

    Thanks

    Fred

  • Nik_C
    Replied on June 16, 2017 at 1:11 PM

    The issue is that you're using Image picker widget in calculations and that just can not work since that widget doesn't have calculation values.

    Why my calculation is not working properly? Image 1 Screenshot 40

    In order to make this work, you will have to add an additional text box (you can make it hidden in the form) that will hold the price for those image picker options, for example:

    Why my calculation is not working properly? Image 2 Screenshot 51

    Now, we need to create a condition that will insert a value in that text field when certain Image checkbox is selected, for example:

    Why my calculation is not working properly? Image 3 Screenshot 62

    So you use the name of the choice in conditions (i.e. Basic folding box), and 10 is the actual price for that choice. You have to do conditions separately for each choice in image picker.

    Finally, in form calculations widget you will include newly added text fields (in my example called "type of box calculation"). 

    Since you have only two Image picker widgets, you need to do that for those two fields.

    If you need any further assistance please let us know.

    Thank you!