Sharepoint：基于另一个列表的计算列
我可能正在寻找错误的方法来执行此操作，但我在这里：
我有一个 Sharepoint 列表（标题为“旅行”），其中包含计划到特定区域的旅行列表。我有第二个列表（“区域”），其中包含固定数量的项目，每个项目代表一个特定区域。区域有一个标题为“条件”的列，描述该特定区域的道路。
现在...鉴于行程中的某个项目包含对行程前往的区域项目的引用，我希望能够“查找”该区域项目的条件列并将其包含在行程视图中。问题是，如果我向 Trips 添加查找列，它只允许我从区域中选择标题列，这只是区域名称。
有什么想法吗？
I could be looking at the wrong way to do this, but here I go:
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.
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.
Any thoughts?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
在 SharePoint 2010（及更新版本）中，您可以，但不能在 SharePoint 2007 中。
在 SharePoint 2007 中，您必须创建自定义输入表单，请查看http://weblogs.asp.net/jan/archive/2006/11/06/Custom-Edit-Forms-for-SharePoint-2007-Lists.aspx。您还可以通过创建自定义 Web 部件来添加它们，如果您需要这方面的帮助，请告诉我们。
在 Sp2010 中，事情要简单得多，您只需使用查找列类型（而不是计算列）。您应该让行程列表按照您的建议在区域列表中查找值，从区域列表中选择项目时，您可以通过选中“添加列”中的框自动从远程列表中的其他列获取值显示每个附加字段“部分。
我举了一个例子
祝你好运！
In SharePoint 2010 (and newer) you can but not SharePoint 2007.
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.
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.
I made an example
Good luck!