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

    Submission: Missing data on "Please enter the sales check number, original receipt, gift receipt or parcel tag number:" field

    Asked by Mbertol on October 15, 2015 at 04:14 PM

    I'm finding that when I download my submissions to an excel file, that some of the required fields are blank. When I look at the individual submissions the information is there.

    Why is it not transferring over to the Excel file?

  • Profile Image
    JotForm Support Manager

    Answered by Jeanette on October 15, 2015 at 10:35 PM

    I this happening only on this form ? http://www.jotform.com/51886880542264

    Or is this happening in general? I made a test and could not reproduce the problem, I was able to get the submissions in both the Excel file and the email.


  • Profile Image

    Answered by Mbertol on October 16, 2015 at 09:45 AM
    Yes, that is the form in which it's happening. It's not happening for
    every submission but the information that it's dropping is crucial to the
    Michael Bertolini
    Business Analyst, Change Management
    Sears Customer Support Centres (CSC)
    Sears Canada
    Email: mbertol@sears.ca
    Phone: 416 747 4987
  • Profile Image
    JotForm Support

    Answered by Chriistian on October 16, 2015 at 11:11 AM



    I checked the specific form submission of the issue you are reporting and I was able to replicate the issue. I will escalate the issue to our development team for them to further check the issue. We will inform you on this thread any updates on the issue.


    Do let us know if you need further assistance.

  • Profile Image

    Answered by alp_deniz on October 18, 2015 at 03:18 AM


    All non-numeric input was getting filtered out while generating excel, however, I have now enabled their display as string when they has non-numeric values or is beginning with "0" to prevent its loss.

    I hope you will find it helpful.

    Kind regards