The UPPER() function converts all the letters of a string to uppercase and returns a text string. It is handy for standardising text values.
The output format of the result is configured in the output field options of the formula editor: see Formula column.
Syntax
UPPER(texte)
How to reference parameters in TimeTonic: $field_name for a field (link, linked-table column, number, selection, formula, text); "free text" in quotes; no quotes for numbers.
Parameters
Example
Convert a text to uppercase
"lorem ipsum" becomes "LOREM IPSUM".
UPPER("lorem ipsum")
Only alphabetic letters are converted; digits and special characters remain unchanged.
Best practice: to make comparisons more reliable (SWITCH, IF, COUNTIF), it is recommended to normalise the case of values with UPPER() or LOWER(), especially when the data comes from user input or APIs.
Best practice: to make comparisons more reliable (SWITCH, IF, COUNTIF), it is recommended to normalise the case of values with UPPER() or LOWER(), especially when the data comes from user input or APIs.
Go further
LOWER()
Converts all the letters of a string to lowercase.
Or continue with
Formula glossary
All available operators and functions, sorted by category.