Part of Understanding the Calc Editor. This category covers calculations that return a whole array rather than a single value, and it is the shortest of the categories.
Expressions that summarize an array, meaning totals, counts and averages across every row, return a number or a boolean rather than an array, so they are filed under Decimal and Integer or Boolean instead. Arrays, lists and Data Tables explains that split, and separates an array from a list control and from a Data Table.
A list is not an array
The Calc Editor also uses list to mean a flat sequence of text values, which is a different value kind from an array. Expressions that operate on that kind of list, such as Join-List-Of-Strings, are filed under String.
Expression reference
Expression | What it does |
|---|---|
Field | A reference to an array field. |
From-Data-Source | Populates an array from a data source. This is the mechanism behind pulling Data Table rows into an array rendered as a list; see Pull Data from Data Table into Form List. |
Group-By-Unique-Set | A reference to an array field, grouped by a unique set of values. |
If | Evaluates a boolean to decide which array result to use. |
Integration-Data | An array sourced from integration data. |
Switch-On-Integer | Selects one of a group of array values by matching an integer. |
Switch-On-String | Selects one of a group of array values by matching a string. |
Unset | An explicitly unset array. |