Hello Friends,

Do you know of a way outside of a workflow to create a column in a list that has a URL calculated from the fields in the existing list?

Thank you !

You can use the concatenate function to create an HTML link, and use other fields as part of the URL string. This example below links to the Shared Document library that is on the site URL contained within the "YOUR FIELD" field. You get the idea..

=CONCATENATE("<a href='",[YOUR FIELD],"/Shared Documents","' target='_blank'>CLICK ME</a>")

• Marked as answer by Prajk11 Saturday, January 31, 2015 6:35 AM

Hi,

You can create something like this:

="<a href='http://<Site>/Lists/<ListName>/Item/display.aspx?ID="&ID&"&Source=/<Site>' target='_blank''>Click Here</a>"

This will open the link in the new tab. '&' can be used to concatenate the List columns. Hope it helps.

Different syntax, same result...

Remember to set the field's data type to Number, or else you'll just get a sting of text instead of a hyperlink.

Cheers!

• Marked as answer by Prajk11 Saturday, January 31, 2015 6:38 AM

But you can't use ID in a calculated column;

Try for yourself:

edit an item and it will be reset to 0

• Marked as answer by Prajk11 Saturday, January 31, 2015 6:38 AM