AnsweredAssumed Answered

Filter Portal Records by last date dependant on another field entry

Question asked by TheaOrr on Oct 2, 2012
Latest reply on Oct 3, 2012 by TheaOrr

Title

Filter Portal Records by last date dependant on another field entry

Post

     Hi,

     What I am trying to create is a portal onto a table of responses to meeting invitations. I want the portal to show only the most recent response recorded for each attendee.

     eg. Bill Bloggs may respond on the 1/11/12 that he is attending the meeting and needs accommodation, but respond again on the 5/11/12 that he is still attending but no longer needs accommodation. Meanwhile, John Doe responds on the 6/11/12 that he is attending and needs accommodation.

     I want to record each response in a table so that we have the history of what attendees have responded, however the portal just needs to show the most recent response from each person.

     I hope this makes sense! Is there a way of filtering this in a portal?

     Kind regards,

     Thea

Outcomes