Syntax

MINROW(table-name, column-name[, select-expr])

Description

MINROW() identifies a row in the table named by table-name that contains the minimum value for the column named by column-name.

Both table-name and column-name must be a literal Text values; they cannot be expressions.

Commonly, column-name is a name that has a special meaning to AppSheet internals, such as date, n, t, text, time, and others. Whenever AppSheet encounters such a name as literal, unquoted text, it may produce an error indicating the expression "could not be parsed due to exception: #VALUE!". To avoid or fix this problem, enclose the problematic column text in quotes.

select-expr is an optional expression that returns a Yes/No value (TRUE or FALSE) indicating whether a row should be considered in the operation. select-expr is evaluated once for each row in the table named by table-name.

Return Value

A Ref value: The key of a row in the table named by table-name that contains the minimum value found in the column named by column-name.

Note: it is possible the minimum value may occur in multiple rows, in which case one of those rows is chosen arbitrarily to be returned.

Did this answer your question?