Release notes: May 10th - May 11th, 2025

MAP (list, predicate)
This function iterates over each element in a given list, applying a transformation defined by the predicate. During iteration, a special loop variable named $VALUE is made available, representing the current item in the list. For example, this variable can be utilized within the predicate logic to retrieve a field value using an Entity ID.

Example (numeric transformation):
=MAP(LIST(1, 2, 3), $VALUE * 2)
This returns a new list [2, 4, 6].

Example (mapping entity references):
=MAP(LINKEDENTITIES('MyLinkType'), FIELDVALUE('MyField', $VALUE))
This retrieves the value of 'MyField' for each linked entity of type 'MyLinkType'.

FILTER(list, predicate)
This function filters elements in the provided list based on a condition specified in the predicate. Like MAP, the $VALUE variable is available during iteration, allowing evaluation of each element.

Example (filtering values greater than 2):
=FILTER(LIST(1, 2, 3), $VALUE > 2)
This returns [3], as only element 3 satisfies the condition.

DISTINCT(list)
This function returns a new list containing only the unique elements from the input list, eliminating duplicates while preserving the order of first occurrence.

Example (removing duplicates):
=DISTINCT(LIST(1, 1, 1, 1, 1, 2, 3))
This returns [1, 2, 3].