Would like to be able to customize the rows that show on a Grid Report

  • Profile Image
    calhouncollege
    Asked on June 26, 2017 at 05:47 PM

    I know I can select which fields (columns) show on a grid report but is there a way to have it so that an entry does not show once date entered has past?

    We have a page that shows entries for outside scholarships for our students.  The page is driven by the submissions for outside entities that submit a scholarship opportunity and is populated through a Grid Report.  This is by far better than the old way in which someone had to manually enter each item for display.  However, the person that handles the page and deletes the expired dates is leaving so there will be no one who can delete the expired entries.  I was wondering if there was a way that these could automatically drop off the list once the date is past?  

     

    The Jotform in question is https://form.jotform.com/10262853606

    The grid is displayed on http://webnt.calhoun.edu/Scholarships1.html

     

  • Profile Image
    Nik_C
    Answered on June 26, 2017 at 07:32 PM

    If you meant to hide certain entries from the Grid report after a certain date, I'm afraid it is not possible, you could only disable form based on certain date, here is how: https://www.jotform.com/help/137-How-to-Limit-Submissions-in-a-Form but from what I understood you want to hide those submissions from report afterward right?

    Unfortunately, we don't have a logic that will work in such way in grid report.

    If I misunderstood your question please let us know.

    Thank you!