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.


  • Profile Image

    Condition Calculation Value is incorrect

    Asked 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

    https://www.smartwaystocanada.com/issue-maximum-points.mov

    I hope to hear from you a fix soon

  • Profile Image

    Answered by SmartwaystoCanada on October 03, 2015 at 04:14 AM

    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.

     

  • Profile Image

    Answered by victor on October 03, 2015 at 03:25 PM

    Hi,

    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.

    Regards

  • Profile Image

    Answered by SmartwaystoCanada on October 03, 2015 at 04:13 PM

    Hi Victor

    Iook at the original post of this question. Issue still exists

     

     

     

     

  • Profile Image
    JotForm Support

    Answered by EltonCris on October 04, 2015 at 04:32 AM

    @SmartwaystoCanada

    I do the exact same steps on your video using your form but it showed correct total which is 10 and not 20.

    Video: https://shots.jotform.com/elton/Screencast_16-28_04-10-2015.mp4

    I presume this is now resolve. Kindly check and test your form again.

    Thanks!

  • Profile Image

    Answered by SmartwaystoCanada on October 04, 2015 at 05:12 AM

    Dear Elton,

    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

  • Profile Image
    JotForm Support

    Answered by Boris on October 04, 2015 at 07:52 AM

    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.

  • Profile Image

    Answered by SmartwaystoCanada on October 04, 2015 at 09:49 AM

    Thanks for your detailed reply.

    Am I able to get a cloned form so to avoid any mistakes?

    Thanks very much for your help

    Al

  • Profile Image
    JotForm Support

    Answered by Boris on October 04, 2015 at 11:10 AM

    Certainly, I apologize for not including a cloned version with the applied fix in my previous post.

    Here it is: https://secure.jotformpro.com/form/52763434220954

    You can clone it to your own account by following this guide: How to Clone an Existing Form from a URL.

    I hope this helps.