Filtering options for linked records


#1

I would love for there to be a way to filter out the options that appear when linking a record. For example, if I have a table for monthly events and a separate table for RSVPs (with a form view to RSVP), I would want to be able to link to an event record to associate that person’s RSVP with that event. But if an event has passed, it will still show up in list of available records to link, both in the grid view and form view. I would love to be able to filter by a checkbox (event completed) or filter by a date field (everything today or in the future).

Thanks!