Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 952
  • Last Modified:

Holiday booking system and calculating how many days left

I am creating a holiday booking system using SharePoint lists and customised ASP pages.

I have two lists one that is a list of bookings and another that holds information about the employee such as holiday entitlement etc.

What I need to achieve is a running total that will take the holiday entitlement minus the booked holidays. Any one any idea how to achieve this

0
dwelldon
Asked:
dwelldon
2 Solutions
 
Ted BouskillSenior Software DeveloperCommented:
Sharepoint lists aren't a substitute for a relational database.  It can be done but it takes a lot of work.  Generally what you need to do is hide direct access to the lists and publish custom pages that are used for data entry and to combine the data using the Data View Web Part which can be managed using Sharepoint Designer (which is now free)
0
 
ramuar1981Commented:
for this u  can create a  one more column in the list holiday entitlement that will contain the remaining no of holidays (that u asked entitlement -booked)

Create a Synchronous event in the booked list which will check the value of the column Remening from the list holiday entitlement , and if that is >0 than it will permit u to go ahead with the booking more.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now