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.


  • Profile Image

    Visual Report Builder: Grid list is limited to 100

    Asked by TJCApaches on April 17, 2016 at 11:08 PM
    Is there a way to filter the HTML-Table-Listing-Report? (Or another grid report) I have been using the Visual Report builder so that I can filter the results, but I am also limited by the 100 submission issue. 
  • Profile Image
    JotForm Support

    Answered by Charlie on April 17, 2016 at 11:26 PM

    You can check the different JotForm reports here: https://www.jotform.com/help/326-How-To-Create-Form-Reports-in-JotForm 

    In the HTML Tabling Listing Report and Grid Listing Report, you have the up and down arrow keys that allows you to sort the submissions in ascending and descending order. However, you cannot filter specific data. 

    If you would like, you can also integrate your form to Google Spreadsheet, here's a guide about it: https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet. With Google Spreadsheet, you can create basic to advance report presentations, with more advance data analysis. 

    I could also forward a feature request to our developers to make Visual Report builder improve the limit in the grid to more than a 100. But I am not quite sure what specific filter function you would like to have. Perhaps you could provide us more information on it so that I can escalate it better.

    We'll wait for your response.

  • Profile Image

    Answered by TJCApaches on April 17, 2016 at 11:44 PM
    This is the form.
    https://form.jotform.com/53444288427967
    I want to filter the submission report by the “Professor” field so that each professor only views her submissions.
    ...
  • Profile Image
    JotForm Support

    Answered by Charlie on April 18, 2016 at 12:15 AM

    I see you are already applying the filter option in Visual Report builder.

     

    Unfortunate, the grid table in the Visual Report builder is limited to only 100 submissions. I'll forward this to our developers to see if they can make improvements on it. However, I'm unable to guarantee that the change will be implemented anytime soon.

     

    For the meantime, aside from the Google spreadsheet workaround I mentioned earlier, you might need to create Visual Reports with filter both in "Professor" and "Submission Date" if you are limited to 100 submissions. Something like this:

    Let's say you have 100 submissions from January to March of 2016, you then need to create another visual report with a submission date range of April to June of 2016 for submissions number 101 and up.

    To learn more about filters, you can check this guide: https://www.jotform.com/help/281-How-To-Use-Visual-Report-Filters 

    We will update you on this thread as soon as we hear any news from our developers. Apologies for the inconvenience.

  • Profile Image

    Answered by TJCApaches on April 18, 2016 at 12:43 AM
    Thanks. I didn't think about adding the submission date filter.
    Sent from Outlook Mobile
    ...
  • Profile Image
    JotForm Support

    Answered by Charlie on April 18, 2016 at 02:02 AM

    No worries, I'm glad it helped you somehow. I see that the ticket I escalated has now been assigned to one of our developers. In case we hear any news about the issue on the 100 limit in Visual Report Builder, we'll update you immediately here. Thank you for your understanding.

  • Profile Image

    Answered by TJCApaches on April 18, 2016 at 10:43 AM
    The submission date filter didn’t seem to help. The latest I can get to show up is March 30. And I know there are some submissions for April.
    ...
  • Profile Image
    JotForm Support

    Answered by KadeJM on April 18, 2016 at 01:17 PM

    Thank you for the update about that and we can understand how that might seem a bit frustrating.

    I can confirm that Charlie has sent notice of the problem to our developers and we already have it assigned to be looked at as soon as possible so we'll update you as soon as we can once it's fixed.

  • Profile Image

    Answered by gilbi on April 27, 2016 at 10:11 AM

    Bonjour 

    Is the 100 limit issue resolved now ?

  • Profile Image

    Answered by TJCApaches on April 27, 2016 at 10:18 AM

    No, the last submission displayed is still in March.

    https://www.jotform.com/report/61078827367062

     

  • Profile Image
    JotForm Support

    Answered by Charlie on April 27, 2016 at 10:41 AM

    @gilbi

    Unfortunately, the issue about the 100 limit in the grid list in the Visual Report builder is not yet fixed, I have opened a separate thread for you, you can refer to this link instead: https://www.jotform.com/answers/827559. Apologies for the inconvenience.

  • Profile Image
    JotForm Support

    Answered by Charlie on April 27, 2016 at 10:56 AM

    @TJCApaches

    Apologies for the inconvenience. I see you are using the filter option "Last 30 days", may I know if you have tried setting a custom date range instead?

    If you disable the filter "Professor is Jodi Seal", you can see that the submissions in April will be displayed. There might be a problem when trying multiple filters at the same time.

    I also checked the status of the bug report, I'm sorry to say that it is still unresolved by our development team. We will hear from them directly about this. Apologies.

  • Profile Image

    Answered by TJCApaches on April 27, 2016 at 07:17 PM

    I tried the custom date range option as well - no luck. I need the Jodi Seal filter because I am trying to create reports for each professor. The date is only there because of the 100 submission limit.

  • Profile Image
    JotForm Support

    Answered by Chriistian on April 28, 2016 at 12:38 AM

    Sorry for the inconvenience. Our development team is still working on this issue. Rest assured that once this issue has been fixed we will inform you via this thread. Regards.

  • Profile Image
    JotForm Support

    Answered by paulsimpson on April 29, 2016 at 08:04 PM

    Hi

    The 100 limit on visual report grids has now been removed. Apologies for any inconvenience caused.

    Regards

    Paul