LINKTOFILTEREDVIEW()

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()