Write an expression to get a value from a specific column and row
Column value expressions return the value of a specific column in a row. The row itself does not need to be specified; it's usually implicit in the context of the expression.
- Name any column using square brackets around the exact column name:
[Column]. - When used in a column constraint (
Editable_If,Required_If,Show_If, orValid_If), you can use[_THIS]to refer to the value of the current column of the current row. - If the current row is not implicit from the context of the expression, it must be explicitly specified using a dereference expressions.
- To use columns from other tables in the app that aren't connected using references, specify the table name and column value using the following syntax:
Table[Column]
New to expressions and formulas? See Expressions: The Essentials.
Common use cases
- In a virtual column:
CONCATENATE([FirstName], " ", [LastName]) - In a slice filter condition:
[Status] = "Complete" -
In a Valid_If column constraint:
[_THIS] > 25