Related Links
To capitalize the first letter of each word
This function converts the first character of each word in a text into a capital letter. This can be handy to correct entered data that should always begin with a capital letter, for example, the first and last name of a person.
In Trigger after update, you could add the function to automatically correct the entered data. The correction will only be applied where needed (i. e. the first character of a word in the text is with a lower letter).






capitalize('Last name')
Result: Chamani (with the field “Last name” = “chamani”)
capitalize("Sam chamani")
Result: Sam Chamani
'Last name' := capitalize('Last name')
Result: Dacosta (with "Last name" = "dacosta") for example added in the Trigger after update in the field editor of the text field "Last name".

See also

lower, which returns a string in lower case.
upper, which returns a string in the upper case.
Last modified 2mo ago
Export as PDF
Copy link