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].[Customer 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 Customer 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?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false
false