1

I have a default custom list with 3 values:
- Title
- Description
- URL

What I'm trying to do is fill the Title with a name, fill the description with text and automatically create a page with the title: eg. mysharepoint.com/names/'title I set when I add an item'

Well everything works with an event receiver except one thing. The value in title links to a default display form and my value in the URL column links to the site I wanted to link the title column to.

1

I propose this solution:

  1. Create calculated column.
  2. Insert following formula -
    ="<a href='"&UrlFieldName&"'>"&Title&"</a>"

  3. Set "data type returned from this formula is" to integer.

As a result on list view you will see the title with link to your url.

UPD: It seems that URL field is not valid for calculated column, as workaround you can copy url value in a receiver into another text field, which is not shown on the view.

UPD 2: See the comment from @Tally:

For anyone else wishing to use this as a solution, Microsoft no longer allow HTML in calculcated columns, so this won't work any more.

| improve this answer | |
  • 1
    What do you mean by "you can copy url value in a receiver into the another text field"? – Mariusz Ignatowicz Sep 18 '13 at 14:42
  • For anyone else wishing to use this as a solution, Microsoft no longer allow HTML in calculcated columns, so this won't work any more. – Tally Mar 10 at 8:37
0

Great solution, but your formula doesn't work for me. Correct formula is: =CONCATENATE(""&[Title]&"")

I've tried it a lot of times, with various of formulas from this or other sites, but it takes me only one long string with URL + Title. But with this correct formula it works!

No coding, no scripts :)
I use SharePoint 2013 Online

Thank you, Kai, great solution!

| improve this answer | |
  • Hi David, I've tried out your formula but it only returns the Title value in my calculated column. I also found that I was not able to incorportate a url column in my formula. – Tally Mar 10 at 8:39
  • Try this: =CONCATENATE("<a href=' "&[URLlink]&" '>"&[Title]&"</a>") – David Repka Mar 11 at 9:32
  • Hi David, thanks for taking the trouble to reply. Microsoft no longer allow html in calculated columns (there's a very popular post on this in SPSE). For my own particular requirements, I've since found a way around it (answer by Michael Han): sharepoint.stackexchange.com/questions/277400/… – Tally Mar 11 at 11:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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