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 :(
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.