JotForm User Guide / Reports /

How to Create a Grid Listing Report

How to Create a Grid Listing Report

Grid Listing is useful in several ways - A classic example is the ability to show the submissions on your web page right after a user hits the Submit button. In the generated grid list you can do the following:

🔘 Rearrange the order of the columns in the table by dragging the column headings.

🔘 Make the grid larger.

🔘 Add/remove column fields.

🔘 Sort ascending and descending options per column.

🔘 Search for submissions (similar to the Search Feature in the Submissions Page)

Follow the steps below to create a Grid Listing Report:

1. Go to the MY FORMS page.

2. Select the form you want to generate a report from.

3. Click the Reports ▼ menu.

4. Then click Add New Report.

5. Select Grid Listing on the Create a new report modal pop-up.

6. Next will be the Grid Listing Report setup page, which is divided into 3 sections.

(a) REPORT NAME. Type the name of the report that will be shown under the Reports ▼ menu on the MY FORMS page.

(b) FIELDS. Include/exclude fields or other information such as Submission ID, Submission Date, and/or IP address.

(c) REPORT CONFIGURATIONS enable/disable additional report settings to your preference.

🔘 Password protection - An optional but added layer of security.

🔘 Display photo instead of a link - Enable this if you want to show the images uploaded on your form instead of just showing them as a link.

🔘 Display images in a modal window - When someone clicks on an image in the table, it will be presented as a modal popup (or a lightbox as shown below).

🔘 Show edit URLs - With this enabled, a new column will be added to the table that will show a link to edit the respective submission.

🔘 Auto-fit grid report to window - When enabled, the entire grid will automatically fit itself to the size of the browser window.

🔘 Grid Cell Maximum Height - Set a maximum height of each row on the grid table.

Click the Create button at the bottom to finish the setup.

7. After clicking the Create button, you will be prompted that the Grid Listing Report is ready. On the same pop-up, you will see the link to the Grid Listing Report that you created and a button to (a) copy that link. There is also the (b) iframe embed code that you can copy to embed the report to your website. (c) The Open Report button will open the report on a new browser tab.

Click the X at the top-right corner to close the pop-up.

Example result:

Comments and suggestions are welcome below. If you have a question, post it in our Support Forum so we can assist you.

Contact Support:
Our customer support team is available 24/7 and our average response time is between one to two hours.
Our team can be contacted via:
Contact JotForm Support: https://www.jotform.com/contact/

Send Comment

32 Comments...

  • samchia

    Hi

    When I create a Grid Report and share it out, all the images captured in the form (via Camera Widget) cannot be seen. It seem that the Photo has a URL path to my account. Is there a permission issue? The whole point of sharing the submission with a password is to be able to see the form submission with images

    Cheers
    Sam

  • Jim

    Hi,

    Can a report be exported in excel with the form questions to run down the cells & not across the columns.
    e.g headers as follows;

    Store_Name,Review_date,Review_Question,Review_Question_Result
    Test Store A,09/11/2020,Floor Clean,Yes
    Test Store A,09/11/2020,Bench Clean,Yes
    Test Store A,09/11/2020,Door Clean,No
    Test Store B,09/11/2020,Floor Clean,Yes
    Test Store B,09/11/2020,Bench Clean,Yes
    Test Store B,09/11/2020,Door Clean,Yes

    Thanks Jim

  • René Bergmann

    But I still get a raport whit all the answers, from every day! I only need the last updated answer

  • ayanaresort

    why there is no report configuration to set auto-fit grid in my jotform?

  • sweetestaddiction

    I copy and paste the iframe code to my website but it does not show up on mobile.
    It says "⚠️ ERROR You're not authorized."

  • sweetestaddiction

    When someone leaves a review on my review form, will it automatically post on my website if I copy and past the short short code to my website or do I need to copy and past the iframe code to my website to make submissions appear for public view on my website?

  • Marcos Leiva

    Link sharing error grid report,
    according to what is seen in this image:

    https://drive.google.com/file/d/1CN19wRWaKEYwLWOPTYFAoWnegm0fz0E4/view?usp=drivesdk

  • Jalal

    Hi

    Thank you for your previous responses

    I have a digital marketing business. I will provide my clients with the forms/survey required. The question here how can i create a form for them and give them access to the results/data collected from the form without the need to export the file myself and send it manually to them every time.

    Also can i prepare a survey form for a specific period only. And client will be able to get the results without referring to me every time.

    2if i want to amend the form later. Will all previous data still be there. Or it will prepare a new data report other than the 1st one.

    Regards
    Jalal

    Regards
    Jalal

  • lemundibu

    Hello,

    Is it possible to get the grid report in a spreadsheet.
    I want to display the pictures and not a link.


    Is it possible ?


    Regards

  • MGGSOnline

    Is it possible to create a report where the results appears vertically (instead of horizontally)?
    i.e. The data appears like this:
    Name 1, Activity 1
    Name 1, Activity 2
    Name 2, Activity 1
    Name 2, Activity 2

  • gwylie

    When I utilize the "edit submission" and return to the original entry, fields that I have hidden are visible. How can this be prevented? The hidden fields are not visible on the original form.

  • vashishtb

    I have created a Grid report, I can view it fine when logged in, however I have shared this with a colleague and she can not view the data. She enters the password, the spinner spins for a while, however the data never loads. I have the same issue when I am not logged in.

  • golphnut

    Can I create a report for all my forms? When I click on all of my forms, the Report option is not available.

    Thank you

  • tinavupham

    How do I create a report for a "orderable list widget" question?

  • bouka fotio Gaëlle

    happy to work with d'où

  • larback

    Thank you. Is it possible to enlarge or reduce the width of the columns in a grid report? How are the default widths determined?

  • kokangboys

    how to calculate a field/column total value?

  • preacherswife

    How do I add a name, email address and submissions to a grid listing as well as columns to separate the headings? All I have so far is a box that says submissions.

  • RedDogRecords

    Can I change the font size of the report? The text is rather small for some viewers.

  • CoordinatorLiaison

    There are empty columns being generated between field columns. How do I eliminate these? They are causing my grid to be too wide for useful viewing.

  • GoBlueHorizon

    How can I customize the Grid Listing Report.

  • bwf

    Might be a bug. When using grid listing of a date sorted list of "event" til grid report don't seem to handle dates correct when sorting after dates. I have used the date format "yyyymmdd". When "sorting" in the grid the date 2014/05/10 will be shown after the 2014/06/26. This dosen't make any sence. I have tryed replacing the date field in the form (and re-submit the submissions).
    Even more strange is that HTML table does sort the dates correctly, but you can't define the table to show without scrollbars.
    The calender report option could also be a solution. But the calender can only show all dates, and not just dates with a submission.
    The link to my even calender is:
    http://dit.dk/partnerkalender/

  • plumileds

    Can the grind be limited to specific dates or other criteria? I would like setup reports that would display just the past 24 hours data or data from a specific column if populated (no blanks).

  • preacherswife

    I am using Weebly and have edited my grid box and then I publish it. It comes back up with only part of the comments showing whereas before in edit mode, it was showing all of the comment.

    Also, how does another person go about leaving a comment?

    www.communitychapelbaptistchurch.org
    I have the page listed under "more" under the name "test."

  • stonestorm

    Can I change the width of a column?

  • Joe

    Can I edit the submission from here ?

  • franceguide

    Hi, I have created a grid report but the grid doesn't show up. Only if I am log in Jotform that the grid shows.
    Here's the link to the report:
    http://www.jotformz.com/report/30202567591047/?

    Thank you

  • Atlglittergirls

    can i have the scroll bar of the grid on the top instead of bottom and fixed in postion so it can still be visiblewhen the page is rolled down?

  • stonestorm

    how to insert a number (№) in the grid listing ?

  • dm257

    Having trouble enabling password protection. I click the password box and it never asks to enter a password for access. Form generates and gives me the link. But, when posted it opens online without a passowrd. Any suggestions on getting this to work?

  • hawthornmc

    Hi, I don't seem to be able to create more than 2 visual questions at once. Please could you let me know if this is possible? Many thanks

  • pagination

    I have clicked my form and then "Report" but nothing seems to pop up. There are no changes to anything. Why is that?