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

    Can I create a Grid Report with filter or a condition to display only certain submissions?

    Asked by afcpool on March 31, 2015 at 06:35 PM

    I didn't ask this question, but these are the same words I would have used to ask the one that I have, which your answer does not address:

    Can I create a report which only includes submissions that have a certain field completed? That is, I know I can create a report limiting the columns I to the ones I care about for a certain purpose, but I get all submissions reflected. Obviously, once I download to excel, I can hide or delete all lines with blank data, but I cannot do that with a Grid Report. Is there some way for conditional inclusions?

  • Profile Image

    Answered by Carina on March 31, 2015 at 06:45 PM


    Unfortunately it is not possible to hide empty fields on grid reports, but you can select the fields while creating the report:

    But please let us know more details of your needs so we can try to find a solution that suits you.

    Let us know if we can assist you further.   

  • Profile Image

    Answered by afcpool on March 31, 2015 at 11:30 PM

    Thanks; I had not been optimistic.

    We have a single form gathering lots of information. However, respondents don't need to complete all the fields, only some of the fields need to be seen by different members of our organization. So, when I created a grid report on our registration form just for Swim Lessons, I just would like to see submissions where someone clicked on swim lessons registrations. 

    I had been hoping that you might have a function akin to what you do for customizing notifications, so that I could get a report of all submissions that met a certain condition.

  • Profile Image
    JotForm Support

    Answered by ashwin_d on April 01, 2015 at 09:13 AM

    Hello afcpool,

    You seems to be looking for a customized report with a filter feature. Unfortunately, it is currently not possible to create a report with filter.

    Let me send a feature request to our back end team. We will get back to you as soon as we have any update from them.

    Thank you!

  • Profile Image

    Answered by NHS24-LPE on May 16, 2017 at 10:53 AM

    Could the filtering options that are available via the Visual Report builder be made available for Grid Reports? I have a need to be able to provide data that is filtered in particular ways to different people and so would create a filtered version of the report for each of them. 

    The Visual Reports builder is almost totally useless and so I cannot use that to meet my needs. The grid reports are excellent but I cannot show all of the records to all of the people.



  • Profile Image
    JotForm Support

    Answered by ashwin_d on May 16, 2017 at 11:42 AM

    Hello Stuart,

    This is a very old thread. I have moved your question to a new thread so that we can address it separately. You will be answered in the following thread:  https://www.jotform.com/answers/1146002

    Thank you!