Condition shows true even when the calculated field is blank

  • Profile Image
    Asked on June 04, 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?


  • Profile Image
    Answered on June 04, 2015 at 01: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.

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

  • Profile Image
    Answered on June 04, 2015 at 01: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.

  • Profile Image
    Answered on June 04, 2015 at 03:09 PM

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

    What I did is I specify the rules more.


    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.

  • Profile Image
    Answered on June 04, 2015 at 03:27 PM

    Yes, that fixed it! Thank you!