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 to submit

    Asked by aylin77 on October 31, 2011 at 07:26 AM
    I am very agry... somitmes it works to submit and sevral times it didn't work like today. here are my 2 forms: http://jotform.net/form/12154946257 http://jotform.net/form/12751731221Thanks a lot
  • Profile Image

    Answered by allanftd on October 31, 2011 at 07:36 AM

    Hi aylin77,

    We're sorry for the inconvenience. Please modify the URL of your forms as follows:

    http://www.jotform.com/form/12154946257 
    http://www.jotform.com/form/12751731221

    Kindly try and let us know if it works this time or not. We appreciate your patience on this matter.

    Thank you for using JotForm!

    Allan
    JOTFORM SUPPORT

     

  • Profile Image

    Answered by aylin77 on October 31, 2011 at 11:11 AM
    hello,I tried with google chrome and IE with and also withe the different URL and it still didn't work.Help please!!
  • Profile Image

    Answered by allanftd on October 31, 2011 at 12:54 PM

    Hi aylin77,

    I failed to replicate the issue when I tried using your form. I was able to submit an entry using one of your forms in Google Chrome. Did you see it? I noticed that your forms are quite long and with multiple pages and file uploads. If the users uploaded huge files, it will take some time for it to upload completely depending on their internet connection. That may be the reason why at times it seems that the Submit button is stuck or not working.

    Please let us know if you need further assistance. 

    Thanks for using JotForm

    Allan
    JOTFORM SUPPORT

     

  • Profile Image

    Answered by Aylin77 on November 03, 2011 at 09:42 AM

    Thank you, I hereby recept you form. In fact I found the issue. When I delete cache and cookie in my brower I was able to fill it in the form.

     

    Now another problem.

    In my form I got more than 256 questions. When I export these Datas into my Excel 2007, I Only get 256 columns until the "IV" column. So in the XLS files some columns with datas are missing.

    Even if I got the Excel 2007 (in which it could be able to collect more than 12 000 columns), when I export datas from jotform to my Excel, I only can have 256 columns.

    So, have you a solution please? 

  • Profile Image
    JotForm Support

    Answered by liyam on November 03, 2011 at 10:30 AM

    Sorry about this.

    There seems to be a problem with the character encoding of the data that your excel file got cut off across.

    I will submit a ticket to our development team to let them know about this error.  You can download the CSV file for the meantime. 

    Thanks.

  • Profile Image
    JotForm Founder

    Answered by aytekin on November 03, 2011 at 10:42 AM

    Unfortunately, there is no solution for this. Excel is limited to 255 columns.

    You can get the CSV version of the file and use another spreadsheet such as Google Spreadsheets. 

  • Profile Image

    Answered by aylin77 on November 03, 2011 at 10:56 AM

    It's very difficult for me to understand the CSV version. And why I will use the google spreadsheet since I have paid for a premium service in jotform since september??

    Could you please get the datas from my CSV version? For the moment I just need to have all the header of my table. (all the questions of my form) to integrate it into my Exel file.

     

    Thanks

  • Profile Image
    JotForm Support

    Answered by liyam on November 03, 2011 at 03:26 PM

    The process of manually converting CSV files to XLSX was quite difficult for this one due to the special characters included in the data, but I was able to make it.  Here's what you should do:

    1. Download the CSV file
    2. Open the CSV file using a text editor and find the header part (searching for the last header in the CSV will help)
    3. Paste the headers in cell A1
    4. Go to Data tab and convert using text to columns
    5. On the text to columns wizard, Select Delimited option
    6. On the next page, check comma, make sure the text qualifier is set to double quote
    7.
    Once you have the data set properly every cell, copy again the whole content of the CSV file and paste to your excel file
    8. You will notice that the content got two headers, remove the 1st header line
    9. Save the file in xlsx format

    I have also sent you a copy of the converted file from csv to excel a few minutes ago.

  • Profile Image

    Answered by aylin77 on November 04, 2011 at 04:40 AM

    Thank you very much!! You're such a great support!!

  • Profile Image
    JotForm Support

    Answered by liyam on November 04, 2011 at 07:34 AM

    As I discussed this with my colleague, fxr, he informed me that this is easier to be imported with using Open Office.  You can try downloading and installing this application on this URL: http://www.openoffice.org/

    Please let us know if you need further assistance or if you have other questions or concerns. :)

  • Profile Image

    Answered by aylin77 on November 08, 2011 at 08:13 AM

    Ok thank you. I download open Office.

    But how can I directly importe datas to openOffice and to get all columns??

    otherwies, could you please convert my 2 CSV tables into an excel as you made last time for me? (new forms were fill it in)

    Please I need to collect these datas for my company.

     

    Thank you in advance

     

    http://www.jotform.com/form/12154946257 
    http://www.jotform.com/form/12751731221

  • Profile Image

    Answered by fxr on November 08, 2011 at 10:08 AM

    Hi, Aylin

    Glad to hear you have downloaded OpenOffice, it should make analysis of your data that little bit easier.

    Now, lets show you what need to do to get the csv imported.

    I assuming you have downloaded the csv file of your submissions.

    1. Open OpenOffice Calc.

    2. Select Open from the File menu.

    3. In the resulting dialog box, Select & open your downloaded CSV file.

    4. You will be presented with an Import dialog where you configure your import options.

        Ensure, Unicode UTF-8 is selected for Character Set.

        In the Seperator Options, in the first column of Seperated by,Ensure the Semi-colon option is checked. In the second column, ensure Comma is checked.  Text Delimiter should be "

     

     

    Note: I dont believe the language option is important.

     

    Click OK.

    You should be able to view your entire spreadsheet. All 255+ rows of it.

     

    If you have any problems with any of this, just let me know. Its a pretty straightforward process once you get the hang of it.

  • Profile Image

    Answered by aylin77 on November 11, 2011 at 03:28 AM

    Ok thank you. I download open Office.
    But how can I directly importe datas to openOffice and to get all columns??



  • Profile Image

    Answered by fxr on November 11, 2011 at 03:36 AM

    I have given instructions in the past above.

    What part of the process are you getting stuck at?

    Have you downloaded the csv of your forms submissions to your hard drive? Just open, that file in OpenOffice Calc and configue the import options exactlu as in the screenshot provided above.

  • Profile Image

    Answered by aylin on November 21, 2011 at 04:41 AM

    Thank you again.  I saved my CSV submissions into CSV file to my hard drive. I open it in Open office Calc with  a CSV text. 

    I tried several times and it doesn't worked. There is no the column, it is not on the good order

  • Profile Image

    Answered by aylin77 on November 21, 2011 at 08:10 AM

    Or it is possible that you download for me all submissions from this form? http://www.jotform.com/form/12751731221

     

    Tnaks in advance, I need this for my company

  • Profile Image

    Answered by fxr on November 21, 2011 at 12:00 PM

    http://pamppi.info/jotform-testing/Annuaire-des-Projets-Cap-Digital-appels-projets-FUI-Os-o-ISI.ods

    That file is in Open Office format, using the import options I detailed above.

    Let us know if you have any problems with it.

    -

    Its better if we can you work where your going wrong, so that in the future, you are able to get this data more quickly yourself. Is it possible to get a screenshot of your import screen in Calc when you first open the downloaded csv ? 

    its probably just one small setting you are overlooking.

     

  • Profile Image

    Answered by aylin77 on November 23, 2011 at 09:15 AM

    but i m sure I tried several time with the same settings. But thank you very much. I will see again but if I can't, it will be possible to ask you again?

    I download the file, it is possible that you delete the URL above, because I don't want that everyboby see the datas.

     

    Thanks again

  • Profile Image

    Answered by fxr on November 23, 2011 at 09:24 AM

    Yes, you are welcome to ask again, as long as its not every 20 minutes :)

    I would appreciate a new thread for each time, if at all possible.

    Just give the form ID and say you want your submissions csv converted to ods (open office calc) format.

     

    I have deleted the link above.

     

  • Profile Image

    Answered by aylin77 on November 23, 2011 at 11:17 AM

    All right

     

    You're very great team!!