AnsweredAssumed Answered

Help writing a loop script to register a student for multiple classes

Question asked by lmack on Nov 30, 2017
Latest reply on Nov 30, 2017 by philmodjunk

I need help with a script that will register a student for a set of classes.

 

The organization sponsors programs that have 12-15 classes each. They keep student attendance records to determine who is in need of make-up classes and who had completed the course.

 

I have the following tables:

Students

Programs

Classes

Attendance (a join table between student and classes that creates an attendance sheet for each class)

 

I'm working on a script that will add a student to the attendance role for each class in the program they sign up for. Basically, I need to create a new attendance record with the student's id number and the class id number and then repeat that for each class in the program then stop.

 

Where I'm hanging up is the class id, since I need to tell the script to copy a different class id for each record. I'm sure there's a simple way to do this, but I haven't been able to find it in the community. If anyone had experience with this, I'd be most grateful to hear how you did it.

Outcomes