Examples

LINKTOFILTEREDVIEW("Orders", ([Customer ID] = [_THISROW].[Customer ID])) gives 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) gives a deep link to the Customers view that includes all rows of the table.

Syntax

LINKTOFILTEREDVIEW( view-name , filter-expr )

Arguments

  • view-name - A literal textual value that names an existing view within the app. Enclose the name in quotes to avoid misinterpretation, especially if it contains non-alphanumeric characters

  • filter-expr - an expression for filtering (as with FILTER()) the table attached to the view named by view-name.

Description

LINKTOFILTEREDVIEW() constructs a deep link to the view named by view-name to display the rows matching the expression in filter-expr.

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

Return Value

An App value: the constructed deep link.

See Also

App Column Type (Deep Link), LINKTOAPP(), LINKTOFORM(), LINKTOPARENTVIEW(), LINKTOROW(), LINKTOVIEW()

Did this answer your question?