SharePoint列表列 [英] SharePoint list columns

问题描述

我正在为以下业务场景寻找最佳选择：

现有的"会员" Excel电子表格上的联系人列表，基本上跟踪所有委员会及其成员。每个委员会都在同一Excel文档的不同选项卡上。这些字段几乎包含普通联系字段
，如名称，电子邮件，电话等。此方法目前效率低下，因为它是一个文档，需要在文档和各个页面上更新细节。我们现有的2013 SharePoint网站。 

我们希望创建一个"主"网站。将驻留在SharePoint上的列表（如联系人列表），并在页面上显示委员会的不同视图。如果我刚为委员会添加了一个额外的列并在其上创建了基于
的不同视图，这将会有效。

然而，一个主列表的问题是某些成员可能是几个委员会的一部分。最重要的是，有一个"角色"列。每个成员都在委员会中扮演。他们可以是一个成员，也可以是另一个委员会的另一个成员的指定人。

基本上，人A - 扮演角色"会员"。在委员会"微软"中和角色"指定人"在委员会"Apple"中。我不想创建重复的行，因为它仍然是人A。

在这种情况下设置列表的最佳方法是什么？

解决方案

您可以使用多行文本字段或复选框列来存储用户的所有委员会及其角色。

例如，创建一个名为"Committee_Role"的多行文本字段。告诉用户以"委员会_角色"格式输入委员会和角色。

之后，您不需要为单个用户创建多行。并且，您仍然可以根据委员会创建视图。

最好的问候，

Linda

I'm looking for best options for the below business scenario:

There is an existing "Members" contact list on Excel spreadsheet which basically keeps track of all committees and their members. Each committee is on a different tab in the same Excel doc. The fields pretty much consist of normal contact fields like Name, Email, Phone etc. This method presents inefficiencies at the moment because it is a document and the details need to be updated both on the document as well as various pages on our existing 2013 SharePoint site. 

We are looking to create a "master" list that would reside on SharePoint (like a contact list) and display different views of committees on pages. This would work out if I just added an extra column for Committees and created different views based on that.

However the issue with ONE master list is that some members could be a part of several committees. To top that, there is a column for the "Role" that each member plays in a committee. They could be a member in one and a designee to another member in another Committee. 

So essentially, Person A - Plays the Role "Member" in Committee "Microsoft" and Role "Designee" in Committee "Apple". I wouldn't want to create duplicate rows since it is still Person A.

What would be the best way to setup a list in such a situation?

解决方案

Hi,

You can use a multiple-lines of text field or a checkboxes column to store all Committees and their roles for the user.

For example, create a multiple-lines of text field named "Committee_Role". Tell users to enter the committee and role with "Committee_Role" format.

After that, you don’t need to create multiple rows for a single user. And, you still can create views based on the committee.

Best regards,

Linda

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