FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT()

AppSheet Tips & Tricks
,
15

Is this a new row?/Does this row already exist?

Is this a new row?

NOT(IN([_ROWNUMBER], My Table[_ROWNUMBER]))

or:

ISBLANK(
  FILTER(
    "My Table",
    ([_ROWNUMBER] = [_THISROW].[_ROWNUMBER])
  )
)

Does this row already exist?

IN([_ROWNUMBER], My Table[_ROWNUMBER])

or:

ISNOTBLANK(
  FILTER(
    "My Table",
    ([_ROWNUMBER] = [_THISROW].[_ROWNUMBER])
  )
)

In the above, replace My Table with the name of the table about which you’re inquiring.

When modifying rows, such as in forms or with actions, expressions act on a temporary copy of the row. Only after the form is saved or action completed is the new row data saved to the table. Until saved, the data in the table remains as it was when the form was opened or the action started. Expressions that explicitly reference tables, such as table-column references and SELECT() and its derivatives, can be used to access the table directly, bypassing any pending changes in the temporary copy of the row.

See also: FILTER(), IN(), ISBLANK(), ISNOTBLANK(), List from Table-Column Reference, NOT()

12 Likes