计算字段公式 [英] Calculated field formula

问题描述

大家好.

我们使用Sharepoint2013.在列表中，我们计算了称为协议"的字段.该字段的公式为:

We use Sharepoint 2013. In the list we have calculated field called "Protocol". Formula for this field is:

="< a href ='http://tim.smcru.com/company/contracts/Lists/ReconciliationProtocols/AllItems.aspx#InplviewHasha8f17af3-533c-4f58-9327-0b42372dedf8=FilterField1%3DDocumentID-FilterValue1% 3D"& ID&"协议"/a""

="<a href='http://tim.smcru.com/company/contracts/Lists/ReconciliationProtocols/AllItems.aspx#InplviewHasha8f17af3-533c-4f58-9327-0b42372dedf8=FilterField1%3DDocumentID-FilterValue1%3D"&ID&"'>Protocol</a>"

此引用由两部分组成:第一个是常量部分-另一个列表的地址.第二部分是第二部分的"ID".清单项目.

This reference consists of two parts: the first one is the constant part - the address of another list. The second part is the "ID" of list item.

在大多数情况下，此公式可以正常工作.但是有时SP会截断公式的第二部分(当我们单击该字段时)，因此地址变得不正确.

In most cases this formula work correctly. But sometimes SP truncate the second part of the formula (when we click on the field), so the address is becoming incorrect.

那么，我们如何解决它 ?

So, how can we fix it?

推荐答案

嗨

尝试

= CONCATENATE(< DIV>< a href ='http://tim.smcru.com/company/contracts/Lists/ReconciliationProtocols/AllItems.aspx#InplviewHasha8f17af3-533c-4f58-9327-0b42372dedf8= FilterField1％3DDocumentID-FilterValue1％3D& ID&">协议</a</div")

=CONCATENATE("<DIV><a href='http://tim.smcru.com/company/contracts/Lists/ReconciliationProtocols/AllItems.aspx#InplviewHasha8f17af3-533c-4f58-9327-0b42372dedf8=FilterField1%3DDocumentID-FilterValue1%3D"&ID&">Protocol</a></div>")

如果它不起作用..

尝试拆分计算字段.

这篇关于计算字段公式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！