以用户为基础计算剩余请假余额 [英] Calculate Remaining Leave Balance for User basis

问题描述

大家好，

我们在SharePoint中设计了休假管理，并且当用户应用休假/休假时，我已经创建了批准并拒绝邮件流.我有几个与我的设计有关的问题

We are designed Leave management in SharePoint and I have created a approval and reject mail flow when an user applied a leave/vacation.  I have few Question related to my design

1.如果有一位用户第二次申请新的请假/休假请求，是否可以计算该特定用户的剩余请假余额?

1. If one user is apply a new leave/vacation request for second time, is it possible to calculate Remaining leave balance for the specific user?

2.在申请请假申请时，用户必须选择开始日期 和结束日期，可以排除 开始日期和结束日期来计算休日天数"列.?

2. While applying leave request, the user must be choose Start Date and End Date, is it possible to exclude the Weekends and Public holidays between Start Date and End Date to calculate Number of Days Off Column.?

3.是否可以制作表格来更新每月的休假/休假时间??

3. Is it possible to make a table to update the Leaves/Vacation Taken on Monthly basis.?

请给我一些清晰的图片.

Kindly give me Some clear picture about it.

最好的问候，

阿伦

推荐答案

是的，但是您需要做一些研究.您需要使用下面的参考资料中的函数来开发适当的计算列.

yes you can, but it's going to take some study on your part.  You'll need to develop the appropriate calculated column using functions in the references below.

• 计算字段公式
• 常见公式的示例在SharePoint列表中
ul>

这篇关于以用户为基础计算剩余请假余额的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！