Conditions: List of values in "does not contain" type matching showing the field when not expected to

  • Profile Image
    Asked on June 02, 2016 at 11:05 AM

    I have a form with roughly 250 codes that can be inputed into a textbox.  I have the following condition setup to hide a page break if the code inputed is not in the values list.


    If award code

    does not contain

    (Value) 3012.5689, 4398.8766, 3467.8600, etc...

    then hide page break


    If I insert 30 which is not in the values it still shows the page break?

  • Profile Image
    Answered on June 02, 2016 at 12:47 PM

    I see this is about form 61513283396963, named LMHS - Awards. On this form, there are two show/hide conditions, which I would recommend setting up a little differently to prevent conflicts between them:

    Each hide condition implies a show action when the condition is not met, which means your existing hide rules implicitly mean this:

    IF Award Codes contains xxx, show Page Break
    IF Award Codes is filled, show Page Break

    As you can see, they imply that the field should be shown regardless of what has been entered, so the two conditions conflict a little bit. It would be better to use just one show condition, and set it only as:

    IF Award Codes contains xxx, show Page Break:

    This will implicitly hide the page break even when the Award Codes field is empty, because it is not equal to the set list of values. You can either disable or delete the second, unnecessary rule.

    Now, on to the issue why the Page Break still shows when you enter number 30, this is because in the list of your values, there is a zero:

    This means that your list of values will be matched whenever a zero is entered, which means any number containing a zero like 30, 50, 709, etc. If this was not intended, please remove number zero from that list of accepted values. It is just after 6130.9783, and just before number 7010.0363.

    If you need further assistance, please let us know.