可以多次更新的Sharepoint表单 [英] Sharepoint form that can be updated multiple times

问题描述

我正在设计一个Sharepoint表单，该表单允许用户识别要执行的任务.我想要一个或多个字段，使他们能够记录完成任务所花费的时间，并且我希望能够对此进行报告.所以， 例如，约翰在1月1日花了2个小时在taks上，然后在1月4日玛丽在上面花了3个小时，最后在1月10日约翰·特雷弗在上面花了1个小时.我希望能够汇总所花费的总时间以及查询数据以查看哪个团队成员 做出了贡献.

I'm designing a Sharepoint form that allows users to identify tasks to be undertaken. I'd like to have a field, or series of fields that allows them to record the hours they've taken to work on the task and I'd like to be able to report against that. So, for example, on 1st Jan John spends 2 hours on the taks, then on 4th Jan Mary spends 3 hours on it and finally on 10th Jan Trevor spends 1 hour on it. I'd like to be able to sum the total time taken as well as interrogate the data to see which team member contributed to it.

有没有一种方法可以创建一个可以多次更新并且不会覆盖以前的数据的字段?

Is there a way to create a field that can be updated multiple times and doesn't over write the previous data?

我对Sharepoint真的很陌生，所以这可能真的很简单！谢谢

I'm really new to Sharepoint so this may be really simple! Thanks

推荐答案

嗨Pigmy1303，

Hi Pigmy1303,

视图"设置中有一个简单功能:总计，请检查是否适合您的请求:

There is a simple feature in Views settings: Totals, check if it’s feasible for your request:

1.为用户花费的任务时间创建一列.

1. Create a column for task time that user spends.

2.转到列表设置->视图->单击要显示的视图->在编辑视图页面中向下滚动到总计部分->为任务时间"列选择总和"，如下所示:

2. Go to list settings->Views->click the view you want to display->scroll down to Totals section in edit view page->select "Sum" for Task Time column as below:

3.然后，该列顶部将有总的任务时间，如下所示:

3.Then there will be sum task time on the top of the column as below:

最诚挚的问候，

Grace Wang

Grace Wang

这篇关于可以多次更新的Sharepoint表单的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！