Ability to force inputted text to be saved in uppercase.

  • Profile Image
    davidakoontz
    Asked on March 20, 2020 at 04:44 PM

    I saw another support question - looked like an answer - but upon implementing and testing it failed.  The https://www.jotform.com/answers/1656283-Can-We-Force-All-Caps-on-a-Text-Entry suggest using custom CSS:

    .form-textbox {

        text-transform: uppercase!important;

    }

    This appears to work (just on Jotform site) but when integrating data to Airtable the data is persisted in lower case as entered.  That makes sense as CSS is not designed to modify the data - just style it.

    Seems like this would be a popular data entry request as old databases prefered upper case.  I'm entering stock ticker symbols... always upper case.

    Any other options?

  • Profile Image
    Vanessa_T
    Answered on March 20, 2020 at 05:12 PM

    True, CSS codes are only intended to design how the site/data looks but it does not really alter the data.

    Unfortunately, there is currently no option to force the data saved and sent to Airtable to be uppercase within JotForm.

    However, if you are embedding the form within your website, you may use the source code instead and then add the onkeyup Javascript EventListener to every input field.

    How-to-get-the-Full-Source-Code-of-your-Form

    onkeyup="this.value = this.value.toUpperCase();"

    This way, once the user enters a value to the input field, that value is then actually transformed to uppercase. So when user submits the form, the uppercased  value is saved to Jotform and sequentially sent to Airtable.

    Nonetheless, I have made a feature request for you. Though we cannot guarantee when and if it will be implemented, rest assured you will be notified here via this thread.

  • Profile Image
    davidakoontz
    Answered on March 20, 2020 at 05:42 PM

    Hey thank you Vanessa that's an option - host the form on my own site and edit the code.

    I'd rather have a selection option on the menu of the tool, however.

  • Profile Image
    BDAVID
    Answered on March 20, 2020 at 06:12 PM

    If this option becomes possible in the future, you will be updated here.