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.
Submission: Missing data on "Please enter the sales check number, original receipt, gift receipt or parcel tag number:" fieldAsked 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?
excel in how Submissions excel file information
JotForm Support Manager
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.
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
Business Analyst, Change Management
Sears Customer Support Centres (CSC)
Phone: 416 747 4987
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.
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.