Paul Galvin's (old) SharePoint space [SharePoint

Just another site

Employee Training Schedule and Materials Template — Decrement bug in the template

The client noticed a bug today with the above mentioned template. 

Course managers create courses.  When creating a course, the manager specifies maximum number of available seats.

The template provides for self-service enrollment.  I enroll and a workflow attached to the registration list decrements the "available seats" associated with that course.

Individuals may also unregister from a course.  The bug lies here.  Unregistering from a course does not increment the available seats counter.  As a result, available seats is not accurate.  This bug is compounded by the fact that when available seats decrements to zero, no more self-service registration is allowed.

Fortunately, Microsoft provides the workflow for this process.  Even better, it’s a straight-forward workflow created via SharePoint Designer.

Follow these high level steps to fix it:

  1. Fire up SDP.
  2. Access the site based off the training template.
  3. Access "Attendee unregistration" workflow.
  4. Insert these steps (I made them the first two steps):
    1. Calculate Courses:Filled Seats minus 1 (Output to Variable:calc)
    2. (then) Update item in Courses

Click Finish and you’re done.

Screen shots:

SharePoint Designer:

Finished workflow:

Calculate drill-down:

Update item in Courses:


3 responses to “Employee Training Schedule and Materials Template — Decrement bug in the template

  1. Unknown October 17, 2007 at 11:53 pm

    We\’re having a discussion about this template over on the SharePoint University forums. Could you check in to the forum and help clarify some things for us.


  2. arun December 6, 2007 at 7:40 am

    Hi Paul,
    Template: Employee Training Scheduling & Materials
    I want to add one more custom column in the course(training) list i.e Businees unit dropdown column,but i tried lot to insert column but in vain. Again i  tried through XSLT in SPD but no use, i am getting error.  It\’s very mandatory for me to use one more column in that list(NewForm.aspx of Cource list).
    Please tell me, how can i overcome this problem.
    Thanks in advance

  3. Unknown September 1, 2009 at 9:13 pm

    Hi Paul. Thaks for your posting about this issue. I appreciate it. I did find another defect though. When a user unregisters from a course, the unregistration process is not selecting the correct list entry to delete. Instead of selecting the list entry that matches the ID of the item selected on the My Courses page it updates the first entry in the Registrations list regardless of the user or the class. Any ideas on how to correct this issue?

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: