Share
Report
97I currently have three (3) SharePoint lists namely: EmployeeInformation, LeavesAppliedByUsers, and Balance Leave Masterlist.
(1) EmployeeInformation - is where the calculation of years in service (YearsInService) and years regularized (YearsReg) of an employee.
(2) LeavesAppliedByUsers - reflects the created leave request
(3) Balance Leave Masterlist - reflects the number of used leave balance once approved by an administrator.
I’m dealing with two (2) questions:
1. How can I achieve to auto reflect the allowable leave (Balance Leave Masterlist table, column Allowable) of an employee based on years regularized and referring to the company’s specification chart?
2. Will it affect the total balance (Balance Leave Masterlist table, column TotalBalance) when the value here is calculated using the columns ‘Allowable’ subtracted by ‘Used’.
Are there options to do this? Any suggestions or recommendations are highly appreciated. Thank you.
All responses (
Answers (
