User Guide

 

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. On the modal popup, choose GRID LISTING then click NEXT.

6. The next page will show a number of options to further customize the Grid Listing Report.

A. FIELDS - Include/exclude fields

B. PASSWORD PROTECTION - An optional but added layer of security

C. 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.

USE MODAL TO DISPLAY IMAGES - When someone clicks on an image in the table, it will be presented as a modal popup (or a lightbox as shown below).

D. SHOW EDIT URLS - With this enabled, a new column will be added to the grid that will show a link to edit the respective submission.

E. AUTO-FIT GRID REPORT TO WINDOW - When enabled, the entire grid will automatically fit itself to the size of the browser window.

7. Copy the generated GRID LISTING REPORT URL or the EMBED CODES (whichever you need) then click CLOSE when you're done.

Example result: https://www.jotform.com/grid/72652472960057

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

Send Comment

19 Comments...

  • 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?

  • ord_flt_svc_ramping

    Is there any way to change the column headings on the grid report? For example, a question might ask "Was the jetbridge clean when you arrived?" Instead of that question being the heading, can I change it to read something else, like "Clean JB"?

  • 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?