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.
Problem downloading dataAsked by topsgtusmc on November 11, 2013 at 09:59 AM
I have been using my forms for several months with no problems. When I want to report, I go to MY FORMS and select the form. The I click SUBMISSIONS and SAVE the submissions as an EXCEL spreadsheet. I use a matrix in my MONTHLY form and this has always been pulled into the spreadsheet as NUMERIC data. All of my Crystal Reports were designed to use this data as numeric. This has worked for months.
Suddenly, the excel spreadsheet is saving the data as TEXT and I can't force it to NUMERIC !! This messes up my entire system.
Is there any way I can force the data to be numeric in the EXCEL ??? I tried saving as CSV and it looks numeric but then I can't use that as a basis for my reports and when I save that CSV as an XLS file, it goes back to TEXT
I have changed our Excel generator to use string data type for all cells to prevent leading zeroes from getting stripped on some numbers, as described on this ticket.
I will have this improved in a bit. Your patience is greatly appreciated.
I noticed that now the YEAR in one of my forms is now NUMBER format as I
need, but the data in the matrix is still TEXT
See my form NDI MONTHLY REPORT ... if possible, I need the data in this
matrix to download to EXCEL as NUMBER format
Thank you for your update.
We will check this out and get back to you once we have any solution to the issue.
Again, fixed. Sorry about that.
By the way, I noticed that there are values like '00' on your spreadsheet. In cases like that, you must manually convert them to numbers -- I have updated our Excel generator to treat such values as TEXT because there are a lot of people who use leading zeroes in their fields.
Thanks SO much …. The users that are inputting the data are not all ‘real tech savvy’ so occasionally they put in 00 or O when they have been instructed to enter a single 0
However my crystal report ignores that in the tally so it’s all good
Really appreciate the quick resolution
In behalf of my Colleagues, you are most welcome! :)
We are glad to be any help with your Jotform needs.
Feel free to contact us anytime if you need further help.
Thank you for using JotForm.