Function: lower()
Usage
lower(<Text>) : Text
The lower function is used to return a text copy, converted to lowercase.
Examples
upper("ABC") => "abc"
The lower() function is most commonly used for value formatting. For example, if the @Company value is ACME LLC, you can use the remove function to format the value as follows:
upper(@Company) => "acme llc"
The lower() function is also commonly used for case insensitive comparisons within if() functions.
For example, the @City value might be “New York” or “new York”. By using the lower() function, you can convert any user input to lowercase, as shown below:
if(contains(lower(@City), "new york"), "From New York", "From outside New York"))
Learn more about how you can get started using the Formula Field.