[SalesForce] Update a checkbox on all records in a related list from a related list button with JavaScript

I need to allow a user to select one or more records from a related list and click a button on that related list that sets a checkbox to true on each selected record.

I have prepared the following javascript in a custom button and displayed checkboxes in the related list.

Currently, when the button is clicked, the records are not updating and the checkboxes are not getting set.

Custom object: FF__Team_Member_c
Custom field: Checkbox on FF_Team_Member__c : Send_Email_to_Team_Member__c

Any thoughts?

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

var records = {!GETRECORDIDS($ObjectType.FF__Team_Member__c)}; 
var updateRecords = []; 

if (records[0] == null) { 
    alert("Please select at least one record to update.");  
} else { 
    for (var a=0; a<records.length; a++) { 
        var update_TeamMember = new sforce.SObject("FF__Team_Member__c");
        update_TeamMember.Id = records[a];
        update_TeamMember.Send_Email_to_Team_Member__c = true;
        updateRecords.push(update_TeamMember);
    }
    result = sforce.connection.update(updateRecords); 
location.reload(true);
}

Best Answer

This should work, I can think only of couple problems here:

Are you on iPhone/iPad? There were some known bugs with GETRECORDIDS not working properly on iSafari (regular Safari seems to be fine).
Are you sure the object name is typed correctly? It has 2 underscores = FF must be a managed package? Is current user allowed to edit them etc etc? (even if you're sysadmin objects might appear invisible - not returned in describe results if Profile permissions aren't set)
Any validation rules /trigger-based checks you might be hitting over there? You're swallowing all results which might contain errors. Perform simple alert(results); or maybe sth like this:

for(var i = 0; i < results.length; ++i){
    if (result[i].getBoolean("success")) {
        log("record with id " + result[i].id + " updated");
    } else {
        log("failed to update record " + result[i]);
    }
}

(inspect the browsers JS console afterwards or replace log with alert but then make sure to not tick too many checkboxes ;))

Related Solutions

[SalesForce] How to send Mass Email from List View in Contact Or Lead using custom button

Assuming you have this button on a related list/list view, you can use the {!GETRECORDIDS} javascript function to get the list/array of id of the selected records. You can then send this array to your apex class and then query the email field to get the email. YOu can do something like this:

{!REQUIRESCRIPT("/soap/ajax/28.0/connection.js")}
{!REQUIRESCRIPT("/soap/ajax/28.0/apex.js")}
var recordIdArray = {!GETRECORDIDS($ObjectType.Contact)};
console.log('the record Ids are' + recordIdArray);
var retStr = sforce.apex.execute("outbound_Emails", "SendEmailNotification",{conId: recordIdArray});

global class outbound_Emails{
        webservice static void SendEmailNotification (list<id> conId){
            list<contact> conList = [SELECT name,email FROM contact WHERE id IN : conId];
            system.debug('the selected contacts are  ' + conList);
            //you can iterate over this list to get the email and send the mail
        }
}

[SalesForce] Can we get the existing records of a related list,by clicking on a ListButton

This question is very similar to the one you already asked here: how to create a custom button for a custom object on a related list

If I don't misunderstand you requirements, you got a lot of things conceptually wrong.

First Competitors are related to quotes and you want to find all competitors for that quote. So you have to bypass the QuoteId as filter criteria - not the CompetitorId.

So your button code could be something like

/apex/CompitetorsForQuote?id={!Quote.Id}

There is also absolutely no need for using Javascript as Button type. You should use URL.

Then you query for a single competitor (using the wrong where) but you should query for a list.

string QuoteId = System.currentPageReference().getParameters().get('Id');
Competitor__c[] comps = [SELECT Id,Name,Product_Series__c,   Part_Number__c,  
    Price_Offered__c , Volume__c,  Date_Price_is_valid__c FROM Compitetor__c 
    WHERE Quote__c = :QuoteId;
];

This is probably not all and my code is untested and may contain errors. But it could help you to think about the structure.

Best Answer

Related Solutions

[SalesForce] How to send Mass Email from List View in Contact Or Lead using custom button

[SalesForce] Can we get the existing records of a related list,by clicking on a ListButton

Related Topic