Condition shows true even when the calculated field is blank

  • coigis
    Asked on June 4, 2015 at 11:25 AM

    I have a field called Status that will check whether certain conditions are met. If Adj Amp is >= IscVal, the Status will be Ok. IscVal is a calculated field with input from a field at top of the form, called Isc.

    I checked IscVal to wait for input before including the field in calculation. However, with blank value, the Status will still show Ok. How do I fix this?

    Condition shows true even when the calculated field is blank Image 1 Screenshot 30

     

    Condition shows true even when the calculated field is blank Image 2 Screenshot 41

  • Jeanette JotForm Support
    Replied on June 4, 2015 at 1:21 PM

    You need to be more specific in the way this should work.

    Which field value should the field IscVal to wait for? As the form is set up currently, if I choose 10 in the Size AWG field, it will populate the rest of the fields, but the IscVal field does not show up, because you have hidden it on purpose. and I don't even see it in the list of conditions.

    Condition shows true even when the calculated field is blank Image 1 Screenshot 20

    We'll await for more details and we will gladly assist you.

  • coigis
    Replied on June 4, 2015 at 1:31 PM

    If you look at the clone form, I made the IscVal visible. If IscVal is blank, Status shouldn't show any value.

    IscVal is a calculated field based on Isc(STC). You should be able to see the conditions 44 & 45.

    Condition shows true even when the calculated field is blank Image 1 Screenshot 20

  • Charlie
    Replied on June 4, 2015 at 3:09 PM

    Could you check this cloned form that I have: http://form.jotformpro.com/form/51545712114952. See if that works as you expected. You can explore it by cloning it also. 

    What I did is I specify the rules more.

    Condition shows true even when the calculated field is blank Image 1 Screenshot 20

     

    If "Isc (STC)" is blank, IscVal will also be blank, and my rules states that it will only insert "Ok" or "Invalid" when IscVal has a value on it.

    I hope that helps.

    Thank you.

  • coigis
    Replied on June 4, 2015 at 3:27 PM

    Yes, that fixed it! Thank you!