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

    I would like to be able to capitalize the saved data

    Asked by watchhelp on June 21, 2016 at 11:23 AM

    Hello Jotform. I too would like to see this feature. I mentioned in a previous post that "PROPER" is an old formula in Excel (if my memory serves...Excel is so 20th Century :) and Gsheets to allow proper capitalization. It would be really helpful in Jotform if that could be turned on so all data, no matter where it lands (spreadsheet, CRM etc. etc.) will look good. We too must do a lot of clean up of names since the Jotform data flows to our CRM which flows to Freshbooks which flows to our shipping software. Does not look good if it reads john doe... Thanks! Mark

  • Profile Image

    Answered by Carina on June 21, 2016 at 11:33 AM

    I have created a feature request so that our developers might consider the implementation of this feature.

    We will contact you via this thread if they decide on its implementation, but until now it was not a high priority feature.

    In the meantime you can download the Excel submissions list and use this trick to automatically capitalize first letter:

    https://support.office.com/en-us/article/Change-text-to-upper-lower-or-proper-normal-font-c4056aab-8053-498f-a764-c23c6ad1c244 

    Or use this trick for your Google Spreadsheet:

    https://support.google.com/docs/answer/3094133?hl=en 

    Let us know if we can assist you further.   

  • Profile Image

    Answered by watchhelp on June 22, 2016 at 11:45 AM
    Thanks for the idea...however getting the data from Gsheets to our CRM is
    not so simple. That would require Zapier which then has a delay. I would
    like the data to flow instantly from Jotform to our CRM. Thanks for the
    suggestion though.
    What about using Code Editor by JotForm

    would this widget allow code or a formula like the ones suggested in your
    links for Excel or Gsheet to fix the capitalization issue within the form?
    Thanks,
    Mark
    ...
  • Profile Image
    JotForm Support

    Answered by BJoanna on June 22, 2016 at 02:15 PM

    Unfortunately currently it is not possible to fix the capitalization inside of JotForm submission page. My colleague already created feature request. 

    For now you can only try with suggestions provided by my colleague.

  • Profile Image

    Answered by watchhelp on June 22, 2016 at 02:45 PM
    Thx.
    ...