The LOWER() function converts all the letters of a string to lowercase. It returns a lowercase text string.
The output format of the result is configured in the output field options of the formula editor: see Formula column.
Syntax
LOWER(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 lowercase
"HELLO WORLD" becomes "hello world".
LOWER("HELLO WORLD")
Only alphabetic characters are converted to lowercase.
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
UPPER()
Converts all the letters of a string to uppercase.
Or continue with
Formula glossary
All available operators and functions, sorted by category.