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

    Filters form - only people who did not match any file sent

    Asked by cursocapcar on November 12, 2014 at 06:22 AM
    Good Morning ,I wonder if any possibility to filter only those people who did not send files , remembering that they are 4 fields can be alternative . If possbilidade to filter only those who have not sent in any field .... ?
    did not match
  • Profile Image

    Answered by Ben on November 12, 2014 at 08:55 AM

    Hi,

    Can you please tell us where this filtering should take action?

    Best Regards,
    Ben

  • Profile Image

    Answered by cursocapcar on November 12, 2014 at 11:28 AM

    are three fields that people need to insert the file, no field is required ... I need to check that people have not sent any files for these 3 fields

  • Profile Image
    JotForm Support

    Answered by Charlie on November 12, 2014 at 12:05 PM

    Hi,

    If you are looking for to make a complex filter that involves specific values or a couple of columns, I believe the feature in the "Submissions" and the "Reports" does not have this functionality. 

    This is what options we have, a "Submissions" and "Reports" option.

    A.1 In your Submissions setting, you will see a gear icon, click it and you will see the available fields you can show/display.

    A.2 Scroll down and you will see the list of submissions, you can then download it as an excel file and make the filters there.

     

    B.1 For the Reports, you can add different types of them like grid listing to where it has built in sorting functions, like ascend and descend values.

     

    If you are looking for a real time filtering and update on an excel sheet, you can use the Google Spreadsheet integration, from there you can add a complex filter just like what you do in an excel sheet.

    You can check this guide we have for Google Spreadsheet Integration: http://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet.

    I hope this helps or gives you an idea. Let us know if you need further assistance on this.

    Thank you.