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?
CONCAT('<a href="https://yoursaleforceurl.com/', `your opportunity field name`, '"&target="_blank">', `your account name field`, '</a>')
Can anybody help @kith_howes with their question?Thanks!
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.
Hi kith.. could you please explain in detail.. thanks
Create a Beast Mode field, and use the below...update with your company information:
CONCAT('<a href= URL',`Id`,' target = new> TEXT </a>')
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.
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:
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?