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

    How can I edit how results are generated when integrating to google drive?

    Asked by HukaTx on July 19, 2013 at 12:10 PM

    I am using the short answer matrix in various forms, but I do not like how the results for these items appear in the spreadsheet.  They make one long row, instead of appearing in the same row/column format that the information is entered.  Is there a way to have this inputted information dump into the spreadsheet in the same row/column format?  Thank you!

    Page URL:
    http://form.jotform.co/form/31994183750865

    style size font format
  • Profile Image
    JotForm Support

    Answered by guilledutra on July 19, 2013 at 01:23 PM

    Hi! I think this is not possible, but you always can add an other sheet to your  submission googleSpreadsheet then applying some basic formulas(automatic) you could fetch the submissions result from the submission sheet  to the new sheet in a better looking way. I could help you with some spreadsheet tips if you need.

     

    Cheers

    Guillermo

  • Profile Image
    JotForm Support

    Answered by EltonCris on July 19, 2013 at 04:03 PM

    @HukaTx 

    Unfortunately that's not possible. That's how matrix tools are formed in the spreadsheet since we also suport matrix with checkbox/radio button options. We also suggest to avoid altering any columns/rows in your spreadsheet to avoid the integration to break. Like Guillermo, the best way to achieve that is to create a separate sheet then copy the data from the original sheet using formula to avoid further issues.

    Thanks!