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

  • Profile Image
    HukaTx
    Asked 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!

  • Profile Image
    guilledutra
    Answered 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
    EltonCris
    Answered 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!