Skip to main content
Question

Converting Field Contents To Sentence Case

  • September 21, 2017
  • 0 replies
  • 94 views

Is there a function that converts contents of a field to sentence case (each starting letter upper case)? 
This topic has been closed for replies.

  • Registered
  • September 21, 2017
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.

  • Author
  • Registered
  • September 22, 2017
Thanks.  Appreciate your response but I thought if there was a formula like in Excel (=proper()) which does the trick. 

  • Registered
  • September 22, 2017
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/

  • Author
  • Registered
  • September 22, 2017
Many thanks for your effort. 

Arshad
Are these short phrases? It be done by a native formula if there were a limited number of words.

  • Author
  • Registered
  • September 22, 2017
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.  

  • Registered
  • September 22, 2017
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());
});