Apex Code Development You need to sign in to do that
Don't have an account?
sumprit How to update a field based off Record Type in an SControl?
Hi there,
I need to update a checkbox on Object A , based off its related list which is Object B and also which is of LOANER record type.
Object A = CDM RMA (custom object)
Object B = RMA Add ON
Field to be updated = Loaner_Issued.
\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<script type="text/javascript" src="/js/functions.js"></script>
<script src="/soap/ajax/10.0/connection.js"></script>
<script language="JavaScript">
// Global Values
var isChanged = false; // set to true if the checkbox is placed on Loan Issued checkbox
// List checkbox fields here to compare the final values with
// CDM RMA is the object name and the Loaner_Issued is the customer checkbox.
var loanerIssued = {! CDM_RMA__c.Loaner_Issued__c};
// Function created to updated the checkbox.
function RmaAddon()
{
// Create temp account for updating
var updateCDM_RMA__c = new sforce.SObject("CDM_RMA__c");
// Update each CDM RMA record based on the ID.
updateCDM_RMA__c.ID = '{!CDM_RMA__c.Id}';
// Get the RMA Add on lists attached to the CDM RMA object.
// Tried this too.(" SELECT Id, (SELECT Id, FROM R00N30000001Xi2lEAC WHERE RecordType.Name = 'Loaner') FROM CDM_RMA__c ");
var getprods = sforce.connection.query("SELECT r.Id, r.Name, CDM_RMA__r.Name FROM RMA_Add_On__c r WHERE CDM_RMA__r.Name = '{!CDM_RMA__c.Name}'");
var records = getprods.getArray ("records");
// Here I am checking that the RMA Add-On Type is Loaner based record type and if yes then place
// checkmark on the Loan Issued checkbox.
for(var i=0;i<records.length;i++){
dynaBean = records[i];
if(dynaBean.$Recordtype.Name == 'Loaner'){ // Record Type
updateCDM_RMA__c.Loaner_Issued__c = 1; // Checkbox is the checked.
if(loanerIssued == 0) isChanged = true; // variable name is TRUE becuase the checkbox value is changed from False to True
}
}
// If the CDM RMA record has been changed then save the new RMA Add on type for LOANER RecordType and save the record.
if(isChanged){
var saveResult = sforce.connection.update([updateCDM_RMA__c]);
if(saveResult[0].success){
window.parent.parent.location.href = '/{! CDM_RMA__c.Name }';
} else {
alert('There was an error when saving CDM RMA Record.');
}
}
}
</script>
</head>
<body>
<script>RmaAddon();</script>
</body>
</html>
////////////////////////////////////////////////////////////////////////
Here is the problem:-
1.> Either the SOQL is not correct
2.> I am unable to tell how to update a field based off Record Type
3.> Error =
![]( "Break on this error")
if(dynaBean.Recordtype.Name == 'Loaner'){ // Record Type
Thanks.
I need to update a checkbox on Object A , based off its related list which is Object B and also which is of LOANER record type.
Object A = CDM RMA (custom object)
Object B = RMA Add ON
Field to be updated = Loaner_Issued.
\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<script type="text/javascript" src="/js/functions.js"></script>
<script src="/soap/ajax/10.0/connection.js"></script>
<script language="JavaScript">
// Global Values
var isChanged = false; // set to true if the checkbox is placed on Loan Issued checkbox
// List checkbox fields here to compare the final values with
// CDM RMA is the object name and the Loaner_Issued is the customer checkbox.
var loanerIssued = {! CDM_RMA__c.Loaner_Issued__c};
// Function created to updated the checkbox.
function RmaAddon()
{
// Create temp account for updating
var updateCDM_RMA__c = new sforce.SObject("CDM_RMA__c");
// Update each CDM RMA record based on the ID.
updateCDM_RMA__c.ID = '{!CDM_RMA__c.Id}';
// Get the RMA Add on lists attached to the CDM RMA object.
// Tried this too.(" SELECT Id, (SELECT Id, FROM R00N30000001Xi2lEAC WHERE RecordType.Name = 'Loaner') FROM CDM_RMA__c ");
var getprods = sforce.connection.query("SELECT r.Id, r.Name, CDM_RMA__r.Name FROM RMA_Add_On__c r WHERE CDM_RMA__r.Name = '{!CDM_RMA__c.Name}'");
var records = getprods.getArray ("records");
// Here I am checking that the RMA Add-On Type is Loaner based record type and if yes then place
// checkmark on the Loan Issued checkbox.
for(var i=0;i<records.length;i++){
dynaBean = records[i];
if(dynaBean.$Recordtype.Name == 'Loaner'){ // Record Type
updateCDM_RMA__c.Loaner_Issued__c = 1; // Checkbox is the checked.
if(loanerIssued == 0) isChanged = true; // variable name is TRUE becuase the checkbox value is changed from False to True
}
}
// If the CDM RMA record has been changed then save the new RMA Add on type for LOANER RecordType and save the record.
if(isChanged){
var saveResult = sforce.connection.update([updateCDM_RMA__c]);
if(saveResult[0].success){
window.parent.parent.location.href = '/{! CDM_RMA__c.Name }';
} else {
alert('There was an error when saving CDM RMA Record.');
}
}
}
</script>
</head>
<body>
<script>RmaAddon();</script>
</body>
</html>
////////////////////////////////////////////////////////////////////////
Here is the problem:-
1.> Either the SOQL is not correct
2.> I am unable to tell how to update a field based off Record Type
3.> Error =
dynaBean.$Recordtype has no properties
Thanks.
SOQL
You can test your SOQL using external utilities, such as those mentioned on this page.
Recordtype
I normally hard-code the recordtype ID into my query, eg "... and recordtype = '012200000000NWm' "
When to execute
I'm having difficulty trying to figure out exactly what you're attempting to do. Do you just want something displayed on-screen as a result of your criteria, or do you actually need the field updated on the record itself?
If you are putting this in an S-control that is added to the Page Layout, then the code only gets executed (and t
e field updated) when somebody views the page.
If you only want to show the result on-screen without having to store the status of the checkbox, you can do it by displaying your own checkbox instead of trying to store it on a Salesforce object.
More information would be helpful.
thanks again
How did you solve it? I am having the same problem.
thanks.
function RmaAddon()
{
// Create temp account for updating
var updateCDM_RMA__c = new sforce.SObject("CDM_RMA__c");
// Update each CDM RMA record based on the ID.
updateCDM_RMA__c.ID = '{!CDM_RMA__c.Id}';
// Get the RMA Add on lists attached to the CDM RMA object.
// Notice how the value is based off Record type and ID.
var getrmas = sforce.connection.query ("SELECT Id, Name, CDM_RMA__c, CDM_RMA__r.Name FROM RMA_Add_On__c WHERE Recordtype.Name = 'Loaner' AND CDM_RMA__c = '{!CDM_RMA__c.Id}'");
var records = getrmas.getArray ("records");
// Next, we will first reset the value of the existing CDM RMA record, field Loaner_Issued to False.
updateCDM_RMA__c.Loaner_Issued__c = false;
// If there are Loaners available
if (records.length > 0)
{
newLoanValue = true;
}
// Next update the value of the CDM RECORD to the new value, and the checkbox will be checked.
updateCDM_RMA__c.Loaner_Issued__c = newLoanValue;
if (loanerIssued != newLoanValue) isChanged = true; // checkbox value is changed and this is the same variable defined above.
// If the CDM RMA record has been changed then save the new RMA Add on type for LOANER RecordType and save the record.
if(isChanged)
{
var saveResult = sforce.connection.update([updateCDM_RMA__c]);
if(saveResult[0].success)
{
window.parent.parent.location.href = '/{! CDM_RMA__c.Id }';
}
else {
alert('There was an error when saving CDM RMA Record.');
}
}
}
</script>
</head>
<body onload = "RmaAddon();">