You need to sign in to do that
Don't have an account?
Supriyo Ghosh 5
Update custom field based on related list filed value
Hi,
I have two object.
1.Employee Master
2.Sp Master.
SP master is a related list with Employee master.So i want if SP Master one field Active__c =true then on check box should get checked in Employee master.How to do that.Please help.
I have two object.
1.Employee Master
2.Sp Master.
SP master is a related list with Employee master.So i want if SP Master one field Active__c =true then on check box should get checked in Employee master.How to do that.Please help.
Thanks
Amit Chaudhary
"amit.salesforce21@gmail.com"
All Answers
Please let me know here which one is the Parent and which one is child.
For this we need to write the Trigger like below ,
if Employee Master is parent and Sp Master is a chaild then we need to write like this
trigger EmployeeMaster on SpMasterobject(after insert,after update)
{
set<id> EmployeeRecords = new set<ID>();
map<id,Employeeobject> dat = new map<id,Employeeobject>();
for(SpMasterobject sp:trigger.new)
{
if(Active__c == true)
{
EmployeeRecords.add(sp.ParentEmployeeIDs);
}
}
list<Employeeobject> Emp = [select id,Name,checkboxparent from Employeeobject where ID IN:EmployeeRecords];
for(Employeeobject Em:Emp)
{
dat.put(Em.ID,Employeeobject);
}
for(SpMasterobject sp1:trigger.new)
{
dat.get(sp1.EmployeeID).EmployeeCheckbox = true;
}
if(dat !=null && dat.size()>0)
{
Database.update(dat.values());
}
}
Introduction to the Process Builder
https://developer.salesforce.com/trailhead/en/business_process_automation/process_builder
https://developer.salesforce.com/trailhead/en/project/quickstart-process-builder
Sample code for you also
Please let us know if this will help you.
Thanks
Amit Chaudhary
Employee master is my Parent and SP Master is my child.On which object I have to write this trigger.
Trigger
trigger EmployeeMaster on SP_Master__c (after insert,after update) {
Set<id> EmployeeRecords = new Set<ID>();
for(SP_Master__c sp : trigger.new)
{
if( sp.Active__c == true)
{
EmployeeRecords.add(sp.id);
}
}
list<Employee_Master__c> EmpMaster = [select id,Name,SP__c from Employee_Master__c where SP_Master__c IN :EmployeeRecords and Active__c = false ];
for( Employee_Master__c empM : EmpMaster )
{
empM.SP__c = true;
}
if(EmpMaster.size()>0)
{
update EmpMaster;
}
}
Error
Error: Compile Error: No such column 'SP_Master__c' on entity 'Employee_Master__c'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names. at line 10 column 42
Employee_Master__c SP__c
SP_Master__c Active__c
Lookup name is Employee_Code__c in SP_Master__c.
Thanks
Amit Chaudhary
"amit.salesforce21@gmail.com"