Portal Filter with global field
I using a global field to filter portal records
The global field is a drop down menu with Open or Closed as the only options.
Each record has a status field (open or closed). I can make the portal filter based on the global field, but is there a way for the same portal to show me ALL the related records, not just the ones that match the status field?
In a nutshell, I would like the user to be able to use the drop down to see all the related records (regardless of status), only records with a status of open or only records with a status of closed?
My current solution is buttons that would switch between layouts with either the globally filtered portal or no filtering, but I'm trying to cleanup the layouts and get rid of some of the buttons.
If you add "All" to your drop down's value list, your portal filter can be updated to be:
Yourtable::globalField = "All" or YourTable::GlobalField = PortalTable::StatusField