Show_If column constraint may be used to show or hide a column value according to a condition.
Show_If is commonly used to:
- Hide columns that aren't intended for forms.
- Show only non-zero values in a column of numeric values.
- Hide sensitive values, such as email addresses, from most users while showing them to administrators.
- Show action buttons in only select views.
New to expressions and formulas? See also Expressions: The Essentials.
The Show_If expression
Show_If column constraint is Yes/No expression: if the expression evaluates as
TRUE, the column value will be shown; if
FALSE, the column value will be hidden.
As in all column constraint expressions, the Show_If expression may refer to the current column value using the column value expression,
[_THIS]. For instance, if the current column is
[Employee Name] and
[_THIS] both refer to the same value.
Scope of Show_If
Show_If column constraint is applied any time the column itself is displayed. The column constraint is not applied to the column value when used in an expression.
Show_If conditions can enabled for only form views or for the entire app. To control this behavior, see the Apply show-if constraints universally setting under UX > Options.