is it possible to assign Link to Item to a Calculated Column in SharePoint Online? I have read a few solutions suggesting editing AllItems.aspx in SPD designer but the calculated column is not listed in the code
2 Answers
For SharePoint Online you can use column formatting.
https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting
For something like creating a hyperlink this is perfect as you likely do not need to store the underlying value.
You can CONCATENATE an a tag at the calculated column formula
Something like this Ref
=CONCATENATE("<a href="http://server/sitename/Page.aspx?PageTitle=",Title,">",Title,"</a>") But you must use the available fields that listed when you build your formula. and unfortunately the Link To Item require ID field that is not available !
Check also @Danny answer at Calculated column with ID removes ID number on update , URL in calculated column
answered Aug 31, 2016 at 5:38
- Have you tested this?Danny '365CSI' Engelman– Danny '365CSI' Engelman2016-08-31 06:51:26 +00:00Commented Aug 31, 2016 at 6:51
- unfortunately no , I depend on the reference , let me check it and if it is not worked I will update/delete it , thanks @Danny'365CSI'Engelman2016-08-31 07:22:16 +00:00Commented Aug 31, 2016 at 7:22
- ID doesn't always do what you want, See the answer at sharepoint.stackexchange.com/questions/159962/…Danny '365CSI' Engelman– Danny '365CSI' Engelman2016-08-31 07:27:21 +00:00Commented Aug 31, 2016 at 7:27
- you are right so let me update it, many thanks @Danny'365CSI'Engelman for this information2016-08-31 07:29:02 +00:00Commented Aug 31, 2016 at 7:29