Column value expressions

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, or Valid_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

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

Search
Clear search
Close search
Google apps
Main menu
3416606812597312924
true
Search Help Center
true
true
true