Forum Discussion

MarkCorcoran's avatar
MarkCorcoran
Qrew Cadet
7 years ago

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. I did see where functions for Upper and Lower can be applied, but not Proper Case.
  • DanLadner1's avatar
    DanLadner1
    Qrew Trainee
    7 years ago
    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.
    • MarkCorcoran's avatar
      MarkCorcoran
      Qrew Cadet
      7 years ago
      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.
  • EvanMartinez's avatar
    EvanMartinez
    Quickbase Staff
    7 years ago
    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.