LINKTOFILTEREDVIEW()

Constructed deep link to filtered view

Returns a deep link (App value) to a filtered view to display the rows matched by the filter expression.

Sample usage

LINKTOFILTEREDVIEW("Orders", ([Customer ID] = [_THISROW].[ID])) returns a deep link to the Orders view that includes only those rows with a Customer ID column value that matches this row's ID column value.

LINKTOFILTEREDVIEW("Customers", TRUE) returns a deep link to the Customers view that includes all rows of the table.

Syntax

LINKTOFILTEREDVIEW(view, filter)

  • view - Any textual type. Must be the name of an existing view.
  • filter  - A valid expression for filtering (as with FILTER()) the table attached to the view named by view.

Notes

LINKTOFILTEREDVIEW() cannot be used to navigate to another app.

See also

App column type (deep link)

LINKTOAPP()

LINKTOFORM()

LINKTOPARENTVIEW()

LINKTOROW()

LINKTOVIEW()

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

true
Search
Clear search
Close search
Google apps
Main menu
1499159125272366750
true
Search Help Center
true
true
true
false
false