Forum Discussion

ArshadKhwaja's avatar
ArshadKhwaja
Qrew Commander
8 years ago

Converting Field Contents To Sentence Case

Is there a function that converts contents of a field to sentence case (each starting letter upper case)? 
  • Hi Arshad
    Not in Native Quickbase to best of my knowledge. We can user JQuery instead. if that can work, then a string operation can be done to read the field value, scan for . (stop) and apply upper to the next character.
  • Thanks.  Appreciate your response but I thought if there was a formula like in Excel (=proper()) which does the trick. 
  • Arshad
    Are these short phrases? It be done by a native formula if there were a limited number of words.
  • Mark

    These are a short phrases people are entering which are then listed at the top of the record as the heading.  I was hoping to have that label convert the text.  
  • Use the IOL technique on the form when the text is originally entered. See screenshot and script manually applied through the console.

    $("#_fid_6").on("blur", function() {
      _fid_6.value = _fid_6.value.replace(/\b\w/g, word => word.toUpperCase());
    });