Sharepoint:基于另一个列表的计算列 [英] Sharepoint: Calculated column based on another list

问题描述

我可能正在寻找错误的方法来做到这一点，但我走了:

I could be looking at the wrong way to do this, but here I go:

我有一个 Sharepoint 列表(标题为行程")，其中包含安排到特定区域的行程列表.我有第二个列表(区域")，其中包含固定数量的项目，每个项目代表一个特定区域.区域有一个标题为条件"的列，描述了该特定区域的道路.

I have a Sharepoint list (titled "Trips"), which has a list of trips scheduled to particular zones. I have a second list ("Zones"), which has a fixed number of items, each item representing a particular zone. Zones has a column titled "Condition" describing the roads in that particular area.

现在...鉴于旅行中的一个项目包含对旅行前往的区域项目的引用，我希望能够查找"该区域项目的条件列并将其包含在旅行视图中.问题是，如果我向 Trips 添加查找列，它只允许我从 Zones 中选择标题列，这只是区域名称.

Now... given that an item in Trips contains a reference to the Zone item where the trip is heading, I want to be able to "look up" the Condition column for that Zone item and include it in Trip views. Problem being, if I add a lookup column to Trips, it only allows me to select the title column from Zones, which is just the zone name.

有什么想法吗?

推荐答案

在 SharePoint 2010(和更新版本)中，您可以，但在 SharePoint 2007 中不能.

In SharePoint 2010 (and newer) you can but not SharePoint 2007.

在 SharePoint 2007 中，您必须创建自定义输入表单，请查看 http://weblogs.asp.net/jan/archive/2006/11/06/Custom-Edit-Forms-for-SharePoint-2007-Lists.aspx.您还可以通过创建自定义 Web 部件来添加它们，如果您需要这方面的帮助，请告诉我们.

In SharePoint 2007 you have to create a custom input form, check this out http://weblogs.asp.net/jan/archive/2006/11/06/Custom-Edit-Forms-for-SharePoint-2007-Lists.aspx. You can also add them by creating a custom web part, let us know if you need help with that.

在 Sp2010 中事情要简单得多，您只需使用查找列类型(而不是计算列).您应该让旅行列表按照您的建议在区域列表中查找值，从区域列表中选择一个项目时，您可以通过选中添加列"中的框自动从远程列表中的其他列中获取值显示这些附加字段中的每一个"部分.

In Sp2010 things are much simpler, you simply use the lookup column type (not by calculated columns). You should have the Trips list looking up values in the Zones list as you suggested, when selecting an item from the zones list you can automatically fetch values from other columns in the remote list by checking the boxes in the "Add a column to show each of these additional fields" section.

我举了个例子

祝你好运！

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