Unable to make the condition in my form work

  • Profile Image
    political
    Asked on October 22, 2017 at 03:02 PM

    https://form.jotform.com/42319202042137

    It worked fine before but I changed the number (0.555 and 0.535) to multiply by and now 1,900 and below it does not calculate. I cannot figure out the reason. Please help.

    All other calculations work from my random checking.

    Example: 

    $commaSeparate(Enter Voter Hous0-9*0.535)
    $commaSeparate(Enter Voter Hous0-9*0.555)

  • Profile Image
    Mike_G
    Answered on October 22, 2017 at 04:10 PM

    If this is the condition that you are trying to create (Please see image below) in your form — https://form.jotform.com/42319202042137

    1508702080t15_52_23.png

    I'm afraid that it is not going to work because it creates conflict with the other conditions in the same form. Below are the two conditions I am referring to. (Please see images below)

    Condition #2 in your form is met if the value entered in the "Enter Voter Households" field is between the 1 - 1250 range. The possible numbers in that range are also 1900 and below.

    1508702213t15_55_20.png

    On the other hand, Condition #10 in your form is met if the value entered in the "Enter Voter Households" is between the 1251 - 2500 range. Numbers 1251 - 1900 that belongs to that range are also equal to or less than 1900.

    1508702242t15_55_37.png


    To fix the issue, you need to be more specific about the ranges that you would like to use for the conditions in your form. If you need any further assistance doing so, please let us know and give us more details.

  • Profile Image
    political
    Answered on October 22, 2017 at 05:11 PM

    Ok, but how is it that the other 15 identical conditions work? This condition worked a week ago... I just changed the variable it multiplies by.

  • Profile Image
    jonathan
    Answered on October 22, 2017 at 05:58 PM

    Can you please clarify which specific Condition# was not working on the form https://form.jotform.com/42319202042137

    This way we can specifically check the conditions for any conflict or issue.

    We will wait for your response.

  • Profile Image
    political
    Answered on October 22, 2017 at 09:20 PM

    2 and 10 are not working but all are created the same and the others are working

  • Profile Image
    Nik_C
    Answered on October 23, 2017 at 03:30 AM

    I checked your form and I was able to replicate this issue, the calculations are not showing properly. 

    Please allow me some time to investigate this issue a bit more. I'll get back to you once I'm done.

    Thank you!

  • Profile Image
    Nik_C
    Answered on October 25, 2017 at 02:30 PM

    I'm very sorry for the delay, but my tests were very inconsistent so I couldn't update you before.

    The issue is related to $ sign in the calculation:

    1508956167Screen Shot 2017-10-25 at 8.32

    Once removed the calculation will work properly:

    1508956194Screen Shot 2017-10-25 at 8.32

    You can check my test form as well: https://form.jotform.com/72975356851974

    Please check and let us know how it worked.

    I'm, again, very sorry for the delay.

    Thank you!

  • Profile Image
    political
    Answered on October 25, 2017 at 02:59 PM

    Thank you but question how is it that the other calculations use the $ sign? 

  • Profile Image
    political
    Answered on October 25, 2017 at 03:43 PM
    Amazing. Thank you.

    ...
  • Profile Image
    Mike
    Answered on October 25, 2017 at 05:48 PM

    You may also add the $ sign as a text. Simply click on the $ sign to change its type, or type it from a keyboard.

    Text strings are highlighted in brown, and numbers are highlighted in gray.