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'), ''
)
Improve this question
1
  • you should use PArent_Account.Name
    – m Peixoto
    Apr 3, 2019 at 14:44

3 Answers 3

Reset to default
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')
Improve this answer
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.

Improve this answer
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')
Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .