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.
Condition Calculation Value is incorrectAsked by SmartwaystoCanada on October 02, 2015 at 08:39 PM
I have tried to follow your instruction and disable the function under adaptability as a test to see how the calculations will perform but the problem is that I am seeing that the form is giving more than 10 points under adaptability. I have assigned points of a maximum of 10 points for adaptability section on my form. I don't want to give more than 10 points in total under adaptability as this is the government regulations.
Please check the following video
I hope to hear from you a fix soon
I hope to hear from you very soon as I do have people who are completing my form and getting wrong calculations therefore, I am losing business in this case. Also, I don't want to take out the form from my website since it is essential to have it.
I am sorry for the delay. I was just reviewing your for. It seems that you were able to solve this issue by creating an additional condition.
If you still have issues or have questions, please do not hesitate contacting us. We will be glad to help.
Iook at the original post of this question. Issue still exists
I do the exact same steps on your video using your form but it showed correct total which is 10 and not 20.
I presume this is now resolve. Kindly check and test your form again.
Thanks for your follow up. I still didn't get a fix for my issue. It seems that you guys are not checking the original post of this question. This question has been created by one of your team.
This is the original post: http://www.jotform.com/answers/674283
I have been instructed by Brios to disable the condition under adaptability because it creates conflicts with "Clear on being hidden" feature. Both features are important to make the form function correctly.
I look forward to hearing from you very soon.
Al, yes, you should disable your conditions that are trying to update the Form Calculation field, as conditions and calculations will conflict on which value should be in the field - the value that is calculated by the calculation, or the value inserted by the condition.
This is the form that I'm looking at now: http://www.jotformpro.com/form/31396652729969
In the form, I see that there are still conditions for updating a field set on a form calculation, which creates a conflict. Please first disable these conditions, as shown in the image below:
Now that there is no longer a conflict on this calculation field, lets focus on what you are trying to achieve. You want this field to output its calculation, but if the calculated number exceeds 10, you want it to output 10 instead. In other words, you want number 10 to be the maximum in this field.
This can easily be achieved by simply adding a mathematical function inside the form calculation field. I have used the min() math function, which will always output the minimum of the two numbers - either number 10, or the calculated number, whichever is smaller.
Please refer to the images below for visual guidance on how to add this math function in your calculation field:
So we have added the min() function at the front of the calculation. Now this is important. We should add number 10 just after the opening bracket of the min function, and remove the closing bracket that is behind the comma, so that this calculations starts as min(10,(havingAn175...
Then, we must place that closing bracket ) that we have removed from the beginning, to the very bottom / end of the entire calculation. Here are the images of what it must look like with the changes:
After setting up the min functions instead of the calculations to limit the maximum number to 10, this is how the results looked when performing the same steps that were shown in your video:
Please let us know how it goes. I would also like to thank you for providing such helpful videos of the issue that you are experiencing, as it makes it very easy for us to replicate the issue that you are describing, and it helps us provide you with proper solutions. :)
Please do let us know if you need further assistance, or if you hit any snags while setting this up, and we will be happy to help.
Thanks for your detailed reply.
Am I able to get a cloned form so to avoid any mistakes?
Thanks very much for your help