Need script to filter records from a portal
I'm hoping someone can help me or at least guide me in the right direction. I have a form that is pulling personnel names from a table with the following fields: Full Name, Added Date, Removed Date. I need to filter these personnel entries based on the Removed Date. For example, If a person was added to a project last year, but now has been removed from the project as of today, I would like that name to not appear in the form. What would be the best way to accomplish this? And by best, I mean easiest.