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.
Is there a way to download an entire Grid Report without copying it page by page?Asked by adatshalom on September 15, 2014 at 06:36 PM
Because of a Table response we have in our form, the Grid Report has a display with each column of the table displaying in a cell, exactly how we would like to see it (and thus saving us mucking around with Excel). However, the only way I can see capturing this (to copy back into an Excel spreadsheet) is to copy each page of the displayed report into the spreadsheet, one by one. Not a huge task, but just wondering if I am missing something easier.
If you download the submission to Excel, it will assign a separate column for the matrix column/cell.
is this not what you want?
OR you need them to be in single column only in Excel...
Please clarify and I'll try figure out a suitable workaround for your requirement.
No. If you view the Grid Report below, you will see that it merges the responses to create a two-column merged column under the heading "Yizkor book entries". That is the critical column--we want to download a report in this format in one go. Right now, I can copy and paste each page of the Grid Report as it appears on the website into Excel, but I was wondering if there was another way to get all the results in this format.
I'm sorry but only Grid Report supports displaying matrix table in that format. It is different when you download the submissions report to Excel or CSV. It is because the submissions are generated as text string. Unfortunately, there's no available workaround for that as far as I know only except if you copy them manually to your Excel. :)