function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
JJSJJS 

Make the result of a formula 'clickable'

Hi,

 

Sort of a Salesforce newbie...

 

I created a new field and gave it a simple formula:

 

IF( ISBLANK(Source_Device__c), "Remote client", Source_Device__r.Name)

Basically it checks whether the Source Device field is empty for a particular record.

If it is, it outputs static text.

But if has a value, it outputs the 'Name' of that Source Device.

 

My question is: is there any way to make the 'Name' clickable (to link it to that object)? The 'Name' field is the primary key.

 

If you need any more clarification on this, please let me know. Thanks in advance.

Best Answer chosen by Admin (Salesforce Developers) 
stcforcestcforce

there should be a hyperlink function listed on the possible formula functions. try. url should be the '/'&Source_Device__c or something similar. 

All Answers

stcforcestcforce

there should be a hyperlink function listed on the possible formula functions. try. url should be the '/'&Source_Device__c or something similar. 

This was selected as the best answer
JJSJJS

Thanks very much, that worked perfectly.

 

For reference, here is the working formula:

 

IF( ISBLANK(Source_Device__c), "Remote client", HYPERLINK("https://na12.salesforce.com/" & Source_Device__c, Source_Device__r.Name))