# FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF\_ROWS(), and SELECT()

**URL:** <https://discuss.google.dev/t/faq-filter-lookup-maxrow-minrow-ref-rows-and-select/76515>\
**Category:** Tips & Tricks\
**Tags:** databases, expressions\
**Created:** [May 11, 2020, 5:20pm UTC](https://discuss.google.dev/t/faq-filter-lookup-maxrow-minrow-ref-rows-and-select/76515 "2020-05-11T17:20:18Z")\
**Posts on this page:** 1\
**Showing post:** 15

<div class="post-metadata">

**Author:** ![Steve](https://d3byx8b92xw3lq.cloudfront.net/user_avatar/discuss.google.dev/steve/32/117807_2.png) [@Steve](https://discuss.google.dev/u/Steve)\
**Post date:** [May 18, 2020, 1:04pm UTC](https://discuss.google.dev/t/faq-filter-lookup-maxrow-minrow-ref-rows-and-select/76515/15 "2020-05-18T13:04:48Z")

</div>

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

#### Is this a new row?

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

```

or:

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

```

#### Does this row already exist?

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

```

or:

```auto
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()](https://help.appsheet.com/en/articles/2357308-filter)_, _[IN()](https://help.appsheet.com/en/articles/2357277-in)_, _[ISBLANK()](https://help.appsheet.com/en/articles/2357266-isblank)_, _[ISNOTBLANK()](https://help.appsheet.com/en/articles/2357267-isnotblank)_, _[List from Table-Column Reference](https://help.appsheet.com/en/articles/4575739-list-from-table-column-reference)_, _[NOT()](https://help.appsheet.com/en/articles/2357287-not)_

---

_[View the full topic](https://discuss.google.dev/t/faq-filter-lookup-maxrow-minrow-ref-rows-and-select/76515)._
