I do not know if 2010 offers that ability with calculated columns, but 2007 does not. However, you could use a workflow to populate a field in the current list from the other list and then create a calcualted column based on that field.
Ryan already answered that one.
Yes this can be done in workflows but I'd need to know more about what exactly you were trying to do before I could intelligently help.
Are you familiar with looking up ID's in a workflow based on values entered in the list? If not, let me know and we'll break that out a little further.
Assuming you are, you could create a variable named LookupID and put the Row ID of the lookup value from the Lookup list. Then analyze the variable value and see if it matches one of the IDs that meet your criteria.
If it does, then build the URL using the Dynamic String builder to include the ID. So the URL would look something like:
发布评论
评论（3）
我不知道 2010 是否提供了计算列的功能，但 2007 没有。但是，您可以使用工作流程从其他列表填充当前列表中的字段，然后根据该字段创建计算列。
Ryan 已经回答了这个问题。
是的，这可以在工作流程中完成，但我需要更多地了解您到底想做什么，然后才能明智地提供帮助。
是
I do not know if 2010 offers that ability with calculated columns, but 2007 does not. However, you could use a workflow to populate a field in the current list from the other list and then create a calcualted column based on that field.
Ryan already answered that one.
Yes this can be done in workflows but I'd need to know more about what exactly you were trying to do before I could intelligently help.
您熟悉根据列表中输入的值在工作流程中查找 ID 吗？如果没有，请告诉我，我们将进一步解决这个问题。
假设您是这样，您可以创建一个名为 LookupID 的变量，并将查找列表中查找值的行 ID 放入其中。然后分析变量值并查看它是否与符合您条件的 ID 之一相匹配。
如果是，则使用动态字符串构建器构建 URL 以包含 ID。因此，URL 类似于：
http://server/site/Lists/myList/DispForm.aspx?ID=[ListID]
[ListID] 是您使用动态字符串中的“查找字段”按钮添加到字符串的参数建设者。
Are you familiar with looking up ID's in a workflow based on values entered in the list? If not, let me know and we'll break that out a little further.
Assuming you are, you could create a variable named LookupID and put the Row ID of the lookup value from the Lookup list. Then analyze the variable value and see if it matches one of the IDs that meet your criteria.
If it does, then build the URL using the Dynamic String builder to include the ID. So the URL would look something like:
http://server/site/Lists/myList/DispForm.aspx?ID=[ListID]
[ListID] is a parameter that you add to the string using the Lookup Field button in the dynamic string builder.
对于包含/开始，您可以使用 SEARCH（不区分大小写并允许使用通配符）或 FIND （区分大小写）
因此，例如“Begins With”在字段 [Field] 中查找“第一个单词”将是
For contains/begins you can use either SEARCH (case insensitive and allows wildcards) or FIND (case sensitive)
So for example "Begins With" looking for "First words" in field [Field] would be