Grid Report: How to filter submissions based on an answer?

  • Profile Image
    VSPC
    Asked on September 11, 2017 at 08:58 AM

    Hi, if a field on my survey is answered 'NO' or 'UNSURE' is there a way for that submission to not be displayed on the Report Grid?

     

     

  • Profile Image
    candy
    Answered on September 11, 2017 at 10:55 AM

    Unfortunately, we do not have the feature that when a field is on the survey is answered as "No/Unsure", do not display that on the Report Grid.

    Besides, you can do that by exporting submissions as excel or spreadsheet document. You can set filters to the fields in those applications and then see the submissions' columns if the answer is the one that you have set.

    For detailed information regarding exporting submissions as excel file, please check the following guide: https://www.jotform.com/help/73-How-to-Download-Form-Submissions-as-Excel-CSV-PDF You need to use excel filters for this purpose you can see in the following URL: https://www.gcflearnfree.org/excel2013/filtering-data/1/ 

    For detailed information regarding Google Spreadsheet integration, please check the following guide: https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet Also, in order to learn more about Google Spreadsheet filters, please check the following guide: https://support.google.com/docs/answer/3540681?co=GENIE.Platform%3DDesktop&hl=en 

    I hope this information will be helpful.

    Please tell us if you need any further assistance.