Tech or Treat! Write an article about your scariest tech disaster to win gadgets!Learn more


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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Many companies are making the switch from Microsoft to Google Apps ( Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

648 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