Sharepoint WSS 3.0 Holiday/Vacation Calendar

Posted on 2010-09-10
Medium Priority
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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 44

Accepted Solution

zephyr_hex (Megan) earned 2000 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

800 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