Changed PayPal amount being reset up on submitting the form

  • Profile Image
    davsun55
    Asked on February 16, 2018 at 07:36 AM

    My form is now working almost perfectly. 

    As you can see, if they select 'Paypal', then the Paypal amount is populated from the deposit field.

    They are able to change the deposit amount, and that then changes the Paypal amount.

    However when the form is submitted, the Paypal amount is recalculated from the original deposit amount.

    How can I stop this recalc happening for Paypal?

    Note that the 'amountPaypal' field will normally be hidden.

    THanks

    David

  • Profile Image
    Kiran
    Answered on February 16, 2018 at 10:06 AM

    The issue seems to be happening due to the calculation field (Deposit (min 20%):) which is calculating again after clicking on Submit button. This is also changing when the other options Cash/Online payment is selected. Please allow me some time to run few tests to enable the user to change the deposit amount to pass to the payment field. I'll get back to you with relevant information as soon as I complete my tests.


    Thank you for your patience.

  • Profile Image
    davsun55
    Answered on February 17, 2018 at 03:53 AM

    Thanks - the form is live now, so any assistance you can give will be gratefully received.

    It seems that any manual change of the deposit amount is thrown away!

    :)

  • Profile Image
    Jed_C
    Answered on February 17, 2018 at 06:52 AM

    I'm also testing your form. We will notify you here once we have an update on what is causing the calculation to reset once submit button is clicked.

    We thank you for your patience in the meantime.

  • Profile Image
    Kiran
    Answered on February 18, 2018 at 10:57 AM

    I was able to find a solution for the issue by entering the percentage of deposit entering manually on a separate field. As of now, it is being allowed to change the already calculated value which is again recalculated to the default calculation. Please make the following changes to the form so that the form calculation should be working fine. 

    1. Add a new Number field to the form above Deposit field enabling the user to enter the Deposit percentage. The default value of this field can be set to 20.

    1518968778Selection_102.png

    2. The existing Calculation field (Deposit min 20%) is used now for displaying the actual amount of the deposit by using a condition. The default calculation formula on the field is now removed.

    1518969124Selection_103.png

    Please see the screencast below with the changes that I made on a cloned version of your JotForm.

    1518968600Peek 2018-02-18 21-08.gif

    Here is the cloned form with the changes above to test it.

    https://form.jotform.com/80483959858983

    Please get back to us if you need any further assistance. We will be happy to help.


  • Profile Image
    davsun55
    Answered on February 18, 2018 at 05:26 PM

    I can see this will work, but in reality a user will generally want to enter a dollar amount rather than a percentage. I am thinking of a slightly different option where the calculated 20% deposit is in a different field and they have to manually enter the deposit amount.

    But again, that's not ideal.

    It seems to hang on this point - can a user ever edit/change a calculated field and NOT have that field automatically recalculated on submit? And is that behaviour the same for calculated widgets as well as a calculated number field?

    Thanks

  • Profile Image
    Kiran
    Answered on February 18, 2018 at 07:49 PM

    can a user ever edit/change a calculated field and NOT have that field automatically recalculated on submit?

    Unfortunately, this is not possible with the form calculation fields.

    but in reality a user will generally want to enter a dollar amount rather than a percentage.

    In this case you may consider adding a radio button instead of a number field to display two options with Min 20% and the other option to enter the amount manually.

    1519001111Selection_104.png

    You may set the following conditions for the radio button field to calculate the percentage when 20% is selected and calculate directly with the amount when other option is selected.

    1519001262Selection_105.png

    Please see the demo form below that can help you with this.

    https://form.jotform.com/80487835458976

    Hope this helps!

  • Profile Image
    davsun55
    Answered on February 18, 2018 at 10:04 PM

    I have implemented a variation based on your suggestions - it's working now. Thanks.

    Could I request a new feature that would avoid this issue?

    So that a user can edit/change a calculated field without having that field automatically recalculated on submit?

  • Profile Image
    Ardian_L
    Answered on February 19, 2018 at 06:05 AM

    In behalf of my colleague you are welcome. I have moved your request to another thread to avoid confusion and I will reply on the other thread. Thank you.