What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
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.
Field calculation shown on screen is correct, but the number saved in database and print form is wrongAsked by sdhxcs on August 21, 2014 at 10:59 PM
The form has been working flawlessly for months, but just from about two to three weeks ago, the total tuition calculation for over one student cannot be saved in database. The number is always for one student.
Here's the test case:
I'm sorry for the trouble caused to you.
I did check your form's calculation widget and found that you are actually dividing the calculated value with field "Office Use Student 2". Please check the screenshot below:
When the form is loaded the value of the "Office Use Student 2" is "0" and that is the reason it is not being added and that it the reason it always shows the value for one student.
To solve this problem, you need to actually check the condition you have added to insert value in your hidden field. Please check the screenshot below:
I believe the above condition is actually causing the issue and it always inserts "0" in the hidden field. Updating the above condition should solve your issue.
Hope this helps.
Do get back to us if you have any questions.
We've been using this form since April and had not had this issue until several weeks ago. On the screen if we select 2 students the calculation is correct. However once the form is submitted, the hidden field becomes 0.
I did check your form's "Revision History" and found that you have made several updates to your form conditions which is related to "How many students need to register?"
Please take and look at your form's revision history and then you can revert back to a version where the conditions are working as expected. The following guide should help you: https://www.jotform.com/blog/95-Introducing-Form-Revisions-Never-Lose-Your-Work-Again-
Upon taking a closer look at your form, I found it to be a very small issue. The issue is being caused because of the "0" you have added in the hidden "Form Calculation" formula. Removing the "0" from form calculation formula will solve your issue. Please check the screenshot below on how to remove the "0":
I have already removed this "0" from the form calculation formula and your form seems to work as expected now.
Please take a look at your form and get back to us if the issue persists.