Text To Proper Case
Is there a way I can make text entered into a text box convert to Proper Case before saving? This sounds like it should be a very easy thing to do, but I searched and didn't find anything about it....
Forum Discussion
This is a bit gnarly, but works...
var text fieldOne = [input]; var text fieldOneWordOne = Part($fieldOne,1," "); var text fieldOneWordTwo = Part($fieldOne,2," "); var text fieldOneWordThree = Part($fieldOne,3," "); var text fieldOneWordFour = Part($fieldOne,4," "); var text fieldOneWordFive = Part($fieldOne,5," "); var text output = List(" ", Upper(Left($fieldOneWordOne,1)) & Lower(NotLeft($fieldOneWordOne,1)), Upper(Left($fieldOneWordTwo,1)) & Lower(NotLeft($fieldOneWordTwo,1)), Upper(Left($fieldOneWordThree,1)) & Lower(NotLeft($fieldOneWordThree,1)), Upper(Left($fieldOneWordFour,1)) & Lower(NotLeft($fieldOneWordFour,1)), Upper(Left($fieldOneWordFive,1)) & Lower(NotLeft($fieldOneWordFive,1))); $output
This will account for up to 5 words, you can adjust accordingly.
Dan, thanks for this, it will work for my needs!
User voice votes used as well, as I'm sure I'm not the only one who could use this as a QuickBase function.
User voice votes used as well, as I'm sure I'm not the only one who could use this as a QuickBase function.
