Forum Discussion
I can describe a problem and a solution I came to which may be relevant to your use case.
In my use case we have different dashboards by Role, but sometimes the user will be in multiple Roles and of course they can't land on multiple dashboards at the same time, they can only land on one of them.
So how do we dynamically provide dashboard links to take them to their alternate dashboards based on the roles they are currently in?
So I made a table of Dashboards with the Role Name and a URL to the Dashboard and the Role ID#. Then I made a report with a single column, which was the Hyperlink to the Dashboard.
"<a href=" & [Dashboard URL] & ">" & [Dashboard Name] & "</a>"
Then I created a formula checkbox field called [OK to View Dashboard?] to dynamically calculate if the Current User was in that Role ID#
Contains(ToText(UserRoles("ID")), [Dashboard Role #])
or
Contains(ToText(UserRoles("ID")), "12") // 12 is the Role ID for Admin
... and set either Permissions or a report filter to limit the records to those where [OK to View Dashboard?] is checked
Then I put that report on every dashboard. The effect of that is that users have a little single column report on their dashboard that would take them to any other Dashboard for a Role they are currently in, and the Admin will see all the links.