The LOWER() function converts all the letters in a string to lowercase.
Text function name :
LOWER()
Syntax
LOWER(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 lowercase. |
Example
LOWER("HELLO WORLD")Result: "hello world"
Notes
Only alphabetic characters are converted to lowercase.
Return type
The function returns a lowercase 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.