A training class table is updated routinely by Training Admins adding Classes. I need to find a way to allow them to create "recurring classes". On the table there is a start date & end date field. Both are date/time fields.
I've set out by creating a "recurring"(u_recurring) field (true/false) and a "number of occurrences" (u_number of occurrences) field (integer) on the Training Class form. The idea is that the trainer will set the "recurring" check box to true and then set the "number of occurrences" and the Business Rule will create multiple records based on "number of occurrences" entered.
Example: Trainer creates a new record with the following Start & End Dates. Training checks "recurring" and sets the "Number of Occurrences" to 3.
Start Date: 2017-06-20 08:00:00
End Date: 2017-06-20 10:00:00
On Submit, create 3 additional records with Start & End Dates 7 days apart
Start Date: 2017-06-27 08:00:00 | End Date: 2017-06-27 10:00:00
Start Date: 2017-07-04 08:00:00 | End Date: 2017-07-04 10:00:00
Start Date: 2017-07-11 08:00:00 | End Date: 2017-07-11 10:00:00
I'm struggling with how to tell the Business Rule to create the "number of occurrences" and how to set the Start & End dates.
Name: Recurring Class
Table: u_training_class
Insert: true
When: after
Condition: current.u_recurring = true
Script:
(function executeRule(current, previous /*null when async*/) {
var tc = new GlideRecord('u_training_class');
tc.newRecord();
tc.u_start_date = current.getValue('u_start_date') +7;
tc.u_end_date = current.getValue('u_end_date') +7;
tc.insert();
})(current, previous);
