If you’ve worked with Salesforce dashboards, you’ve probably run into this limitation:
You can create a dynamic dashboard or you can set up dashboard subscriptions—but not both at the same time.
This can be frustrating when you’re trying to provide personalized data views and automate dashboard delivery via email. Out of the box, Salesforce restricts subscriptions to static dashboards. So, if you’re using a dynamic dashboard (like one that shows data for “My Team”), the Subscribe button disappears.
But don’t worry, there’s a simple workaround that gives you the best of both worlds.
The Workaround: Combine Static and Dynamic Dashboards with Smart Linking
Here’s a way to deliver a team-specific experience while still leveraging dashboard subscriptions.
1. Create Two Dashboards
- Dynamic Dashboard: Shows filtered data for “My Team” using dynamic dashboard settings (e.g., “Run as logged-in user”).
- Static Dashboard: Shows “All” data (or a summary view). This one is eligible for subscriptions.
2. Subscribe Users to the Static Dashboard
Set up the subscription for the “All” dashboard so your users get regular updates in their inbox.
3. Add a Text Widget with a Link to the Dynamic Dashboard
In the static dashboard, include a text widget that explains:
“Looking for your team’s personalized dashboard? Click Here 👉 Provide the direct URL to the dynamic dashboard. Users clicking the link will land on their personalized view.
Tips:
- Use consistent dashboard formatting so users feel like they’re in the same experience.
- Add a dashboard title or label to clearly show the user what they’re viewing: “All Data” vs. “My Team”.
Final Thoughts
While Salesforce doesn’t currently allow dynamic dashboards to be subscribed to directly, this method creates a seamless experience where users receive a summary dashboard and can easily drill into their personalized view. It’s quick to set up, scalable, and keeps your users engaged with relevant data.