Forum Discussion
- DineshRampalQrew CadetHi 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. - ArshadKhwajaQrew CommanderThanks. Appreciate your response but I thought if there was a formula like in Excel (=proper()) which does the trick.
- MichaelBarrowQrew CadetMy 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/ - ArshadKhwajaQrew CommanderMany thanks for your effort.
- QuickBaseCoachDQrew CaptainArshad
Are these short phrases? It be done by a native formula if there were a limited number of words. - ArshadKhwajaQrew CommanderMark
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. - _anomDiebolt_Qrew EliteUse 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());
});