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

    Problem downloading data

    Asked 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

     

    HELP ??

     

    Bill Dozier

     

     

    Screenshot
    problem My Forms Reports Submissions excel CSV
  • Profile Image
    JotForm Support

    Answered by NeilVicente on November 11, 2013 at 11:39 AM

    Bill,

    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.

  • Profile Image
    JotForm Support

    Answered by NeilVicente on November 11, 2013 at 11:47 AM

    Fixed.

  • Profile Image

    Answered by topsgtusmc on November 11, 2013 at 03:22 PM
    Hello Neil
    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
    Bill
  • Profile Image
    JotForm Support

    Answered by Mike_T on November 11, 2013 at 03:52 PM

    Thank you for your update.

    We will check this out and get back to you once we have any solution to the issue.

  • Profile Image
    JotForm Support

    Answered by NeilVicente on November 11, 2013 at 10:47 PM

    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.

    Cheers!

  • Profile Image

    Answered by topsgtusmc on November 12, 2013 at 06:18 PM
    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

    Bill Dozier

  • Profile Image

    Answered by khrisell on November 12, 2013 at 06:24 PM

    Hello Bill,

    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.