JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Filters form - only people who did not match any file sentAsked by cursocapcar on November 12, 2014 at 06:22 AMGood 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 .... ?
Can you please tell us where this filtering should take action?
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
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.