Convert text to lowercase
I have two fields - Text1 and Text2. Text1 is set to capitalize whatever is entered into it with the following custom validation script: event.value = event.value.toUpperCase();
Text2 is set to copy into it whatever is entered into Text1 with the following custom calculation script: getField("Text2").value = getField("Text1").valueAsString;
I am looking for custom validation script that will convert Text2 to capitalize only the first letter of each word that is entered in Text1. For example, if "OHIO" is entered into Text1, I would like Text2 to show "Ohio". If "NEW JERSEY" is entered into Text1, I would like Text2 to show "New Jersey".
Thanks.
