1 Reply Latest reply on Dec 13, 2010 8:12 AM by philmodjunk

    Conditionally set a field to be visible (or hidden)

    user13642

      Title

      Conditionally set a field to be visible (or hidden)

      Post

      Can I conditionally set a field to be hidden or displayedbasedonthevalueofanotherfield?  For example on a form with two fields, A and B, if field A's value = 'XXX' then display Field B, else hide field B.  Field A comes from a drop down listwhichhd.

        • 1. Re: Conditionally set a field to be visible (or hidden)
          philmodjunk

          Option 1: If the field does not have any border that must also be hidden, use a conditional format to change the field's text color to match that of the background or set the text size to extremely large. This hides the content of the field.

          Option 2: If you need to hide a field with a border so that even the border is not visible, you need to use a "visibility trick". One way is to use a portal to a related record. By changing the value used in a portal filter expression or in the portal's relationship the contents of the portal can seem to appear and disappear. You can make the outline of the portal transparent so that it is not apparent that the field is inside a portal.

          Option 3: Another visibility trick is to place the field on the tab of an invisible tab control. (Set tab control's properties to match layout background.) A script trigger then uses Go To Object to select the appropriate tab to hide/reveal the field. This requires assigning an object name to each tab.