• swarnaja
  • NEWBIE
  • 0 Points
  • Member since 2012

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies

Hi,

 

I have a custom object by name : Project

Child object name: ProjectAnalysis

 

Based on Project start date, End Date, Project Value, Project value per month in Project object , Project Analysis records will get generated. Please find the Trigger code:

 

trigger ProjectAnalysis on Project__c(after insert,after update) {if(trigger.isafter){   

if(trigger.isinsert)   

{    List<Project_Analysis__c> ProjectAnalysis = new List <Project_Analysis__c> {};    for (Project__c p : trigger.new) {    Integer i = 0;   

date Date1= p.StartDate__c;   

date myDate1=Date1;   

if (i <= (p.No_of_months__c + 1) ) {   

for (myDate1 = myDate1; myDate1 < p.EndDate__c.addDays(20); myDate1= myDate1.addDays(30)) {    ProjectAnalysis.add(new Project_Analysis__c(Project__c= p.Id, Amount_per_month__c= p.Project_Value_per_month__c, Date__c = myDate1));    }   

i=i+1;   

}   

}   

}

 

 

I need help to update the ProjectAnalysis records if there is a change in Project value per month/Start Date/End Date field in Project object on update.

 

Please help me on this.

 

Thanks in advance