How do you create a drill path that hyperlinks to an Opportunity inside Salesforce?

kith_howes

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?

kith_howes

CONCAT('<a href="https://yoursaleforceurl.com/', `your opportunity field name`, '"&target="_blank">', `your account name field`, '</a>')

 

kshah008

Hi all,

 

Can anybody help @kith_howes with their question?

Thanks!

byusteve

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.

Unknown

Hi kith.. could you please explain in detail.. thanks

Echelon

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.

IrynaZ

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?