function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
HamptonHampton 

Help With Previously Working Apex Trigger

Good Morning:

 

I created the follwing Apex trigger back in June and it was working wonderfully (creating/deleting child records depending on some field updates from the parent record) and all of a sudden about two weeks ago, the trigger stopped creating the child records. 

 

I opened the developer console and got the following error:

 

 

required (...)+ loop did not match anything at input 'trigger'

 

 

I have done some reading on other posts with the same error message and understand that it means nothing is being passed from the map over to the creation portion of the record. I guess I need to understand why and why it all of a sudden happened when it was working fine for four months.

 

Any help is greatly appreciated.

 

trigger RepSummaryCreation on Video_Turf__c (after update) {
Map<ID, String> releaseName = new Map<ID, String>();
for (Video_Turf__c newDoor2: Trigger.new){
if(newDoor.Assigned__c == TRUE)
releaseName.put(newDoor2.ID, newDoor.Name);

}

List<Rep_Summary__c> newSummary = new List<Rep_Summary__c>();
for(Video_Turf__c turf1 : [Select ID, Name, Date__c, Doors_Per_Rep__c, Rep_One__c from Video_Turf__c where ID in : releaseName.keyset() and Rep_One__c !='']){
newSummary.add(new Rep_Summary__c(
Date__c = turf1.Date__c,
Release__c = turf1.ID,
Doors__c = turf1.Doors_Per_Rep__c,
Name = turf1.Rep_One__c));
}

insert newSummary; 

List<Rep_Summary__c> newSummary2 = new List<Rep_Summary__c>();
for(Video_Turf__c turf2 : [Select ID, Name, Date__c, Doors_Per_Rep__c, Rep_Two__c from Video_Turf__c where ID in : releaseName.keyset() and Rep_Two__c !='']){
newSummary2.add(new Rep_Summary__c(
Date__c = turf2.Date__c,
Release__c = turf2.ID,
Doors__c = turf2.Doors_Per_Rep__c,
Name = turf2.Rep_Two__c));
}

insert newSummary2; 

List<Rep_Summary__c> newSummary3 = new List<Rep_Summary__c>();
for(Video_Turf__c turf3 : [Select ID, Name, Date__c, Doors_Per_Rep__c, Rep_Three__c from Video_Turf__c where ID in : releaseName.keyset() and Rep_Three__c !='']){
newSummary3.add(new Rep_Summary__c(
Date__c = turf3.Date__c,
Release__c = turf3.ID,
Doors__c = turf3.Doors_Per_Rep__c,
Name = turf3.Rep_Three__c));
}

insert newSummary3; 

List<Rep_Summary__c> newSummary4 = new List<Rep_Summary__c>();
for(Video_Turf__c turf4 : [Select ID, Name, Date__c, Doors_Per_Rep__c, Rep_Four__c from Video_Turf__c where ID in : releaseName.keyset() and Rep_Four__c !='']){
newSummary4.add(new Rep_Summary__c(
Date__c = turf4.Date__c,
Release__c = turf4.ID,
Doors__c = turf4.Doors_Per_Rep__c,
Name = turf4.Rep_Four__c));
}

insert newSummary4; 

List<Rep_Summary__c> newSummary5 = new List<Rep_Summary__c>();
for(Video_Turf__c turf5 : [Select ID, Name, Date__c, Doors_Per_Rep__c, Rep_Five__c from Video_Turf__c where ID in : releaseName.keyset() and Rep_Five__c !='']){
newSummary5.add(new Rep_Summary__c(
Date__c = turf5.Date__c,
Release__c = turf5.ID,
Doors__c = turf5.Doors_Per_Rep__c,
Name = turf5.Rep_Five__c));
}

insert newSummary5; 

List<Rep_Summary__c> newSummary6 = new List<Rep_Summary__c>();
for(Video_Turf__c turf6 : [Select ID, Name, Date__c, Doors_Per_Rep__c, Rep_Six__c from Video_Turf__c where ID in : releaseName.keyset() and Rep_Six__c !='']){
newSummary6.add(new Rep_Summary__c(
Date__c = turf6.Date__c,
Release__c = turf6.ID,
Doors__c = turf6.Doors_Per_Rep__c,
Name = turf6.Rep_Six__c));
}

insert newSummary6; 

List<Rep_Summary__c> newSummary7 = new List<Rep_Summary__c>();
for(Video_Turf__c turf7 : [Select ID, Name, Date__c, Doors_Per_Rep__c, Rep_Seven__c from Video_Turf__c where ID in : releaseName.keyset() and Rep_Seven__c !='']){
newSummary7.add(new Rep_Summary__c(
Date__c = turf7.Date__c,
Release__c = turf7.ID,
Doors__c = turf7.Doors_Per_Rep__c,
Name = turf7.Rep_Seven__c));
}

insert newSummary7; 

List<Rep_Summary__c> newSummary8 = new List<Rep_Summary__c>();
for(Video_Turf__c turf8 : [Select ID, Name, Date__c, Doors_Per_Rep__c, Rep_Eight__c from Video_Turf__c where ID in : releaseName.keyset() and Rep_Eight__c !='']){
newSummary8.add(new Rep_Summary__c(
Date__c = turf8.Date__c,
Release__c = turf8.ID,
Doors__c = turf8.Doors_Per_Rep__c,
Name = turf8.Rep_Eight__c));
}

insert newSummary8; 

List<Rep_Summary__c> newSummary9 = new List<Rep_Summary__c>();
for(Video_Turf__c turf9 : [Select ID, Name, Date__c, Doors_Per_Rep__c, Rep_Nine__c from Video_Turf__c where ID in : releaseName.keyset() and Rep_Nine__c !='']){
newSummary9.add(new Rep_Summary__c(
Date__c = turf9.Date__c,
Release__c = turf9.ID,
Doors__c = turf9.Doors_Per_Rep__c,
Name = turf9.Rep_Nine__c));
}

insert newSummary9; 

List<Rep_Summary__c> newSummary10 = new List<Rep_Summary__c>();
for(Video_Turf__c turf10 : [Select ID, Name, Date__c, Doors_Per_Rep__c, Rep_Ten__c from Video_Turf__c where ID in : releaseName.keyset() and Rep_Ten__c !='']){
newSummary10.add(new Rep_Summary__c(
Date__c = turf10.Date__c,
Release__c = turf10.ID,
Doors__c = turf10.Doors_Per_Rep__c,
Name = turf10.Rep_Ten__c));
}

insert newSummary10; 
}

 

Thanks,

 

Hampton

JohnSchultzJohnSchultz

It looks like the problem might be at the top of your code. You reference newdoor but I don't see that variable set up anywhere.

 

for (Video_Turf__c newDoor2: Trigger.new){
  if(newDoor.Assigned__c == TRUE)
    releaseName.put(newDoor2.ID, newDoor.Name);
}

 

HamptonHampton

John:

 

That is a good catch. I copied and pasted the code out of the Developer Console after I had been tinkering with it. The actual code in production is:

 

trigger RepSummaryCreation on Video_Turf__c (after update) {

    Map<ID, String> releaseName = new Map<ID, String>();
    for (Video_Turf__c newDoor: Trigger.new){
    if(newDoor.Assigned__c == TRUE)
    releaseName.put(newDoor.ID, newDoor.Name);
  
    }
  
    List<Rep_Summary__c> newSummary = new List<Rep_Summary__c>();
    for(Video_Turf__c turf1 : [Select ID, Name, Date__c, Doors_Per_Rep__c, Rep_One__c from Video_Turf__c where ID in : releaseName.keyset() and Rep_One__c !='']){
        newSummary.add(new Rep_Summary__c(
                  Date__c = turf1.Date__c,
                  Release__c = turf1.ID,
                  Doors__c = turf1.Doors_Per_Rep__c,
                  Name = turf1.Rep_One__c));
    }
  
    insert newSummary;  
       
    List<Rep_Summary__c> newSummary2 = new List<Rep_Summary__c>();
    for(Video_Turf__c turf2 : [Select ID, Name, Date__c, Doors_Per_Rep__c, Rep_Two__c from Video_Turf__c where ID in : releaseName.keyset() and Rep_Two__c !='']){
        newSummary2.add(new Rep_Summary__c(
                  Date__c = turf2.Date__c,
                  Release__c = turf2.ID,
                  Doors__c = turf2.Doors_Per_Rep__c,
                  Name = turf2.Rep_Two__c));
    }
  
    insert newSummary2;    
    
    List<Rep_Summary__c> newSummary3 = new List<Rep_Summary__c>();
    for(Video_Turf__c turf3 : [Select ID, Name, Date__c, Doors_Per_Rep__c, Rep_Three__c from Video_Turf__c where ID in : releaseName.keyset() and Rep_Three__c !='']){
        newSummary3.add(new Rep_Summary__c(
                  Date__c = turf3.Date__c,
                  Release__c = turf3.ID,
                  Doors__c = turf3.Doors_Per_Rep__c,
                  Name = turf3.Rep_Three__c));
    }
  
    insert newSummary3;   
    
    List<Rep_Summary__c> newSummary4 = new List<Rep_Summary__c>();
    for(Video_Turf__c turf4 : [Select ID, Name, Date__c, Doors_Per_Rep__c, Rep_Four__c from Video_Turf__c where ID in : releaseName.keyset() and Rep_Four__c !='']){
        newSummary4.add(new Rep_Summary__c(
                  Date__c = turf4.Date__c,
                  Release__c = turf4.ID,
                  Doors__c = turf4.Doors_Per_Rep__c,
                  Name = turf4.Rep_Four__c));
    }
  
    insert newSummary4;   
    
    List<Rep_Summary__c> newSummary5 = new List<Rep_Summary__c>();
    for(Video_Turf__c turf5 : [Select ID, Name, Date__c, Doors_Per_Rep__c, Rep_Five__c from Video_Turf__c where ID in : releaseName.keyset() and Rep_Five__c !='']){
        newSummary5.add(new Rep_Summary__c(
                  Date__c = turf5.Date__c,
                  Release__c = turf5.ID,
                  Doors__c = turf5.Doors_Per_Rep__c,
                  Name = turf5.Rep_Five__c));
    }
  
    insert newSummary5;   
    
    List<Rep_Summary__c> newSummary6 = new List<Rep_Summary__c>();
    for(Video_Turf__c turf6 : [Select ID, Name, Date__c, Doors_Per_Rep__c, Rep_Six__c from Video_Turf__c where ID in : releaseName.keyset() and Rep_Six__c !='']){
        newSummary6.add(new Rep_Summary__c(
                  Date__c = turf6.Date__c,
                  Release__c = turf6.ID,
                  Doors__c = turf6.Doors_Per_Rep__c,
                  Name = turf6.Rep_Six__c));
    }
  
    insert newSummary6;   
    
    List<Rep_Summary__c> newSummary7 = new List<Rep_Summary__c>();
    for(Video_Turf__c turf7 : [Select ID, Name, Date__c, Doors_Per_Rep__c, Rep_Seven__c from Video_Turf__c where ID in : releaseName.keyset() and Rep_Seven__c !='']){
        newSummary7.add(new Rep_Summary__c(
                  Date__c = turf7.Date__c,
                  Release__c = turf7.ID,
                  Doors__c = turf7.Doors_Per_Rep__c,
                  Name = turf7.Rep_Seven__c));
    }
  
    insert newSummary7;   
    
    List<Rep_Summary__c> newSummary8 = new List<Rep_Summary__c>();
    for(Video_Turf__c turf8 : [Select ID, Name, Date__c, Doors_Per_Rep__c, Rep_Eight__c from Video_Turf__c where ID in : releaseName.keyset() and Rep_Eight__c !='']){
        newSummary8.add(new Rep_Summary__c(
                  Date__c = turf8.Date__c,
                  Release__c = turf8.ID,
                  Doors__c = turf8.Doors_Per_Rep__c,
                  Name = turf8.Rep_Eight__c));
    }
  
    insert newSummary8;   
    
    List<Rep_Summary__c> newSummary9 = new List<Rep_Summary__c>();
    for(Video_Turf__c turf9 : [Select ID, Name, Date__c, Doors_Per_Rep__c, Rep_Nine__c from Video_Turf__c where ID in : releaseName.keyset() and Rep_Nine__c !='']){
        newSummary9.add(new Rep_Summary__c(
                  Date__c = turf9.Date__c,
                  Release__c = turf9.ID,
                  Doors__c = turf9.Doors_Per_Rep__c,
                  Name = turf9.Rep_Nine__c));
    }
  
    insert newSummary9;  
    
    List<Rep_Summary__c> newSummary10 = new List<Rep_Summary__c>();
    for(Video_Turf__c turf10 : [Select ID, Name, Date__c, Doors_Per_Rep__c, Rep_Ten__c from Video_Turf__c where ID in : releaseName.keyset() and Rep_Ten__c !='']){
        newSummary10.add(new Rep_Summary__c(
                  Date__c = turf10.Date__c,
                  Release__c = turf10.ID,
                  Doors__c = turf10.Doors_Per_Rep__c,
                  Name = turf10.Rep_Ten__c));
    }
  
    insert newSummary10;                                                                               
}

 This is still generating the same error when I run in the console. Sorry for the confusion.

 

Thanks,

 

Hampton