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

    Correct casing before inserting to db

    Asked by studiomundo on June 30, 2015 at 09:02 AM

    Hi,

    All e-mail address must be written in lowercased, but some people insist on typing capitalized. At other times, customer claim that I write their name in lowercased. Since all of this data comes from the client.

    How do I apply a filter before inserting into the database?

     

    example:

    emails [chars to convert all lower case]

    name [convert to first letter in uppercase]

  • Profile Image
    JotForm Support

    Answered by EltonCris on June 30, 2015 at 12:05 PM

    How are you saving the submissions in to your database? If you are using custom script to capture the form data via HTTP Post, you can define on your script to correct the casing on that fields. 

    However, if you are relying on the email data, you can capitalize the first letter of every field value by following this guide: https://www.jotform.com/help/162-Capitalizing-the-First-Letter-of-Every-Word-of-the-E-mail-Response

    For the lowercase conversion, you can still do this in your form notification by wrapping the field variable with the following code. e.g. if your email field variable is {email}, it will look like this:

    <span style="text-transform: lowercase;">{email}</span>

    To do this, you have to open the HTML editor on your form notification. Find the email variable and insert the above code. If the email variable is already wrapped with span tag, just add only the text in bold.

    If you need further help with this, let us know.

    Regards!