Is it possible to filter a Jotform Report Grid that I embed on my webpage by 'upcoming dates' and 'past dates'?

  • Profile Image
    Swiftec
    Asked on February 16, 2021 at 04:02 PM

    Hello

    I'm trying to create a page where my submission list is filtered by dates and embedded into a page on my website called "Future deliveries" where the report is filtered to only show coming appointments from today's date, and "Past deliveries" on another page where the report is filtered to only show appointments up until the day before today's date.

    Is there a way to sort submissions like this in Reports?

    I want to create an HTML- or Grid Report with these filters so that I can show my customers different lists when they click future or past deliveries on my webpage.

    How should I go about creating this? is it better to send everything to MySQL and create filtered grids from the database? I just figured everything would be so much easier if it was possible from within JotForm.



    This is the form:

    https://eu.jotform.com/203424740845353


    This is the grid table:

    https://eu.jotform.com/tables/203424740845353


  • Profile Image
    Katherine_W
    Answered on February 16, 2021 at 08:43 PM

    Hi there,

    Happy to help!

    Currently, you can only use filters in our Visual Reports. Here's how-to-use-visual-report-filters.

    If a Visual Report is not what you're looking for, you can certainly use your SQL database workaround.

    Please let us know if we can assist further.