The FIRST function returns the first value found in a given List.

This function takes only one parameter, which is of type List. Then each value in the List can be of a specific type. That is, if working with a List of type Text, values will be of type Text.


FIRST([list_of_values])-> first_item


list_of_values (required, type: List)

A list containing a number of items. These items can be of any type and do not need to be the same type as each other.

Return Value

first_item (type: varies according to the item type)

The first value of the List.


The following example searches for the first item in a List of type Text.

FIRST(["Banana", "Apple", "Orange"]) -> Banana