JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
When I edit a form submission, the calculation fields are not saving correctly.Asked by djccraig on January 16, 2015 at 04:13 PM
The calculation fields on my form are working for original submissions to the form. But when I go to edit a submission, and I enter a discount code "admin$20" (in a custom discount code box that I created using conditional logic which reduces one of the calculation fields by $20) the total will look correct on that page, but then when I click forward to the "Preview before submit" page, it reverts to the original total.
Submissions JotForm uploads preview
I checked your jotform http://www.jotform.us/form/43388156445159
and I can see the calculation to be correct while still in Edit Mode of a submission.
I just could not test it with an actual submission of the edited submission because it will take effect in actual on the existing submission.
BUT have you tried completing the submission after the edition? Perhaps in the actual submission of edit, the correct calculation will take effect on the result.
We will wait for your updated response.
Thank you for your response. Unfortunately, the correct calculation still does not take effect when I edit the edition.If you want to test this, you can do so with this submission: 296685706741997318Please advise.
I checked the mentioned submission and I see that the entered discount code is earlybird$ instead of the admin$20.
From what I see in your conditions, the above discount code should work the same way as the admin$20 code. Is that correct? If so, the values I see when I view the submission on edit mode, are correct. Are you looking different values when you open the submission?
Could you please provide a screenshot of what you see? This will allow us to better understand your issue and how to reproduce it.
We'll wait for your response.
Both coupon codes have the same effect.
The issue is that when we edit the form to add the coupon code after the fact, the calculation will work properly, but when we save the edit, it doesn't take effect.
This is what I was trying to depict with the orginal screenshoot:
Part 1 of the screenshot depicts the calculation before the code is added.
Part 2 of the screenshot depicts the calculation working correctly after the code is added.
Part 3 of the screenshot shows that when you advance to the "preview before submit" page, the calculation is incorrect, despite the presence of the code.
And then when you save the edit, the total calculation is still incorrect and does not reflect what was shown in Part 2 of the screenshot.
Does that make sense?
Thank you for providing us much details. I'm trying to find the submission ID 296685706741997318 but can't seem to find it.
Another concern that i have, have you tried "submitting" the form? After the "Preview Before Submit" have you tried proceeding and making a full submission during edit? I've also cleared your form's cache just to make sure.
I'll go ahead and see if I can find the test submission and try editing it in my end. But please do try the suggested above.
Thanks for your response. I'm not sure why that ID isn't pulling the submission up. If you search for "Vlady Gavrilov", it will come up.
As I mentioned above, I did save/submit the edit, but it still saved the calculation incorrectly. I just attempted this again, and it's still not working.
Thanks for your help!
I was able to recreate the issue on your jotform 43388156445159, but had to search for it using "Vlady Gavrilov" since I was not able to find it using the ID 296685706741997318 even though it was correct.
Now in regards to the issue that you have, I can recreate it.
I have tried several times to edit the jotform to confirm this and some times it would apply the discount after load so it would show $79 USD, but other times it was going to $99 USD instead.
The issue seems to be with the payment processing tool, as it has set the price and did not want to change it, resetting the value set in Form Calculation as soon as you go to its page, but I might be wrong.
I will however raise this to our developers to inspect and they will get back to you as soon as they have any updates in regards to the issue.
Any progress on resolving this issue?
Unfortunately there is no update yet about this issue. Our developers are still investigating it. We will informed you via this thread once an update is available.
Thank you for your patience.
It's been several weeks since I submitted this request, and I wanted to check in to see if there is any progress toward resolving this issue.
This is a very basic form calculation condition that we need to work correctly in order to make Jotform work for us.
Thanks for your help!
Unfortunately, we don't have any updates regarding this issue yet.
We apologize for the delay in providing a response, but our development team is still working on a fix for it.
We appreciate your patience and we'll notify you as soon as a fix is released.
Thank you Raul! Could you give me an idea of how long this might take? Are we talking days, weeks, months?
Unfortunately, we cannot provide an ETA since our developers work on the issues depending on the priority that has been assigned to it.
The one reported here has a high priority which means that it should be addressed soon, but I cannot tell you if this will be a matter of days or weeks or even months.
Hopefully, a fix for this issue is released soon.