How to open URL in a new tab?

Question

Hi All,

I have created a report something like this...

ProviderWebsiteGooglehttp://www.google.comAmazonhttp://www.amazon.comEbayhttp://www.ebay.com

Expected Result.

ProviderWebsiteGoogle
URLAmazon
URLEbay
URL

Here I am trying to do two things..

1. Hide the URL but give the hyperlink to the word "URL"

2. When user clicks on URL, should be opened in a new window.

PS: URL is coming from a Database column.

Thanks in advance.

- Enric

user8007837 · Answer

Thanks Gianni. I used the Plan B and it work a treat.

Gianni Ceresa · Answer

Plan B: set the format of your column to do the same work ...

Gianni Ceresa · Answer

Just use a bit of HTML to concatenate around your URL or something like that ...