Why does Calculation don't update in Edit Mode

  • Solusign
    Asked on April 25, 2024 at 2:45 PM

    We use this form to calculate quote for our clients

    But we want to go back to the submission to update the entries in order to adjust the quote

    The calculations don't work in the 'edit submission mode'

    https://www.loom.com/share/6ae417c67802487e847efbf503795fe1?sid=c86a52cd-50ce-4019-bcb1-8686c747497c



  • Kenneth JotForm Support
    Replied on April 25, 2024 at 5:18 PM

    Hi Sofian,

    Thanks for reaching out to Jotform Support. I’m sorry that this is happening. I’ll need a bit of time to look into this. I’ll get back to you as soon as I can.

  • Kenneth JotForm Support
    Replied on April 26, 2024 at 6:00 PM

    Hi Solusign,

    Thanks for reaching out to Jotform Support. We’re sorry you're having difficulties with this. ​​I cloned your form and had the same issue, so I created a ticket and escalated this to our Developer team.

    Although we don't know exactly when the issue will be fixed, we’ll circle back to this thread when we have an update.

    Thanks for your patience and understanding, we appreciate it.

  • Erwin Support Team Lead
    Replied on April 29, 2024 at 4:12 AM

    Hi Solusign,

    Thanks for reaching out to Jotform Support. In Edit mode, values are not cleared. This behavior is intended in order not to lose any value.

    If you want to trigger the condition again, please clear the value of the target field.

    Why does Calculation dont update in Edit Mode Image 1 Screenshot 20

    Let us know if you have any questions.

  • Solusign
    Replied on May 1, 2024 at 5:33 AM

    I don't understand what you mean by clear values of intended fields, how does this apply to our use case?

  • Kris Ann JotForm Support
    Replied on May 1, 2024 at 6:33 AM

    Hi Solusign,

    Thanks for getting back to us. As what my colleague mentioned above, It is the expected behavior when editing the submission entry. You will need to clear the existing value of the target field in order to trigger the calculation and update the total. For the Total Number of Fields, the target field is the Multiplier field. Check out the screencast below to see my results:

    Why does Calculation dont update in Edit Mode Image 1 Screenshot 20

    Give it a try and let us know if you have any other questions.

  • Solusign
    Replied on May 1, 2024 at 6:54 AM

    I just tried and it doesn't work:
    https://share.descript.com/view/3K8re3237Md

  • Raymond JotForm Support
    Replied on May 1, 2024 at 7:11 AM

    Hi Sofian,

    Thanks for getting back to us. Some automation, including Calculations with Conditional Logic, will not work in Edit mode to ensure that as the form owner, you'll be free to make changes to a submission as needed. In my example form below, I havee a condition that adds "20" when the Yes option is selected.

    Why does Calculation dont update in Edit Mode Image 1 Screenshot 50

    When editing the submission, selecting No, will not automatically clear the field like so:

    Why does Calculation dont update in Edit Mode Image 2 Screenshot 61

    A workaround to this is to create another condition that makes your desired calculation when the related option is selected. In my case, it would be the condition below:

    Why does Calculation dont update in Edit Mode Image 3 Screenshot 72

    Now, when I edit the form and make changes to them, the desired result will come up according to the condition created.

    Why does Calculation dont update in Edit Mode Image 4 Screenshot 83

    Feel free to clone and test this form on your end.

    Give it a try and let us know if you need any help.

 
Your Answer