Converting Field Contents To Sentence Case

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
Is there a function that converts contents of a field to sentence case (each starting letter upper case)? 
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,132 Points 3k badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Dinesh

Dinesh

  • 202 Points 100 badge 2x thumb
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.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,132 Points 3k badge 2x thumb
Thanks.  Appreciate your response but I thought if there was a formula like in Excel (=proper()) which does the trick. 
Photo of Michael Barrow

Michael Barrow

  • 2,206 Points 2k badge 2x thumb
My first thought on this was to look around for an open API that would do this for you. Pass it a text string and what form of upper/lower case you want and have it pass back the converted text. I couldn't find such a thing here (but maybe I wasn't searching well enough):

https://www.programmableweb.com/apis/directory

Something that works like this does manually:
https://convertcase.net/
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,132 Points 3k badge 2x thumb
Many thanks for your effort. 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,166 Points 50k badge 2x thumb
Arshad
Are these short phrases? It be done by a native formula if there were a limited number of words.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,132 Points 3k badge 2x thumb
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.  
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,352 Points 20k badge 2x thumb
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());
});