How to show/hide fields on the form if another field's value is "less than" or "greater than" a certain value

  • Profile Image
    Timothyink
    Asked on September 02, 2017 at 03:52 PM

    I'm trying to hide and show fields but only when a number is in a range.  Say "is less than 24" and "is more than 36."  Is there a way to do that.  Or Show X field when the numbers are in a range between 23 and 37.  I see that I could manually set up a conditional formatting for every number 1-23 and that would eliminate the small numbers for my purpose but it wouldn't solve my problem as elegantly as I would like.

     

    Any thoughts?

     

    Tim

  • Profile Image
    Mike_G
    Answered on September 02, 2017 at 04:17 PM

    Yes, that would be possible if the field being checked is a Number field or a Form Calculation widget.

    The "less than" and "greater than" state in Conditions only appear for those two fields.

    Just a suggestion, you can set a 'less than" and a "greater than" state within the same condition.

    I hope this helps. If you have other questions or concerns, please feel free to contact us again anytime.