form calculation is not working

  • dexterslaboratory
    Asked on December 2, 2020 at 7:20 AM

    Not sure why but if you will check the form there is a service called Diversified Service, Not sure while adding it does 10 times, For Example for the top package I added the price as $128 but at the checkout, it shows $1280, same goes with the Medium and basic package.

    All other services are perfectly fine, Just facing the problem with this. Kindly update with the solution.

    Link to the form:- https://form.jotform.com/203351514047446

  • Richie JotForm Support
    Replied on December 2, 2020 at 8:26 AM

    The issue seems to be with your result calculation.

    Kindly add an addition function after every field for the calculation to work.

    1606915477 5fc7959578dc6 2 Screenshot 10

    Please give it a try and let us know if the issue still remains.

  • dexterslaboratory
    Replied on December 9, 2020 at 6:21 AM

    Fields are not calculating again, it was yesterday but nothing's working now. Please if you can fix in the form below

    https://form.jotform.com/203351514047446

  • Girish JotForm Support
    Replied on December 9, 2020 at 6:55 AM

    The issue was due to the additional "+" signs in the Results field calculation:

    1607514746 5fd0ba7a09156 0912 5 Screenshot 10

    I have removed them from the calculation widget in your form.

    Please check and let us know.


  • dexterslaboratory
    Replied on December 10, 2020 at 12:44 AM

    Thank you!

  • dexterslaboratory
    Replied on December 12, 2020 at 1:07 AM

    I am unable to understand here

    The Products:- https://gyazo.com/8fad232908188926c3ab24f8e4e80fbd

    Just want to add discounts to only these.

    All the Add ons I have added are already after discounts. But in the total the whole get's discounted

    https://www.jotform.com/build/90491714911457

  • dexterslaboratory
    Replied on December 12, 2020 at 1:13 AM

    I mean that I only want my products to be discounted with the coupon, Add ons are already discounted but in the form it's working wrong, Can you please fix it ASAP

  • Patrick_R
    Replied on December 12, 2020 at 2:29 AM

    Hello! I do see this problem. Please allow me some time to work on this. I'll get back to you shortly with an update.

    Thank you!

  • dexterslaboratory
    Replied on December 12, 2020 at 2:37 AM

    Thanks

  • Patrick_R
    Replied on December 12, 2020 at 3:05 AM

    Hello! I've made some changes to your form's conditions and form calculation fields.

    Here is the form in which I made these changes: https://form.jotform.com/203461003897959

    Please check its working. If it is correctly working, then please clone it into your account and use this instead. Make sure to re-setup the payment widget by using your PayPal email address.

    In case you come across any issues with this form's working, let us know.

    Thank you!

  • dexterslaboratory
    Replied on December 12, 2020 at 3:34 AM

    All good, Buddy

    I cannot clone this form as I have submitted the previous one to various campaigns running, Can you please update the same changes to this form itself;- https://form.jotform.me/90491714911457

  • Patrick_R
    Replied on December 12, 2020 at 4:14 AM

    Hello! I've updated your form with the same changes. Please check your form's working now.

    Also, you can hide the fields "Applicable discount as per used coupon", "Result" and "Totalll" as these are not meant to be user editable.

    In case you come across any issues, let us know.

    Thank you!

  • dexterslaboratory
    Replied on December 12, 2020 at 5:17 AM

    There is still an issue in this form, If you Add products from the Add ons and use coupons, It's getting discounted.

    All the Add ons are already discounted, I do not want to add any discount to them, Just to the products it should do

  • Patrick_R
    Replied on December 12, 2020 at 6:36 AM

    Hello! Please consider the following test case:

    1. Product selected: "Dexter's Secret Ranking Formula 199.99" (as per calculation value, this costs: 207.99).
    2. Selected Add on: "Premium package" (as per calculation value, this costs: 180.00).

    Now if I use the coupon code "LAUNCH"; then, discount of 79.99 is to be applied to the selected product, i.e. "Dexter's Secret Ranking Formula 199.99".

    So, the calculation becomes: (207.99 - 79.99) + 180.00 = 308
    This is what the form is returning as the end value.

    Q) Is this not the correct calculation?
    If no, then please provide the correct calculation; we'll assist you accordingly.

    Thank you!

  • dexterslaboratory
    Replied on December 14, 2020 at 12:23 AM

    Yes, That's the correct calculation but it's not what's actually working


    https://gyazo.com/e4406649731856a3db554b622c5b4b44


    I added Dexter's secret ranking formula + Master Johnny's 40 Blog Posts and after I am applying the coupon it's coming out to be 128$,

    It should be 207.99-79.99+277.99=405.99


    That is the correct calculation. Just need the discount only on the products and Add ons be added as it is

  • dexterslaboratory
    Replied on December 14, 2020 at 12:25 AM

    This form is working perfectly fine:- https://form.jotform.com/203461003897959 i.e the one you made by yourself

  • Richie JotForm Support
    Replied on December 14, 2020 at 3:38 AM

    I have checked your form and it seems you have populated your form calculation widget(Result) using conditions and formulas.

    1607934404 5fd721c41d2f4 3 Screenshot 10

    This creates conflicts.

    I would suggest adding a new field to store your discount value instead on the field Result.

    For my example, I have added a form calculation field and named it Coupon discount.

    1607934606 5fd7228e15d20 4 Screenshot 21

    Also, kindly remove the products - value in your calculation and directly add the discount amount.

    1607935028 5fd724348c7a8 3 Screenshot 32

    Then updated the Totalll field's calculation to result-coupon discount.

    1607934673 5fd722d1468d4 3 Screenshot 43

    Sample screen cast:

    1607934968 5fd723f846575 1 Screenshot 54

    Sample Form:https://form.jotform.com/203481624911957

    Let us know how it goes.

  • dexterslaboratory
    Replied on December 14, 2020 at 3:59 AM

    Bro, It's out of my mind. Please make my form similar to this one:- https://form.jotform.com/203461003897959

    I get confused with all this, Please update everything to my form


  • dexterslaboratory
    Replied on December 14, 2020 at 4:00 AM

    This form is perfect too,:- https://form.jotform.com/203481624911957


    Please update my form too with the same calculations

  • Richie JotForm Support
    Replied on December 14, 2020 at 5:18 AM

    You may clone my form to your account https://form.jotform.com/203481624911957 by following this guide:https://www.jotform.com/help/42-how-to-clone-an-existing-form-from-a-url

    Let us know how it goes.

  • dexterslaboratory
    Replied on December 14, 2020 at 5:33 AM

    Boss, I cannot clone as I have submitted my form to the various campaign we are running, Please update the cloned form calculations to my form :(

  • Kenneth JotForm Support
    Replied on December 14, 2020 at 7:00 AM

    Hi there,

    I have now applied the changes from the form: https://form.jotform.com/203481624911957 to form: https://form.jotform.me/90491714911457

    Can you please confirm if now works as you expect it?

    Awaiting your response.

    Best.

  • dexterslaboratory
    Replied on December 15, 2020 at 12:46 AM

    All, Good now, Thank you for the help.

    Appreciate it.