function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Hope E.Hope E. 

formula field referencing an URL type custom field failed

Hi All,

I have a custom field which contains the user's linkin URL. 
in my formula I want to use a image instead and linked to my custom field is field if it's filled.

It's not working and will throw an error. if I look at the Url it's like: https://sdworxgroup--int.cs85.my.salesforce.com/www.linkedin.com/in/

so I tried to remove the basic url from it but it still not working.

IF(ISBLANK(LinkedIn_Profile__c), 
(HYPERLINK("http://www.linkedin.com/vsearch/p?type=people&keywords="&FirstName&"+"&LastName&"&sortCriteria=4", 
IMAGE("http://www.shebrand.com/wp-content/uploads/2010/07/icon_linkedin1.png","linkedin",15,15))), 
HYPERLINK(SUBSTITUTE(LinkedIn_Profile__c, 
LEFT($Api.Partner_Server_URL_260, FIND( '/services', $Api.Partner_Server_URL_260)), ''), 
IMAGE("http://www.shebrand.com/wp-content/uploads/2010/07/icon_linkedin1.png","linkedin",15,15)))

do you have any suggestion? 

thank you

Arvind KumarArvind Kumar
Hi Hope,

I have cross-checked. It is worked on my side.

Please try again, it will work for you.

If you have any issue, you can concern me.

Thanks,
Arvind Kumar
Hope E.Hope E.

Hi Arvind,
when I try this in my dev org, it works perfectly. but in the sandbox not. it'll add the basic url of the org inot the external url.

https://xx.csxx.my.salesforce.com/www.linkedin.com/in/xx/

do you have any idea where it comes from? 

regards,
Arezou