Server action insert query Titlecase value not working

[cpuser]

Hi,
I have an insert query into a table and the I want to be able to titlecase the firstname and last name as some people enter names all caps, like JOHN. But when I try to do this on the server side but it doesn’t change it to titlecase.

[Teodor]

What’s not working exactly?
In the following article it’s explained how the titlecase formatter works:

Server Data Formatters - Text

Intro Below is a comprehensive list of Text data formatters available in Server Connect, accompanied by explanations outlining the purpose and functionality of each. Text Formatters Convert To Lowercase: Converts the given value to lowercase using UTF-8 encoding. Example: ('Hello World').lowercase() returns 'hello world' Convert To Uppercase: Converts the given value to uppercase using UTF-8 encoding. Example: ('Hello World').uppercase() returns 'HELLO WORLD' Camelize String: Conver…

What you want to do is probably convert everything to lowercase and then apply titlecase.

[cpuser]

It doesn’t change JOHNS to Johns. It simply leaves it as it is entered.

SOLUTION: However, using your suggestion @Teodor to convert everything to lowercase and then apply titlecase worked!!!

Thank you Teodor!