Condition Calculation Value is incorrect

  • Profile Image
    SmartwaystoCanada
    Asked 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
    SmartwaystoCanada
    Answered 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
    victor
    Answered 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
    SmartwaystoCanada
    Answered on October 03, 2015 at 04:13 PM

    Hi Victor

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

     

     

     

     

  • Profile Image
    EltonCris
    Answered 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
    SmartwaystoCanada
    Answered 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
    Boris
    Answered 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
    SmartwaystoCanada
    Answered 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
    Boris
    Answered 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.