Forum Discussion

AdrianoVisconti's avatar
AdrianoVisconti
Qrew Member
3 years ago

Set a field in upper case

Hi all
Sorry, I am new in QuickBase

I would like all my text fields to be written only in capital letters by our users. How is it possible to do this ? Thank you!!

------------------------------
Adriano Visconti
------------------------------
  • There is no global setting to do that. On a field by field basis for particular important fields it is possible to do but it requires using a formula field to convert the data entry by the user into uppercase and then a form rule to change the data entry field to have the value of the formula field. But that would not be practical to do across a whole application.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • AdrianoVisconti's avatar
      AdrianoVisconti
      Qrew Member
      Hi Mark & thanks for the answer.
      Maybe it is possible to have the same result (uppercase only) using HTML commands or something else?

      ------------------------------
      Adriano Visconti
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        Well I highly doubt it.  Recently Quickbase locked down the use of Java script and other techniques which alter the native behavior of the page,  in order to lock down the security of the platform and achieve a high SOC security rating.  So I doubt you will find that kind of loophole.

        ------------------------------
        Mark Shnier (YQC)
        mark.shnier@gmail.com
        ------------------------------
  • You can make a formula text field that converts everything to uppercase using Upper([Text Entry Field])

    ------------------------------
    Sean Connaughton
    ------------------------------
    • AdrianoVisconti's avatar
      AdrianoVisconti
      Qrew Member
      Hi Sean
      Unfortunately no... 
      It seems that it is not possible to apply a formula on the same field


      ------------------------------
      Adriano Visconti
      ------------------------------
      • SeanConnaughto1's avatar
        SeanConnaughto1
        Qrew Cadet
        Sorry, I realized I should have been more specific after submitting--

        I meant to create a second field that is a formula text field with the formula above. You could use the formula field in any reports needed. Or, if you only need it displayed on the form, you could set the form field element properties of the entry field to only show in add/edit mode and the formula field to only show when in view mode. Let me know if you want any more details on that and I try to help with steps/pictures.

        ------------------------------
        Sean Connaughton
        ------------------------------