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 on the Submissions Page)
Follow the steps below to create a Grid Listing Report:
- On the My Forms page, click the form to select it.
- Click the Reports button at the top.
- From the Reports menu, click Add New Report button.
- Select Grid Listing on the “Create a new report” modal pop-up.
- Next will be the Grid Listing report setup page, which is divided into three sections:
- Report Name – type the name of the report that will be shown under the Reports menu on the My Forms page.
- Fields – include or exclude fields and other information such as Submission ID, Submission Date, or IP address.
- Report Configurations – enable or disable additional report settings to your preferences:
- 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 the maximum height of each row on the grid table.
- Click the Create button at the bottom to finish the setup.
- 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 copy that link. There is also the iFrame embed code that you can copy to embed the report to your website. The Open Report button will open the report on a new browser tab.
- Click the close (X) icon at the top-right corner to close the pop-up.
Send Comment:
35 Comments:
hola estoy haciendo un reporte de resultados de imanges, pero al hacer mi gráfica no sale la imagen, en vez de eso me sale widget la descripción la imagen.. ayuda porfa
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
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
But I still get a raport whit all the answers, from every day! I only need the last updated answer
why there is no report configuration to set auto-fit grid in my jotform?
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."
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?
Link sharing error grid report,
according to what is seen in this image:
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
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
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
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.
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.
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
How do I create a report for a "orderable list widget" question?
happy to work with d'où
Thank you. Is it possible to enlarge or reduce the width of the columns in a grid report? How are the default widths determined?
how to calculate a field/column total value?
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.
Can I change the font size of the report? The text is rather small for some viewers.
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.
so expensive,,
jotform can do this ?
you have all Database to make a result and tracking...
again you find the most complicated way to explain and install things.
All that is needed is a one click installation.
How can I customize the Grid Listing Report.
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:
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).
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?
I have the page listed under "more" under the name "test."
Can I change the width of a column?
Can I edit the submission from here ?
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:
Thank you
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?
how to insert a number (№) in the grid listing ?
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?
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
I have clicked my form and then "Report" but nothing seems to pop up. There are no changes to anything. Why is that?