Text To Proper Case

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • Acknowledged
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. I did see where functions for Upper and Lower can be applied, but not Proper Case.
Photo of Printmark

Printmark

  • 436 Points 250 badge 2x thumb

Posted 4 months ago

  • 0
  • 1
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 12,058 Points 10k badge 2x thumb
Hi Printmark,

I can confirm that currently Quick Base doesn't have a formula function for Proper Case. If you think this would be a useful feature for your users I would suggest adding it to our User Voice page. User Voice is a tool our Product Managers use to take in feedback from our users on future features and enhancements. The Quick Base User voice can most easily be accessed from the My Apps page in Quick Base by clicking on the orange Feedback tab that appears on the right of the page or at http://quickbase.uservoice.com by signing in with your Quick Base credentials. If you do make a User Voice post to add Proper Case as a formula function I would encourage you to include a link to that suggestion here in this thread so that the community members here can add their vote as well. Thank you for your time Printmark. 
Photo of Dan

Dan

  • 1,558 Points 1k badge 2x thumb
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.
Photo of Printmark

Printmark

  • 436 Points 250 badge 2x thumb
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.