Discussions

Expand all | Collapse all

Text To Proper Case

  • 1.  Text To Proper Case

    Posted 02-22-2019 20:26
    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.


  • 2.  RE: Text To Proper Case

    Posted 02-25-2019 16:17
    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">http://quickbase.uservoice.com/">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. 


  • 3.  RE: Text To Proper Case

    Posted 02-25-2019 16:39
    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.


  • 4.  RE: Text To Proper Case

    Posted 02-25-2019 16:52
    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.