I have a button on a Report layout that serves as a nicer-looking checkbox, so it shows up next to each entry in the report, and I have the icon conditionally formatted to change colour when a certain field is true for that record.
However, after I click the button for one record, the hovering no longer works for any of the other records.
I've tried a number of things, including refreshing the object, refreshing the window, going to another field/object. The closest I got to a solution was for the activated script to go to another layout and back, but then this sometimes caused summary fields to disappear on the layout, so then I added a Refresh Window step, which helped that problem, but then the user loses their scroll position. At this point I gave up and removed all these cluttering steps.
Surely there must be some way to do this?
Thanks in advance.