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

    Form submissions: Searching a term displaying incorrect number of submission count

    Asked by cklint on September 26, 2016 at 11:56 AM

    When searching our database which is currently 27 pages long... we will do a search... for this example say we are looking for "table"

     

    We search for table and 6 pages of results come back, but as you page through the results.. only pages 1, 2 and 3 show up. It won't advance to page 4 and instead just shows a blank page. 

     

    We really need to see all the results. Thanks for your help. 

    Page URL:
    https://www.jotform.com/grid/61183843659061

    Screenshot
    table thanks 3 all
  • Profile Image
    JotForm Support

    Answered by Kiran on September 26, 2016 at 01:35 PM

    I am able to replicate the issue at my end with your form submissions. However, I have also tested it further with an excel report of the submissions and found that the result is the total number of cells.

    The same count is being displayed in the submissions when we search for a term and each page is supposed to display only 25 submissions which is displaying 5 pages.

    However, the term table might have repeated more than once and the actual count of the submissions can be less than 124. And so it is displaying the results in 3 pages only and the rest are blank. 

    Let me forward the issue to our backend team to rectify the count and display the actual submissions count. Once we have any update in this regard, you'll be posted here.

    Thank you!

  • Profile Image
    JotForm Support

    Answered by paulsimpson on September 27, 2016 at 06:40 PM

    Hi

    This problem has been fixed.

    It was happening because of a bug which counted the number of times the word 'table' occurred in your submissions instead of just counting the number of submissions which contained the word 'table'

    The actual count as of now is 58 submissions and your grid is now showing the correct number.

    Regards

    Paul

  • Profile Image

    Answered by cklint on September 28, 2016 at 03:09 PM

    Appreciate the quick response and fix!