Sharepoint WSS 3.0 Holiday/Vacation Calendar

Posted on 2010-09-10
Last Modified: 2012-05-10

I am looking for an easy setup guide to setting up a holiday/request calendar with approval system in WSS 3.0.

All I would like is for a user to enter a request and the manager to then accept/reject the holiday and then it is placed into the calendar and shows holiday entitlement left if possible.

I have installed the Absence Request and Vacation Schedule template from microsoft, and maybe this is the one to use but I can't find a good setup guide whereby the users have multiple managers etc.

I have also checked out the youtube video that is flying around but it doesn't complete the howto guide and I don't think this is the answer.

Has anyone got a great howto guide in setting one of these up or had any similar experiences?

I am not a developer "yet"  :-)
Question by:Coast-IT
  • 2
LVL 42

Accepted Solution

zephyr_hex earned 500 total points
ID: 33648504
if you want easy, then it will be basic.  i did something similar, and it was not at all easy...  but i think i can explain a simplified version without all the bells and whistles.

in my case, i set up a system that calculated the number of vacation days based on hire date.  it also had the ability for HR to add additional "vacation" days based on special circumstances.

in your case, the easy road (which requires more manual entry):  create a list that has each employee, and field that has the total number of vacation days (that's the manual entry part... 'cause i suppose you're tracking how that total is calculated somewhere else... like an HR system or excel or something).  but anyway, you now have a list with 2 columns:  employee, and number of vacation days.

create another list that is a Request list.  this needs employee name, date entered, date(s) requested, manager (a more complex system would be able to look up the manager... but again... we're going for "easy" here).

create a workflow on your Request list that triggers on New item.  the job of this workflow is to send an email to your Approver (the manager).  it copies the fields from the Request list to an Approval list,  but with a new column for unhandled/approve/disapprove.  this Approval list also has a workflow that triggers when an item is changed... i.e.  when the manager selects approve or disapprove.

your "easy" road means the manager will need to go and verify that the employee has remaining vacation days.

when the manager selects approve/disapprove, the workflow on that list will then email the employee with the info, update the total number of vacation days on the Vacation Days Remaining list, and copy the approved items to a Vacation Approved list.  you can configure the list to be calendar view.

there are security considerations (i.e.  only managers should have access to the Approval list, for example ... and again... the basic approach is that all managers can access this list and there's no restrictions on which employees a manager can approve items for... )

and you'll likely need some other fields or workflow steps...  
but you can do this with out of the box custom lists and workflows.  just think of things step by step, and copy items to new lists based on the step you're at.  don't try to do everything in one list, or with one workflow.
LVL 11

Author Comment

ID: 33658261
That is a great answer, I will spend time attempting to implement tomorrow and let you know how it goes!
LVL 11

Author Closing Comment

ID: 33675402
Still not done it, but thanks for the great comments.

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA.…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now