Create hyperlink formula field which when clicked should redirect to specified record page

Question

There are 2 custom objects linked to each other via lookup. The requirement is to create a hyperlink formula field in the child record which when clicked should direct to parent record page.Is this requirement possible via hyperlink formula field?

Answer 1

Create a Text formula field with something like ...

HYPERLINK(
  "/" & Your_LookUp_On_Child__c, 
  "whatever text you want",
  "_self"
)

/* or if you want the record name */

HYPERLINK(
  "/" & Your_LookUp_On_Child__c,
  Your_LookUp_On_Child__r.Name,
  "_self"
)

Note 1: Change _self to _blank if you need the link to open in a new page

Note 2: For standard relationship fields, replace

• the __c of Your_LookUp_On_Child__c by Id
• the __r of Your_LookUp_On_Child__r by nothing

Note 3: If it can be empty, use a conditional clause (IF) to show the HYPERLINK if Your_LookUp_On_Child__c is not empty