问题描述
大家好.
我们使用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>")
如果它不起作用..
尝试拆分计算字段.
这篇关于计算字段公式的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!