Convert Field Input to Hyperlink (Part 2)

[Mikaela-Newell]

I feel silly having to ask this because I've asked a very similar question (thank you @Kurt_Jones and @Rafal_Bainie!). How do I turn the URL field on a task into a hyperlink in my project view? I would assume the API value is task:URL?

The solution on my last question was:

displayname=Dropbox
link.url=customDataLabelsAsString(Dropbox link)
valueexpression=IF(ISBLANK({DE:Dropbox link}),"","Link")
valueformat=HTML

What I'm looking for now must be in the ballpark of:

displayname=URL
link.URL=task:URL
valueexpression=IF(ISBLANK({task:URL}),"","Link")
valueformat=HTML

 ... What am I missing?

[Kurt_Jones]

Mikaela, basically when you're inside a project plan viewing tasks, you want a special view that shows any URLs on tasks, right?  In that case you have the right text mode for that column when you update the view, just remove the task:   Its actually a task view that is created when you create them inside of the project plan space.

[Mikaela-Newell]

Hi Kurt, thank you! 🙂

It being a task view just occurred to me a minute ago, but that doesn't work either 😞

displayname=URL
link.URL=URL
valueexpression=IF(ISBLANK({URL}),"","Link")
valueformat=HTML

 Also doesn't work if I leave "link.URL=task:URL" as-is... Any idea what to try next?

[Kurt_Jones]

I think we can make it easier. 

1. Add the URL column to your view
2. Click Advanced Options over by the text mode/standard mode area
3. Make a column rule where if URL is not blank, click Show Text in that box type Link
4. Save

Should look like the below, that what you need?

[Mikaela-Newell]

When I try it this way, it gives me Link where the hyperlink text is just "link" instead of the URL. I wish it worked this way, much easier haha. Skye's answer below was the fix!

Thank you so much for your quick replies, Kurt!!

[skyehansen · Accepted solution]

it should be link.url (all lower case)

[Mikaela-Newell]

YES! Thank you, Skye!! Final answer:

displayname=URL
link.url=URL
valueexpression=IF(ISBLANK({URL}),"","Link")
valueformat=HTML