Document Trigger Select in Field on Hierarchy Path
All, I have a dashboard where I'm trying to set up a document trigger to select the OSUser from the Hierarchy Resource Path column.
My action is a Select in Field with the Field = to Resource Path and the Search String is =right(Lower(OSUser()),len(OSUser())-10)
I lifted the Search String from a different dashboard and it doesn't work here. How do I set up a Document Trigger to filter the dashboard based on the OSUser being included somewhere in the Hierarchy Resource Path?