New to expressions and formulas? Try Expressions: The Essentials

A 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.

The Show_If Expression

The Show_If column constraint is a 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, [Employee Name] and [_THIS] both refer to the same value.

Scope of Show_If

The 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.

Did this answer your question?