Created
July 27, 2017 14:43
-
-
Save tet3/c04833e6a500677f67610e1a6cfdf5cc to your computer and use it in GitHub Desktop.
CreateAttendances trigger sample code for Robin
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| trigger CreateAttendances on Session__c (after insert) { | |
| Set<Id> programIds = new Set<Id>(); | |
| List<Enrollment__c> enrolledMembers = new List<Enrollment__c>(); | |
| List<Attendance__c> att = new List<Attendance>(); | |
| // create Set of Program IDs we want to query | |
| for (Session__c sessionInLoop : Trigger.new) { | |
| programIds.add(sessionInLoop.Program__c); | |
| } | |
| // query ALL the relevant Enrolled Members at once | |
| // make sure you're querying all the fields you'll need to create your | |
| // attendance records - do you need Enrolled_Mamber__c and/or Member_name__c? | |
| enrolledMembers = [SELECT Id, Enrolled_Member__c, Enrolled_Program__c | |
| FROM Enrollment__c | |
| WHERE Enrolled_Program__c IN :programIds]; | |
| for (Enrollment__c e : enrolledMembers) { | |
| att.add(.....) | |
| } | |
| insert att; | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment