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.

5 Replies

  • 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.
  • EvanMartinez's avatar
    EvanMartinez
    Moderator
    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. 
  • aDummyWithaPC's avatar
    aDummyWithaPC
    Qrew Trainee
    7 months ago

    Thanks Dan. Leaving this here for future users (up to 100 words)

    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 fieldOneWordSix =   Part($fieldOne,6," ");
    var text fieldOneWordSeven =   Part($fieldOne,7," ");
    var text fieldOneWordEight =   Part($fieldOne,8," ");
    var text fieldOneWordNine =   Part($fieldOne,9," ");
    var text fieldOneWordTen =   Part($fieldOne,10," ");
    var text fieldOneWordEleven =   Part($fieldOne,11," ");
    var text fieldOneWordTwelve =   Part($fieldOne,12," ");
    var text fieldOneWordThirteen =   Part($fieldOne,13," ");
    var text fieldOneWordFourteen =   Part($fieldOne,14," ");
    var text fieldOneWordFifteen =   Part($fieldOne,15," ");
    var text fieldOneWordSixteen =   Part($fieldOne,16," ");
    var text fieldOneWordSeventeen =   Part($fieldOne,17," ");
    var text fieldOneWordEighteen =   Part($fieldOne,18," ");
    var text fieldOneWordNineteen =   Part($fieldOne,19," ");
    var text fieldOneWordTwenty =   Part($fieldOne,20," ");
    var text fieldOneWordTwentyOne =   Part($fieldOne,21," ");
    var text fieldOneWordTwentyTwo =   Part($fieldOne,22," ");
    var text fieldOneWordTwentyThree =   Part($fieldOne,23," ");
    var text fieldOneWordTwentyFour =   Part($fieldOne,24," ");
    var text fieldOneWordTwentyFive =   Part($fieldOne,25," ");
    var text fieldOneWordTwentySix =   Part($fieldOne,26," ");
    var text fieldOneWordTwentySeven =   Part($fieldOne,27," ");
    var text fieldOneWordTwentyEight =   Part($fieldOne,28," ");
    var text fieldOneWordTwentyNine =   Part($fieldOne,29," ");
    var text fieldOneWordThirty =   Part($fieldOne,30," ");
    var text fieldOneWordThirtyOne =   Part($fieldOne,31," ");
    var text fieldOneWordThirtyTwo =   Part($fieldOne,32," ");
    var text fieldOneWordThirtyThree =   Part($fieldOne,33," ");
    var text fieldOneWordThirtyFour =   Part($fieldOne,34," ");
    var text fieldOneWordThirtyFive =   Part($fieldOne,35," ");
    var text fieldOneWordThirtySix =   Part($fieldOne,36," ");
    var text fieldOneWordThirtySeven =   Part($fieldOne,37," ");
    var text fieldOneWordThirtyEight =   Part($fieldOne,38," ");
    var text fieldOneWordThirtyNine =   Part($fieldOne,39," ");
    var text fieldOneWordForty =   Part($fieldOne,40," ");
    var text fieldOneWordFortyOne =   Part($fieldOne,41," ");
    var text fieldOneWordFortyTwo =   Part($fieldOne,42," ");
    var text fieldOneWordFortyThree =   Part($fieldOne,43," ");
    var text fieldOneWordFortyFour =   Part($fieldOne,44," ");
    var text fieldOneWordFortyFive =   Part($fieldOne,45," ");
    var text fieldOneWordFortySix =   Part($fieldOne,46," ");
    var text fieldOneWordFortySeven =   Part($fieldOne,47," ");
    var text fieldOneWordFortyEight =   Part($fieldOne,48," ");
    var text fieldOneWordFortyNine =   Part($fieldOne,49," ");
    var text fieldOneWordFifty =   Part($fieldOne,50," ");
    var text fieldOneWordFiftyOne =   Part($fieldOne,51," ");
    var text fieldOneWordFiftyTwo =   Part($fieldOne,52," ");
    var text fieldOneWordFiftyThree =   Part($fieldOne,53," ");
    var text fieldOneWordFiftyFour =   Part($fieldOne,54," ");
    var text fieldOneWordFiftyFive =   Part($fieldOne,55," ");
    var text fieldOneWordFiftySix =   Part($fieldOne,56," ");
    var text fieldOneWordFiftySeven =   Part($fieldOne,57," ");
    var text fieldOneWordFiftyEight =   Part($fieldOne,58," ");
    var text fieldOneWordFiftyNine =   Part($fieldOne,59," ");
    var text fieldOneWordSixty =   Part($fieldOne,60," ");
    var text fieldOneWordSixtyOne =   Part($fieldOne,61," ");
    var text fieldOneWordSixtyTwo =   Part($fieldOne,62," ");
    var text fieldOneWordSixtyThree =   Part($fieldOne,63," ");
    var text fieldOneWordSixtyFour =   Part($fieldOne,64," ");
    var text fieldOneWordSixtyFive =   Part($fieldOne,65," ");
    var text fieldOneWordSixtySix =   Part($fieldOne,66," ");
    var text fieldOneWordSixtySeven =   Part($fieldOne,67," ");
    var text fieldOneWordSixtyEight =   Part($fieldOne,68," ");
    var text fieldOneWordSixtyNine =   Part($fieldOne,69," ");
    var text fieldOneWordSeventy =   Part($fieldOne,70," ");
    var text fieldOneWordSeventyOne =   Part($fieldOne,71," ");
    var text fieldOneWordSeventyTwo =   Part($fieldOne,72," ");
    var text fieldOneWordSeventyThree =   Part($fieldOne,73," ");
    var text fieldOneWordSeventyFour =   Part($fieldOne,74," ");
    var text fieldOneWordSeventyFive =   Part($fieldOne,75," ");
    var text fieldOneWordSeventySix =   Part($fieldOne,76," ");
    var text fieldOneWordSeventySeven =   Part($fieldOne,77," ");
    var text fieldOneWordSeventyEight =   Part($fieldOne,78," ");
    var text fieldOneWordSeventyNine =   Part($fieldOne,79," ");
    var text fieldOneWordEighty =   Part($fieldOne,80," ");
    var text fieldOneWordEightyOne =   Part($fieldOne,81," ");
    var text fieldOneWordEightyTwo =   Part($fieldOne,82," ");
    var text fieldOneWordEightyThree =   Part($fieldOne,83," ");
    var text fieldOneWordEightyFour =   Part($fieldOne,84," ");
    var text fieldOneWordEightyFive =   Part($fieldOne,85," ");
    var text fieldOneWordEightySix =   Part($fieldOne,86," ");
    var text fieldOneWordEightySeven =   Part($fieldOne,87," ");
    var text fieldOneWordEightyEight =   Part($fieldOne,88," ");
    var text fieldOneWordEightyNine =   Part($fieldOne,89," ");
    var text fieldOneWordNinety =   Part($fieldOne,90," ");
    var text fieldOneWordNinetyOne =   Part($fieldOne,91," ");
    var text fieldOneWordNinetyTwo =   Part($fieldOne,92," ");
    var text fieldOneWordNinetyThree =   Part($fieldOne,93," ");
    var text fieldOneWordNinetyFour =   Part($fieldOne,94," ");
    var text fieldOneWordNinetyFive =   Part($fieldOne,95," ");
    var text fieldOneWordNinetySix =   Part($fieldOne,96," ");
    var text fieldOneWordNinetySeven =   Part($fieldOne,97," ");
    var text fieldOneWordNinetyEight =   Part($fieldOne,98," ");
    var text fieldOneWordNinetyNine =   Part($fieldOne,99," ");
    var text fieldOneWordOneHundred =   Part($fieldOne,100," ");

    var text ProperCase = 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)),
    Upper(Left($fieldOneWordSix,1)) & Lower(NotLeft($fieldOneWordSix,1)),
    Upper(Left($fieldOneWordSeven,1)) & Lower(NotLeft($fieldOneWordSeven,1)),
    Upper(Left($fieldOneWordEight,1)) & Lower(NotLeft($fieldOneWordEight,1)),
    Upper(Left($fieldOneWordNine,1)) & Lower(NotLeft($fieldOneWordNine,1)),
    Upper(Left($fieldOneWordTen,1)) & Lower(NotLeft($fieldOneWordTen,1)),
    Upper(Left($fieldOneWordEleven,1)) & Lower(NotLeft($fieldOneWordEleven,1)),
    Upper(Left($fieldOneWordTwelve,1)) & Lower(NotLeft($fieldOneWordTwelve,1)),
    Upper(Left($fieldOneWordThirteen,1)) & Lower(NotLeft($fieldOneWordThirteen,1)),
    Upper(Left($fieldOneWordFourteen,1)) & Lower(NotLeft($fieldOneWordFourteen,1)),
    Upper(Left($fieldOneWordFifteen,1)) & Lower(NotLeft($fieldOneWordFifteen,1)),
    Upper(Left($fieldOneWordSixteen,1)) & Lower(NotLeft($fieldOneWordSixteen,1)),
    Upper(Left($fieldOneWordSeventeen,1)) & Lower(NotLeft($fieldOneWordSeventeen,1)),
    Upper(Left($fieldOneWordEighteen,1)) & Lower(NotLeft($fieldOneWordEighteen,1)),
    Upper(Left($fieldOneWordNineteen,1)) & Lower(NotLeft($fieldOneWordNineteen,1)),
    Upper(Left($fieldOneWordTwenty,1)) & Lower(NotLeft($fieldOneWordTwenty,1)),
    Upper(Left($fieldOneWordTwentyOne,1)) & Lower(NotLeft($fieldOneWordTwentyOne,1)),
    Upper(Left($fieldOneWordTwentyTwo,1)) & Lower(NotLeft($fieldOneWordTwentyTwo,1)),
    Upper(Left($fieldOneWordTwentyThree,1)) & Lower(NotLeft($fieldOneWordTwentyThree,1)),
    Upper(Left($fieldOneWordTwentyFour,1)) & Lower(NotLeft($fieldOneWordTwentyFour,1)),
    Upper(Left($fieldOneWordTwentyFive,1)) & Lower(NotLeft($fieldOneWordTwentyFive,1)),
    Upper(Left($fieldOneWordTwentySix,1)) & Lower(NotLeft($fieldOneWordTwentySix,1)),
    Upper(Left($fieldOneWordTwentySeven,1)) & Lower(NotLeft($fieldOneWordTwentySeven,1)),
    Upper(Left($fieldOneWordTwentyEight,1)) & Lower(NotLeft($fieldOneWordTwentyEight,1)),
    Upper(Left($fieldOneWordTwentyNine,1)) & Lower(NotLeft($fieldOneWordTwentyNine,1)),
    Upper(Left($fieldOneWordThirty,1)) & Lower(NotLeft($fieldOneWordThirty,1)),
    Upper(Left($fieldOneWordThirtyOne,1)) & Lower(NotLeft($fieldOneWordThirtyOne,1)),
    Upper(Left($fieldOneWordThirtyTwo,1)) & Lower(NotLeft($fieldOneWordThirtyTwo,1)),
    Upper(Left($fieldOneWordThirtyThree,1)) & Lower(NotLeft($fieldOneWordThirtyThree,1)),
    Upper(Left($fieldOneWordThirtyFour,1)) & Lower(NotLeft($fieldOneWordThirtyFour,1)),
    Upper(Left($fieldOneWordThirtyFive,1)) & Lower(NotLeft($fieldOneWordThirtyFive,1)),
    Upper(Left($fieldOneWordThirtySix,1)) & Lower(NotLeft($fieldOneWordThirtySix,1)),
    Upper(Left($fieldOneWordThirtySeven,1)) & Lower(NotLeft($fieldOneWordThirtySeven,1)),
    Upper(Left($fieldOneWordThirtyEight,1)) & Lower(NotLeft($fieldOneWordThirtyEight,1)),
    Upper(Left($fieldOneWordThirtyNine,1)) & Lower(NotLeft($fieldOneWordThirtyNine,1)),
    Upper(Left($fieldOneWordForty,1)) & Lower(NotLeft($fieldOneWordForty,1)),
    Upper(Left($fieldOneWordFortyOne,1)) & Lower(NotLeft($fieldOneWordFortyOne,1)),
    Upper(Left($fieldOneWordFortyTwo,1)) & Lower(NotLeft($fieldOneWordFortyTwo,1)),
    Upper(Left($fieldOneWordFortyThree,1)) & Lower(NotLeft($fieldOneWordFortyThree,1)),
    Upper(Left($fieldOneWordFortyFour,1)) & Lower(NotLeft($fieldOneWordFortyFour,1)),
    Upper(Left($fieldOneWordFortyFive,1)) & Lower(NotLeft($fieldOneWordFortyFive,1)),
    Upper(Left($fieldOneWordFortySix,1)) & Lower(NotLeft($fieldOneWordFortySix,1)),
    Upper(Left($fieldOneWordFortySeven,1)) & Lower(NotLeft($fieldOneWordFortySeven,1)),
    Upper(Left($fieldOneWordFortyEight,1)) & Lower(NotLeft($fieldOneWordFortyEight,1)),
    Upper(Left($fieldOneWordFortyNine,1)) & Lower(NotLeft($fieldOneWordFortyNine,1)),
    Upper(Left($fieldOneWordFifty,1)) & Lower(NotLeft($fieldOneWordFifty,1)),
    Upper(Left($fieldOneWordFiftyOne,1)) & Lower(NotLeft($fieldOneWordFiftyOne,1)),
    Upper(Left($fieldOneWordFiftyTwo,1)) & Lower(NotLeft($fieldOneWordFiftyTwo,1)),
    Upper(Left($fieldOneWordFiftyThree,1)) & Lower(NotLeft($fieldOneWordFiftyThree,1)),
    Upper(Left($fieldOneWordFiftyFour,1)) & Lower(NotLeft($fieldOneWordFiftyFour,1)),
    Upper(Left($fieldOneWordFiftyFive,1)) & Lower(NotLeft($fieldOneWordFiftyFive,1)),
    Upper(Left($fieldOneWordFiftySix,1)) & Lower(NotLeft($fieldOneWordFiftySix,1)),
    Upper(Left($fieldOneWordFiftySeven,1)) & Lower(NotLeft($fieldOneWordFiftySeven,1)),
    Upper(Left($fieldOneWordFiftyEight,1)) & Lower(NotLeft($fieldOneWordFiftyEight,1)),
    Upper(Left($fieldOneWordFiftyNine,1)) & Lower(NotLeft($fieldOneWordFiftyNine,1)),
    Upper(Left($fieldOneWordSixty,1)) & Lower(NotLeft($fieldOneWordSixty,1)),
    Upper(Left($fieldOneWordSixtyOne,1)) & Lower(NotLeft($fieldOneWordSixtyOne,1)),
    Upper(Left($fieldOneWordSixtyTwo,1)) & Lower(NotLeft($fieldOneWordSixtyTwo,1)),
    Upper(Left($fieldOneWordSixtyThree,1)) & Lower(NotLeft($fieldOneWordSixtyThree,1)),
    Upper(Left($fieldOneWordSixtyFour,1)) & Lower(NotLeft($fieldOneWordSixtyFour,1)),
    Upper(Left($fieldOneWordSixtyFive,1)) & Lower(NotLeft($fieldOneWordSixtyFive,1)),
    Upper(Left($fieldOneWordSixtySix,1)) & Lower(NotLeft($fieldOneWordSixtySix,1)),
    Upper(Left($fieldOneWordSixtySeven,1)) & Lower(NotLeft($fieldOneWordSixtySeven,1)),
    Upper(Left($fieldOneWordSixtyEight,1)) & Lower(NotLeft($fieldOneWordSixtyEight,1)),
    Upper(Left($fieldOneWordSixtyNine,1)) & Lower(NotLeft($fieldOneWordSixtyNine,1)),
    Upper(Left($fieldOneWordSeventy,1)) & Lower(NotLeft($fieldOneWordSeventy,1)),
    Upper(Left($fieldOneWordSeventyOne,1)) & Lower(NotLeft($fieldOneWordSeventyOne,1)),
    Upper(Left($fieldOneWordSeventyTwo,1)) & Lower(NotLeft($fieldOneWordSeventyTwo,1)),
    Upper(Left($fieldOneWordSeventyThree,1)) & Lower(NotLeft($fieldOneWordSeventyThree,1)),
    Upper(Left($fieldOneWordSeventyFour,1)) & Lower(NotLeft($fieldOneWordSeventyFour,1)),
    Upper(Left($fieldOneWordSeventyFive,1)) & Lower(NotLeft($fieldOneWordSeventyFive,1)),
    Upper(Left($fieldOneWordSeventySix,1)) & Lower(NotLeft($fieldOneWordSeventySix,1)),
    Upper(Left($fieldOneWordSeventySeven,1)) & Lower(NotLeft($fieldOneWordSeventySeven,1)),
    Upper(Left($fieldOneWordSeventyEight,1)) & Lower(NotLeft($fieldOneWordSeventyEight,1)),
    Upper(Left($fieldOneWordSeventyNine,1)) & Lower(NotLeft($fieldOneWordSeventyNine,1)),
    Upper(Left($fieldOneWordEighty,1)) & Lower(NotLeft($fieldOneWordEighty,1)),
    Upper(Left($fieldOneWordEightyOne,1)) & Lower(NotLeft($fieldOneWordEightyOne,1)),
    Upper(Left($fieldOneWordEightyTwo,1)) & Lower(NotLeft($fieldOneWordEightyTwo,1)),
    Upper(Left($fieldOneWordEightyThree,1)) & Lower(NotLeft($fieldOneWordEightyThree,1)),
    Upper(Left($fieldOneWordEightyFour,1)) & Lower(NotLeft($fieldOneWordEightyFour,1)),
    Upper(Left($fieldOneWordEightyFive,1)) & Lower(NotLeft($fieldOneWordEightyFive,1)),
    Upper(Left($fieldOneWordEightySix,1)) & Lower(NotLeft($fieldOneWordEightySix,1)),
    Upper(Left($fieldOneWordEightySeven,1)) & Lower(NotLeft($fieldOneWordEightySeven,1)),
    Upper(Left($fieldOneWordEightyEight,1)) & Lower(NotLeft($fieldOneWordEightyEight,1)),
    Upper(Left($fieldOneWordEightyNine,1)) & Lower(NotLeft($fieldOneWordEightyNine,1)),
    Upper(Left($fieldOneWordNinety,1)) & Lower(NotLeft($fieldOneWordNinety,1)),
    Upper(Left($fieldOneWordNinetyOne,1)) & Lower(NotLeft($fieldOneWordNinetyOne,1)),
    Upper(Left($fieldOneWordNinetyTwo,1)) & Lower(NotLeft($fieldOneWordNinetyTwo,1)),
    Upper(Left($fieldOneWordNinetyThree,1)) & Lower(NotLeft($fieldOneWordNinetyThree,1)),
    Upper(Left($fieldOneWordNinetyFour,1)) & Lower(NotLeft($fieldOneWordNinetyFour,1)),
    Upper(Left($fieldOneWordNinetyFive,1)) & Lower(NotLeft($fieldOneWordNinetyFive,1)),
    Upper(Left($fieldOneWordNinetySix,1)) & Lower(NotLeft($fieldOneWordNinetySix,1)),
    Upper(Left($fieldOneWordNinetySeven,1)) & Lower(NotLeft($fieldOneWordNinetySeven,1)),
    Upper(Left($fieldOneWordNinetyEight,1)) & Lower(NotLeft($fieldOneWordNinetyEight,1)),
    Upper(Left($fieldOneWordNinetyNine,1)) & Lower(NotLeft($fieldOneWordNinetyNine,1)),
    Upper(Left($fieldOneWordOneHundred,1)) & Lower(NotLeft($fieldOneWordOneHundred,1)));