How do you create a drill path that hyperlinks to an Opportunity inside Salesforce?
I have a Domo card that shows Top 5 deals, I'd like to be able to click on the opportunity and have it open that Opportunity inside of Salesforce. How can I do this?
Comments
-
CONCAT('<a href="https://yoursaleforceurl.com/', `your opportunity field name`, '"&target="_blank">', `your account name field`, '</a>')
4 -
0
-
re: kith_howes solution
I use this all of the time within a BeastMode calculation. Works great. Makes Domo not only informative, but immediately actionable.
0 -
Hi kith.. could you please explain in detail.. thanks
0 -
Create a Beast Mode field, and use the below...update with your company information:
CONCAT('<a href= URL',`Id`,' target = new> TEXT </a>')
Where:
- URL = everything including and between the https:// and the .com in your Salesforce URL bar
- Id = the field in your dataset that is representative of the Salesforce Opportunity, Account page, etc...what you're trying to link to...it would look something like: 0063200001olpyv
- TEXT = The words to show up in your Domo table, for users to click on for the link...I use "SF Oppty" for an Opportunity page
I don't think I can break it down anymore for you - it's pretty easy once you can break down the "science" behind it.
1 -
Thanks for sharing this! I tried to create a field using your code to link to opps in SFDC and it doesn't seem to pull the SFDC id into the resulting url, here is my beast mode:
CONCAT('<a href="https://xxx.salesforce.com/"',`Id`,'target="_blank">',`Name`,'</a>')
Id - SFDC id field
Name - opportunity name
It is creating a field with the correct name but the link is "https://xxx.salesforce.com" everywhere, so it links to our SFDC instance home page, not actual opportunities.
What am I doing wrong?
0
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 194 Visualize
- 253 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 174 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive