Holiday request

0

Hi Dariusz,

we used also an Employee file. There was an "holiday leave limit" item list but consist of the column
Year, Days from previous year, Days current year, Extra Days

This was updated only when something happend to the limits or when the next year item list row was created. Of course based on the taken requests.

The holiday requests themselves used a data table:
Day limit for this year, based on the employee file
Planned days, holiday requests in draft in this year
Requested days, requested holidays in this year in the future and not cancelled
Taken days, holidays requests in this year in the past and not cancelled
Remaining available days, calculated based on the above

This way the requestor/approver had a detailed overview about the days.

If you need, you could copy the values from the data table to an item list once the request is approved.

There are probably other options, but I prefer transparency and calculating "volatile" values like taken days at runtime.

Best regards,
Daniel