The UPPER() function converts all the letters in a string to uppercase. It is useful for standardizing text.
Text function name:
UPPER()
Syntax
UPPER(text)ℹ Calling function parameters in TimeTonic:
- $field_name = field (link, linked table column, number, selection, formula, text...).
- "free text" = free text to be added between quotation marks.
- do not use quotation marks for numbers.
Parameters
| Parameter | Description |
|---|---|
text |
Text to convert to uppercase. |
Example
UPPER("lorem ipsum")Result: "LOREM IPSUM"
Notes
Only alphabetic letters are converted; numbers and special characters remain unchanged.
Return type
The function returns a text string.
The output type format of the result can be configured in the output field options of the formula editor. For more details, see Output format options in the Formula column article.
Best practice
To ensure reliable comparisons (SWITCH, IF, COUNTIF), it is recommended to force the case of values with UPPER() or LOWER(), especially when the data comes from user input or APIs.