Using NL(Filter)

The following formula will retrieve a list of records from the Orders table:

=NL(“Rows”,”Orders”)

NL(Filter) can be used to filter on a field that is not on the Orders table (such as the "Subtotal" field on the “Order Subtotals” table) as follows:

=NL("Rows","Orders",,"OrderID",NL("Filter","Order Subtotals","OrderID","Subtotal",">100"))

There is one NL function inside another. The inner NL function returns an array of the values of the OrderID field where the value of the Subtotal field is greater than 100. Jet can use this array as a filter for the Orders table.

Note:  The NL(Filter) function can also be placed in its own separate cell and referenced from the NL(Rows) function.