Here's How to Embed a Card into a Salesforce using Visual Force and filter the card by AccountID
Did you really figure out how to do this Canio?
And, I'm sharing this with you b/c it's been something that has been bugging me for the better part of 4 years. I appreciate all the help I have gotten from various people to help finally figure it out. I truly hope this is helpful to you.
See my reply.
Good luck!!!
Best Answer
-
Here is the code you enter into Salesforce Visualforce page. Feel free to play around with the margin and height. The below dimensions are for a side column that I found worked for me.
A few FYI's that you should take note of.
- Make sure you use the Domo name for the Column you're passing the Saleforce ID value into
- Make sure that you use the Saleforce naming convention for Account.ID in Value (or Contact.ID, Opportunity.ID, etc)
- What finally worked for me was putting the {! } between the %22 %22 like this: %22{!Account.Id}%22
- In the Domo Card I did NOT put the Account ID as a filter. When I did, the VF code wouldn't work.
<apex:page standardController="Account">
<iframe src="https://thankmelater.domo.com/embed/card/xxxx5086?enable=title&pfilters=[{"column":"AccountId%22,%22dataType%22:%22STRING%22,%22operand%22:%22IN%22,
%22values%22:[%22{!Account.Id}%22]}]
" width="400" height="250" marginheight="0" marginwidth="0" frameborder="0" scrolling="yes"></iframe></apex:page>if you aren't sure what the datatype is then you can always press f12 on your browser, go to the Network tab, find a "cards" box, and expand the filters carrot until you see the data type of the column you want to filter on.
In this case I looked up AccountId and found it was string. Don't worry about filterType: "LEGACY", it did nothing for the filtering in visualforce
Here's what the visualforce code should look like in your SF instance.
And here's what a card looks like on a lightning page. In this case it's a smaller card, but I'll play around with the card types now that I have it working
1
Answers
-
Here is the code you enter into Salesforce Visualforce page. Feel free to play around with the margin and height. The below dimensions are for a side column that I found worked for me.
A few FYI's that you should take note of.
- Make sure you use the Domo name for the Column you're passing the Saleforce ID value into
- Make sure that you use the Saleforce naming convention for Account.ID in Value (or Contact.ID, Opportunity.ID, etc)
- What finally worked for me was putting the {! } between the %22 %22 like this: %22{!Account.Id}%22
- In the Domo Card I did NOT put the Account ID as a filter. When I did, the VF code wouldn't work.
<apex:page standardController="Account">
<iframe src="https://thankmelater.domo.com/embed/card/xxxx5086?enable=title&pfilters=[{"column":"AccountId%22,%22dataType%22:%22STRING%22,%22operand%22:%22IN%22,
%22values%22:[%22{!Account.Id}%22]}]
" width="400" height="250" marginheight="0" marginwidth="0" frameborder="0" scrolling="yes"></iframe></apex:page>if you aren't sure what the datatype is then you can always press f12 on your browser, go to the Network tab, find a "cards" box, and expand the filters carrot until you see the data type of the column you want to filter on.
In this case I looked up AccountId and found it was string. Don't worry about filterType: "LEGACY", it did nothing for the filtering in visualforce
Here's what the visualforce code should look like in your SF instance.
And here's what a card looks like on a lightning page. In this case it's a smaller card, but I'll play around with the card types now that I have it working
1 -
-
@J_Tsang for sure
1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 600 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 685 Beast Mode
- 43 App Studio
- 38 Variables
- 655 Automate
- 170 Apps
- 438 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 383 Distribute
- 110 Domo Everywhere
- 267 Scheduled Reports
- 6 Software Integrations
- 111 Manage
- 108 Governance & Security
- 8 Domo University
- 25 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive