0

I created this formula field to display a hyperlink to the direct parent account on whatever record a user is viewing. For some reason the link displays the account Id number and not the actual name of the account.

Formula Field:

IF(
   NOT(ISBLANK(Parent_Account__c)), 
   HYPERLINK("/" & Parent_Account__c, Parent_Account__c, '_self'), ''
)
  • you should use PArent_Account.Name – m Peixoto Apr 3 at 14:44
3

The HYPERLINK() formula function accepts both a URL and a display name for the link. You're constructing both using the Parent_Account__c field, which is the relationship field:

HYPERLINK("/" & Parent_Account__c, Parent_Account__c, '_self')

The content of a relationship field is always a Salesforce Id. If you'd like to display the name, or any other related field, you need to reference it explicitly:

HYPERLINK("/" & Parent_Account__c, Parent_Account__r.Name, '_self')
0

Parent_Account__r.Name should give you the parent account name you're looking for. Try that in the second parameter of the HYPERLINK() method.

0

The correct formula for the HYPERLINK should be some like if you are using the Parent out of the box relationship.

HYPERLINK("/" &  ParentId , Parent.Name, '_self')

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.