[SalesForce] Hyperlink formula to click Javascript Button

I need to create an "action column" style button on Case listviews, that accomplishes the same thing as a custom javascript button that I put on the actual Case records. I am confused by some of the methods out there, but essentially get the gist that it should be a Hyperlink formula field, and needs to look like this:

I need that link to either execute the same code as my button and then open to the record page, or to have it open the record and click the button that will run the javascript, at the same time. (I've also created a "custom link" version of this button to try to do this, but Salesforce keeps telling me I can't use Javascript in hyperlink formulas)

My button javascript is as follows:

 {!REQUIRESCRIPT("/soap/ajax/13.0/connection.js")} 

var caseObj = new sforce.SObject("Case"); 
caseObj.Id = '{!Case.Id}'; 
caseObj.OwnerId = '{!$User.Id}'; 
caseObj.One_Stop_Counter__c = "{!TEXT($User.Assigned_Counter__c)}"; 
var result = sforce.connection.update([caseObj]); 

if (result[0].success=='false') { 
alert(result[0].errors.message); 
} else { 
window.parent.location.href="/{!Case.Id}"; 
}

Is this not possible at all?

Any help is appreciated.

Best Answer

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;
    }
}

Related Solutions

[SalesForce] Looking to open new subtab from a button on Contact; current subtab replaced instead

After struggling with a combination of a JavaScript button launching a VF page using more JavaScript to open a subtab, it's now been boiled down to the single JavaScript button, which looks like this:

// Require the Salesforce Console Integration Toolkit  
{!REQUIRESCRIPT("/support/console/33.0/integration.js")}

// Require the AJAX Toolkit  
{!REQUIRESCRIPT("/soap/ajax/33.0/connection.js")}

// Verify sforce.console now exists  
console.log("sforce: %o", sforce); 

// Get the enclosing tab's ID, so that openSubtab() 
can be called with the correct parameter*/ 
sforce.console.getEnclosingPrimaryTabId(function(response) {

// Remember the primary tab ID for openSubtab()  
var primaryTabId = response.id; 
console.log("primaryTabId: %o", primaryTabId); 

// Create Case using AJAX toolkit  
var cs = new sforce.SObject("Case"); 
cs.RecordTypeId = "012L000000090fq"; 
cs.Subject = "Subject required"; 
cs.Case_Issue__c = "** Please Select Case Issue **"; 
cs.ContactId = "{!Contact.Id}"; 
cs.AccountId = "{!Contact.Account_ID__c}"; 
cs.Status = "Open"; 

// Create the Case  
var result = sforce.connection.create([cs]); 
cs.Id = result[0].id; 
if(result[0].getBoolean("success")) { 
console.log("new case created with id " + result[0].id); 
} else { 
console.log("failed to create case " + result[0]); 
} 

// Define the target URL using a dummy Case ID  
var url = "{!URLFOR($Action.Case.View, '500')}"; 

// Replace the dummy Id with the actual Case.Id  
url = url.replace("500", cs.Id); 

// Define other parameters for openSubtab()  
var isActive = true; 
var tabLabel = null; 
var subtabId = null;

// Call openSubtab()  
sforce.console.openSubtab( 
primaryTabId, url, isActive, tabLabel, subtabId); 
});

The url.replace() feels kludgy, and if I can go straight to using 'cs.Id' in future iterations I will.

The reason that I want to create the Case in this manner is to leverage the new Case.Id to pull in additional details in the Case page's associated Console Components, which are blank when the Case is first loaded via the standard [New] button.

Thanks Marty C.!

[SalesForce] Can we use HYPERLINK FORMULA field in salesforce 1

I am not sure about the hyperlink formula but you can use detail page link. from there you can do your redirect stuff.

To add Detail page Link follow these simple steps.

go to Setup>Customize>Object>Buttons, Links, and Actions, and click New Button or Link. Give your link a name,
In case of custom object go to Setup>Create > Object>Buttons, Links, and Actions, and click New Button or Link. Give your link a name,
Now go to detail page of record and click on Edit layout and drop your link to suitable place. Now view in the salesforce one.

Note: Image are for just reference purpose.

Best Answer

Related Solutions

[SalesForce] Looking to open new subtab from a button on Contact; current subtab replaced instead

[SalesForce] Can we use HYPERLINK FORMULA field in salesforce 1

Related Topic