1

I have a SharePoint on-premises calendar list created. need a hyperlink column in event view form to download ics file from a hyperlink.

The download link gets created and works fine but i need to hide the link and display a text instead.

="http://{site url}/_vti_bin/owssvr.dll?CS=109&Cmd=Display&List={LIST_GUID}&CacheControl=1&ID="&ID&"&Using=event.ics"

The above when added to calculated column of calendar list works fine. But it displays the entire url.

The data type returned from this formula is: Single line of text

Need to change display text as "click to download ics file".

Please suggest any ways to achieve this.

when searched online , SharePoint Server 2013 and SharePoint Server 2016 The June 2017 PU and subsequent PUs will include a new web application setting that's called CustomMarkupInCalculatedFieldDisabled. This setting lets an on-premises administrator determine whether execution of custom markup in calculated fields in a given web application is blocked.

2
  • Which version of SharePoint are you using, 2016? Commented Sep 2, 2022 at 16:38
  • sharepoint onpremise 2019
    – user105078
    Commented Sep 2, 2022 at 16:41

1 Answer 1

0

Try using this formula:

"<a href='http://{site url}/_vti_bin/owssvr.dll?CS=109&Cmd=Display&List={LIST_GUID}&CacheControl=1&ID="&ID&"&Using=event.ics'>click to download ics file</a>"

OR

=CONCATENATE(
    "<a href='http://{site url}/_vti_bin/owssvr.dll?CS=109&Cmd=Display&List={LIST_GUID}&CacheControl=1&ID=",
    [ID],
    "&Using=event.ics'>click to download ics file</a>"
)

Documentation: Examples of common formulas in lists


Note: Some users have added HTML markup or script elements to calculated fields. This is an undocumented use of the feature, and we will block the execution of custom markup in calculated fields in SharePoint Online from June 13, 2017 onwards. The June 2017 Public Update (PU) and later PUs will make blocking a configurable option for on-premises use in SharePoint Server 2016 and SharePoint Server 2013.

Source: Handling HTML markup in SharePoint calculated fields

So, HTML markup may not work in calculated columns.

1
  • no this didnt work. tried it in different way using javascript in script editor
    – user105078
    Commented Sep 27, 2022 at 15:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.