How can I use the Absence Request and Vacation Schedule Management template to keep track of everyone's balances. Say an employee had 15 days of leave available on May 1. For each day of vacation they take from that date their balance decreases. Can this be done? I've been all over the web looking for an answer and am about ready to give up :(
You could always apply a workflow to the list so that whenever time taken off it updates a secondary list containing available vacation hours for your users. You could then kick off a second workflow to notify you when that column value drops to zero
I did this by having an employee leave list which has the employees name, allowance and balance. When an employee makes a request they enter the days taken (which gets approved by their manager).
Then minus the days requested from their holiday balance in the employee leave list. Matching the employee name and the to the name of the employee who created the holiday request.