已连接的SP列表 [英] Connected SP Lists

问题描述

我正在创建这个"审核清单系统"。其中有一组项目将分配给每个用户。

例如： 

我有需要的项目的复选框待审核（例如文件夹结构，技术设计文件，功能设计文件等），因此我将检查技术设计文件和功能设计文件;所以只有两（2）件物品
将被审核。

我将输入审核员名单，例如我将输入五（5）个名称，所以每个五（5）名审计员将有一份清单，如下所示。将检查审计框，审计员将输入有多少调查结果。

现在，对于每个调查结果，应该能够在"调查结果"中创建新项目。 list - 它应与上面的Audit项目相关。

我该怎么做？任何帮助表示赞赏。

解决方案

您好，

对于OOB功能，这里有建议供您参考。

Crate a审计项目列表用于存储审计项目（技术设计文档，功能设计文档）。

创建审计请求列表（审计用户：启用了多个用户的用户）字段，审核项目（如果需要动态）：多个查找引用审核项目列表中的审核项目）

创建审计请求详细信息列表（审计请求：查询，其中涉及审计请求列表，审计项目：查询参考审计项目列表中的审计项目，审计用户，审计复选框，调查结果），您可以通过审计请求创建视图组
以获得更好的树视图。

为审计请求列表创建工作流，在创建审计请求项时，在审计请求详细信息列表中创建项目（每个审计员映射到N（N等于审计项目计数）审计请求详细信息项目，所以用户只需填写他们自己的
审核。

关于如何短语多个查找/用户字段在工作流程中，您可以查看以下主题。

https://social.technet.microsoft.com/Forums/en-US/a8a890b5-f5fb-447f-b96f-9f3abdb7e178/ forum-faq-sharepoint-2013-extraction-values-from-a-multivalue-enabled-lookup-column-and-merge？forum = sharepointgeneral

如果您需要表单看起来就像您分享的那样，您需要自定义解决方案从列表中获取数据并通过CSOM / JSOM / SSOM更新项目。

https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/complete-basic-operations-using-sharepoint-client-library-code

最好的问候，

利

I am creating this "Audit Checklist System" wherein there are a set of items that will be assigned across every users.

For example: 

I have checkboxes of the items that need to be audited (ex. Folder structure, Technical Design Document, Functional Design Document etc) so I will check for example Technical Design Document and Functional Design Document; so there are only two (2) items that will be audited.

I will enter the list of Auditors, example I will enter five(5) names, so each of the five (5) auditors will have a checklist, something like this. Audited box will be checked, and Auditor will enter how many findings are there.

Now, for each findings, there should be an ability to create a new item in the "Findings" list - it should be related to the Audit item in the above.

How can I do this? Any help is appreciated.

解决方案

Hi,

For OOB function, here are suggestions for your reference.

Crate a Audit items list used to store the Audit items(Technical Design Document, Functional Design Document).

Create a Audit request list(Audit users: multiple user enabled user field,Audit items(if need dynamically):multiple lookup refer Audit items in Audit items list)

Create a Audit request details list(Audit request:lookup which refer Audit request list, Audit item:lookup refer Audit item in Audit items list,Audit user,Audited checkbox,Findings), you may could create view group by Audit request for better tree view.

Create a workflow for Audit request list, when a Audit request item created, create items in Audit request details list(each Auditor maps to N(N equal to Audit items count) Audit request detail items, so users fill in their own Audit only).

For how to phrase multiple lookup/users field in workflow, you could check below thread.

https://social.technet.microsoft.com/Forums/en-US/a8a890b5-f5fb-447f-b96f-9f3abdb7e178/forum-faq-sharepoint-2013-extracting-values-from-a-multivalue-enabled-lookup-column-and-merge?forum=sharepointgeneral

If you need the form looks like exactly what you shared, you need custom solution to get data from list and update the items eithe by CSOM/JSOM/SSOM.

https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/complete-basic-operations-using-sharepoint-client-library-code

Best Regards,

Lee

这篇关于已连接的SP列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！