Popup Box as Report Filter
I am using a List View Layout to filter and report on employees depending on certain criteria.
The criteria is chosen by a popup menu in the header. They have the choice of Showing All, Invalid, Valid, Missing, or Expired. A script trigger On Object Modify is set and the script performs a find or show all records based on the search criteria chosen in the popup menu.
The script works in displaying the chosen records. The problem is that the item that is shown in the popup menu sometimes displays a different selection. Option 1 is chosen, data is filtered off of option 1, but option 4 is displayed in the popup field. Choosing the selection criteria a second time corrects the issue.
I tried changing the script trigger to On Object Validate, but it had no effect. I tried showing all at the start of the script to make sure I reset the find, but that also did not do anything.
Script is attached.