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

    How can I display only submissions that include a certain value?

    Asked by JasminChang on October 11, 2013 at 03:06 AM

    Hi there, 

    Is there a way to display only submissions that have a certain value in a specific field?

    For example, here is my jotform: http://jotform.co/form/32827415871863

    I'd like to be able to isolate all the submissions that have a specific screening date and export them as an excel spreadsheet or PDF document. 

     

    What's the best way to do so?

     

    Many thanks,

    Jasmin

    Page URL:
    http://jotform.co/form/32827415871863

    Submissions JotForm excel thanks
  • Profile Image
    JotForm Support

    Answered by EltonCris on October 11, 2013 at 04:01 AM

    Hi Jasmine,

    I think this is similar to this: https://www.jotform.com/answers/278139

    To hide empty fields, just click the submission settings icon then check "Auto Hide Empty Fields".

    Thanks!

  • Profile Image

    Answered by JasminChang on October 11, 2013 at 11:48 AM

    Hi Elton, 

    Thank you - however let me clarify my question. I don't want to hide specific fields, I'd like to hide specific submissions. To explain what I mean, under the cog settings, you can limit submissions by time frame so that only certain submissions show up. Similarly, I'd like to limit the submissions that show up based on the value in a certain field. i.e. I only want to export submissions that have "10/13/13" in the "screening date" field. Is that possible? What's the best way to do so?

     

    Many thanks,

    Jasmin

  • Profile Image
    JotForm Support

    Answered by ashwin_d on October 11, 2013 at 01:38 PM

    Hello Jasmine,

    If I understand your requirement correctly, you want to download submission records which has certain value in one of the column. Is that correct?

    We have a search feature which you can use. It will be something very similar to your requirement but will search for texts in all column instead of one.

    Here are the steps:

    1. Go to "My Forms" 

    2. Select your form.

    3. Click on "Submissions"

    4. In the submission page scroll down to find the search box which is just below the submission grid:

    Here you can write your desired text and the submissions will be filtered accordingly.

    I am not sure how helpful it will be but according to me this is the best possible solution available currently.

    Hope this helps.

    Thank you!

  • Profile Image

    Answered by VIPMediaCo on May 24, 2014 at 08:54 PM

    I have a similar question, however when I do the steps provided, it is still exporting all submissions. How do I only export the submissions that show up after I clarify the "search" area?

  • Profile Image

    Answered by ASRA on May 24, 2014 at 10:04 PM

    I don't think you can do what you want in Jotform itself.

    However if you have all the submissions in an Excel report you can use an Excel filter to view only those that match a specific criteria.

    A slightly hackier way would be to sort the Exceel sheet based on the column you want, which would make it easy to then delete (or hide) the submissions you don't want.

    Good luck.