Update Available Seats After Enrollment

[pallav_nagar]

How to Update Available Seats After Enrollment in Employee Enrollments record using Business Rules in ServiceNow?

Table - Employee Enrollments

Scenario:
Whenever an employee enrolls in a course, automatically decrease the Available Seats count in the related Training Course.

Additional Field(s) Required:
Available Seats (Integer), Total Seats(Integer) on the Training Courses table.

Expected Result:
Each new enrollment automatically reduces the number of available seats.

[Mark Manders]

What did you already try and what didn't work? Especially with a BR, you can just do calculations on the field (enrollment added, look up training course and deduct 1 from the available seats).

[Tanushree Maiti]

Hi @pallav_nagar ,

You can try with Async Update BR on your Enrollment table.

 Trigger condition could be when  course changes AND employee is not empty

 you can try with this Sample script :

var courseGR = new GlideRecord('training_courses'); // Replace with your actual Training Course table name

    if (courseGR.get(current.course)) // Replace 'course' with your exact Reference field name

{         

        if (current.operation() == 'insert') {

            courseGR.available_seats = parseInt(courseGR.available_seats) - 1; //  Decrement Available Seats on Insert

        }

       courseGR.update();

    }