Part of Understanding the Calc Editor. This category covers text: building strings, turning other types into text, and reading string-typed data. It holds 23 expressions.
Turning another type into text
Expression | What it does |
|---|---|
Format-Decimal | Formats a decimal as text, with options. |
Format-Integer | Formats an integer as text, with options. |
Format-Date | Formats a date as text using a format string you supply. |
Format-Duration | Formats a duration as text using a format string you supply. |
Format-User | Formats a user as text. |
These are how a calculated number reaches a label or a message. Anywhere you are assembling a sentence that contains a value, the value has to pass through one of these first.
Transforming text
Expression | What it does |
|---|---|
Join-Array-Strings | Joins strings from an array into one string. |
Join-List-Of-Strings | Joins a list of strings into one string. |
Uppercase | Converts a string to upper case. |
Lowercase | Converts a string to lower case. |
Regexp-Replace-String | Replaces what a regular expression matches. |
The two Join expressions are not interchangeable
Join-Array-Strings reads an array field on the form. Join-List-Of-Strings reads a flat list of strings inside an expression. Those are different value kinds, so check which shape your data is in before choosing. Arrays, lists and Data Tables sets out the difference.
People, groups and the form itself
Expression | What it does |
|---|---|
Current-User-Email | The email address of the person currently signed in. |
Email-For-User | The email address of a user you specify. |
Name-For-Group-Id | The name of a group, given its ID. |
Form-Assignments | Formats the form's assigned users and groups into a string. |
Form-Id | The ID of the form. |
Form-Assignments takes options for the separator and for how each user and group is formatted. For expressions that return a user or a group rather than text, see Calc Editor: User, Userid, Groupid, and Location Expressions.
Values, fields and branching
Expression | What it does |
|---|---|
Constant | A fixed piece of text. |
Field | A reference to a string field. |
If | Evaluates a boolean to decide which result to use. |
If-Set | Uses one value if a field has a value, and another if it does not. |
Integration-Data | A string sourced from integration data. |
Switch-On-Integer | Selects one of a group of values by matching an integer. |
Switch-On-String | Selects one of a group of values by matching a string. |
Unset | An explicitly unset, empty string. |