Proper casing of the names on Excel and PDF

  • Profile Image
    johnbward
    Asked on January 24, 2016 at 11:11 AM

    What are the codes in the field names for Capitalising and Uppercase i.e. First field name, First Name "John" second field name, Last Name "WARD" Some respondents are entering in lower case and I would like the submission to be uniform.

    Thanks John Ward

  • Profile Image
    EltonCris
    Answered on January 24, 2016 at 01:40 PM

    Hi John,

    If you want it to be capitalized on the email notifications, just insert a CAPITALIZE prefix on the field tag you want its first letter to have a capital letter.

    Example:

    {CAPITALIZE:fullName3}

    If you need further assistance or if you have more questions, let us know here.

    Regards!

  • Profile Image
    EltonCris
    Answered on January 24, 2016 at 01:46 PM

    By the way, if you want all letters to be in uppercase on email, just wrap the field tag with the code below on the email source code. Example:

    <span style="text-transform: uppercase;">{name}</span>

    Hope this helps!

  • Profile Image
    johnbward
    Answered on January 25, 2016 at 06:45 AM
    Thanks for your reply.
    What I wanted to know was how to capitalise and force uppercase when downloading the submissions as an Excel file and a PDF file not the email notifications.
    thank you. John Ward


    ...
  • Profile Image
    EltonCris
    Answered on January 25, 2016 at 10:02 AM

    Hi John,

    Unfortunately, there's no direct solution for that. You have to implement this function within the form level using a custom script so the entered data will be corrected first within the form before it gets submitted to the server. You will be able to achieve this when you use your form source code. http://www.jotform.com/help/104-How-to-Download-a-Source-Code-of-your-Form

    Here's an example. This script will transform all the string into uppercase.

    <script type="text/javascript">

    var input = $('input_3'); //change with the field ID

    input.onkeyup = function(){

    input.value = input.value.toUpperCase();

    }

    </script>

    Just change the field ID input_3 with the field ID you want to transfer the text into uppercase.

    If you only want to capitalize the first letter, you can use this method http://stackoverflow.com/questions/1026069/capitalize-the-first-letter-of-string-in-javascript.

    If you need further assistance, do let us know.