+ Start a Discussion
SpunkySpunky 

Need help with a Hyperlink formula

I have a custom formula field (text)

 

Formula is: HYPERLINK("/"& WhatId, "Detail Link")

 

It appears as this clickable link which takes you to the account detail page.

Detail Link

 

Does anyone know if and how I can update the formula so that instead of the static name "Detail Link", it can dynamically update to the Account Name value?


Thanks

Best Answer chosen by Admin (Salesforce Developers) 
parodagemmaparodagemma

HYPERLINK("/"& WhatId,  Account.Name)

All Answers

Steve MolisSteve Molis
Could you provide a little more information about the object that the hyperlink field is on, and the relationship that it has with the Account object?
SpunkySpunky

This field is a custom field on the task object and it was created to show the account name when the related to field is the campaign.

 

 

Mandy_in_MNMandy_in_MN

Good Morning,

 

I did something similar to what I think you are asking for using Formula Fields, and my formulas are below. 

 

We have a custom object, NSR or New Service Request, that is linked to an Opportunity.  I use the linked Opportunity to get to the Account, but in your case, you might be able to get there by linking through the Task's Contact's Account.  I would just see what connections you can find using the "Insert Field" button.  

 

I created, but don't use, the formula field that displays the hyperlinked Account.  In production, I do use one that displays and hyperlinks to the Contact that requested the opportunity.  

 

This is the formula for Account:

HYPERLINK( "https://na6.salesforce.com/" & Opportunity__r.Account.Id, Opportunity__r.Account.Name, "_self")

 

I created a similar formula for Contact, aka "Requested By":

HYPERLINK( "https://na6.salesforce.com/" & Opportunity__r.Request_By__r.Id , Opportunity__r.Request_By__r.FirstName & " " & Opportunity__r.Request_By__r.LastName , "_self")

 

 

The https should be whatever the leading information is on your Sales Force, so it might be a little different than mine.  

 

Best of Luck,

Mandy

 

 

Message Edited by Mandy_in_MN on 09-14-2009 10:20 AM
SpunkySpunky

Hi

 

It doesn't quite work because the Account name is a hidden lookup here. Thanks though, i appreciate it.

Kevin042Kevin042
Spunky,



What do you mean by 'hidden' is it hidden due to field level security or just not on the page layout?



If it is due to field level security it does not seem like you would be able to do it, however if it is just not on the layout then you should be able to.



Let me know if you have any questions.


Kevin
SpunkySpunky
This has been solved. Thanks for your comments.
RatherGeekyRatherGeeky

Hi Spunky:

Could you share what solved your problem (or mark the post as a Solution) so that those of us who are curious, or facing similar issues can benefit?

Thanks.

SpunkySpunky

I have tried to post this solution however it's on a different message board.

 

http://community.salesforce.com/sforce/board/message?board.id=general_development&message.id=33953#M33953

RatherGeekyRatherGeeky
Thanks for providing the link...  (Although it's usually good not to cross post.) But, thanks.
parodagemmaparodagemma

HYPERLINK("/"& WhatId,  Account.Name)

This was selected as the best answer
SpunkySpunky
thanks. that works
nickfs92840nickfs92840

I need a hyperlink formula to place in the error message box. 

 

The link should go to: https://na6.salesforce.com/servlet/servlet.FileDownload?file=01580000000orB9

 

Any suggestions or ideas of this will even work from the validation rule error message box?

 

 

parodagemmaparodagemma

Hi  

 

If you are trying to get the error message to appear as an interactive hyperlink, I don't think that can be done.

The hyperlink will appear, but as a static field.

Maybe someone else has a solution though

 

nickfs92840nickfs92840

Its not possible, I just found my answer in the Help settings within salesforce. Hyperlinks are not possible to do in Validation Rules.

 

Maybe someone should suggest this in the idea exchange.

 

Thanks for checking anyway!

Chetan Kamble 1Chetan Kamble 1
This is very simple you need the 2 fields one which holds the Id of the record and second formula with hyperlink which will hold the name you want to display as link.
Eg,
HYPERLINK("/"& RecordId__c,  Account.Name) In this the RecordId__c has the id of the account. And Account.Name has the name which you want to display on detail page. Use HYPERLINK("/"& RecordId__c,  Account.Name) this value as formula in formula field.