[SalesForce] How to convert Hyperlink in formula field

As Salesforce is disabling the use of JavaScript in Hyperlink function in formula fields, as per this documentation: Hyperlink Formula Fields for JavaScript Disablement

I am working on changing one formula field.

I have created a custom link with Execute JavaScript functionality. But custom links will be displayed at the bottom of the page.

Is there any alternative way where I can get this link on random place on the page layout?

Any suggestion is greatly appreciated.

Best Answer

Its not possible to place a button anywhere in layout. Can be done by a inline page which simply redirects, but it would be an overkill for such a simple requirement.

Possible solutions are mentioned in documentation: Hyperlink Formula Fields for JavaScript Disablement. Quoting from it:

What action do I need to take?

We recommend that admins begin reviewing their use of JavaScript in hyperlink formula fields and migrate to alternative solutions. This critical update is enabled for all orgs on the auto-activation date of October 30, 2017. Here are some possible workarounds.

Create a Custom Button or Link executing JavaScript

Create custom buttons or links executing OnClick JavaScript

Supported in Salesforce Classic only

Create a Lightning Experience Quick Action

Create JavaScript in a Lightning Experience component that can be executed though a Quick Action button

Supported in Lightning Experience only

Create a custom Visualforce Page to redirect to the correct URL

If there is a client-side conditional logic to be executed to decide the link to which the user needs to be directed, create an empty Visualforce page and an Apex controller. Pass the required values from the link to controller, execute the logic to decide the URL in controller method and perform the redirect.

We recommend that you test this update in a sandbox or Developer Edition org. Check the behavior of the HYPERLINK function in formula fields.

Based on where you need to execute this action, you have these options.

Related Solutions

[SalesForce] Custom Formula Field on custom object has disappeared from page layout

Formula fields will be visible in the detail page after saving the record.
In case of Edit mode those are not visible.

[SalesForce] Hyperlink formula to click Javascript Button

You can achieve this with the help of a Visual Force page and a Controller. In the Visual Force page put the action name in the apex:page tag itself so that the action method invoked when this page is requested by the server. Pass the Case Id and current (list view) page URL to the Controller on the click of HYPERLINK Formula field. The current Page URL will be used to return to the same page where the HYPERLINK formula field is clicked. In the Controller update the Case and create a PageReference based on the retURL parameter. At the end forward to this PageReference and you will get the updated list view.

HYPERLINK Formula field

HYPERLINK("javascript:function encURI(){return encodeURIComponent(window.location);};javascript:window.location='/apex/casepage?caseid="+ Id +"&retURL='+encURI()" ,'Accept Case', '_self')

Visualforce Page

<apex:page controller="MyCaseController" action="{!updateCase}" >
</apex:page>

Controller

public class MyCaseController {
    public String retUrl {get;set;}
    public String caseId {get;set;}
    public MyCaseController(){
        retUrl = ApexPages.currentPage().getParameters().get('retURL');
        caseId = ApexPages.currentPage().getParameters().get('caseid');
    }
    public PageReference updateCase(){
        PageReference retPage = new PageReference(retUrl);
        //Put your own logic here
        Case cs = new Case(Id=caseId);
        cs.Subject = 'New Case Subject';
        update cs;
        return retPage;
    }
}

Best Answer

Related Solutions

[SalesForce] Custom Formula Field on custom object has disappeared from page layout

[SalesForce] Hyperlink formula to click Javascript Button

Related Topic