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

    split data on google spreadsheet to separate columns

    Asked by minoxcz on September 10, 2015 at 09:00 AM

    Im testing your service for our company and I have two comments/problems:

     

    1) I want to use Google spreadsheet integration, but I have a problem with broken "submission date", there is a random number (attach pictures).

    2)Additionally, browser information is displayed in one big cell and occupy much space, it is possible that each data displayed in its own cell (shown in the attached pic) can be set/customize this somehow?

    Or if there is any possibility to sent every single submission immediately and automatically to an excel file, perhaps via Dropbox, so it would be best!

     

    Thanks

    Alex

    Screenshot
    problem dropbox excel Comments
  • Profile Image
    JotForm Support

    Answered by Kiran on September 10, 2015 at 12:12 PM

    Unfortunately, it is not possible to split the browser data into separate columns. However, we have a workaround that might work for you which needs to add some functions to the downloaded spreadsheet with submission data. Please refer to the following thread with the workaround provided by our colleague. 

    http://www.jotform.com/answers/290516-

    You can also see a video here how it is done. If you want this to be done on Google Spreadsheet itself, you'll need to use a separate sheet to copy the submission data since any changes to the submissions received sheet will break the Spreadsheet integration and results in not receiving data to spreadsheets.

    The data can only be exported to Excel sheet from the submissions view or by generating an Excel report

    Your other question related to submission date is moved to a separate thread and shall be addressed there shortly.

    http://www.jotform.com/answers/658990

    Thank you!