What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Proper casing of the names on Excel and PDF

    Asked by johnbward 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

    Page URL:
    http://www.longueville9322.co.uk/Log_In/Navigation/Lodge_Dining/Dining<br/>_Form/dining_form.php

  • Profile Image
    JotForm Support

    Answered by EltonCris 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
    JotForm Support

    Answered by EltonCris 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

    Answered by johnbward 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
    JotForm Support

    Answered by EltonCris 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.