- HukaTxAsked 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!
- JotForm SupportguilledutraAnswered 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.
- JotForm SupportEltonCrisAnswered on July 19, 2013 at 04:03 PM
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.