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.
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.
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