Getting Started

 View Only
  • 1.  Set a field in upper case

    Posted 01-03-2022 06:14
    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
    ------------------------------


  • 2.  RE: Set a field in upper case

    Posted 01-03-2022 09:01
    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
    ------------------------------



  • 3.  RE: Set a field in upper case

    Posted 01-04-2022 02:48
    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
    ------------------------------



  • 4.  RE: Set a field in upper case

    Posted 01-04-2022 08:04
    Edited by Mark Shnier (Your Quickbase Coach) 01-04-2022 08:05
    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
    ------------------------------



  • 5.  RE: Set a field in upper case

    Posted 01-04-2022 08:48
    You can make a formula text field that converts everything to uppercase using Upper([Text Entry Field])

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



  • 6.  RE: Set a field in upper case

    Posted 01-04-2022 09:00
    Hi Sean
    Unfortunately no... 
    It seems that it is not possible to apply a formula on the same field


    ------------------------------
    Adriano Visconti
    ------------------------------



  • 7.  RE: Set a field in upper case

    Posted 01-04-2022 09:06
    Edited by Sean Connaughton 01-04-2022 09:07
    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
    ------------------------------