Grid listing report: ability to filter based on data in a field?

  • ACMcommunity
    Asked on February 21, 2019 at 9:01 PM

    Hi 

     

    I really like the grid listing report to use in an iframe. But I need to filter it so I can create different reports based on certain information. For example only show entries with GOLF under type of sport. I know you can't do it with the inbuilt function but is there widget that anyone knows about? Or is this something the development team can look at? It would be an amazing function.

     

    Thanks

  • Jed_C
    Replied on February 21, 2019 at 10:04 PM

    It's not currently possible, but you can integrate your form with Google Spreadsheet and create another sheet that only displays certain field. For example, sheet #1 is the original report that includes all fields. On sheet #2, you have only copied the fields that you want to show from sheet #1 to sheet #2.

    Google sheet integration guide — https://www.jotform.com/help/228-How-to-Integrate-Forms-with-Google-Sheets 

    To pull data from other sheets, please follow this guide https://www.wikihow.tech/Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac.

    Let us know if you have any questions or if you need further assistance. 

  • ACMcommunity
    Replied on February 21, 2019 at 10:12 PM

    Thanks Jed yes I know how to do that. What I like it placing the grid in an iframe to give live updates on our website displayed in a nice format. I didn't want to put them into a spreadsheet and back on to the website. 


    All good.

  • Jed_C
    Replied on February 21, 2019 at 10:20 PM

    Thanks for the response. What I can do for now is submit a feature request to our L2 team so they can add it to their potential features list.

    In case this feature gets implemented, you will be notified in this thread.