Calculated Value to obtain and Email Address or WebSite

[#1]

How can I use a Calculated Value to obtain either an email address or a Website column in a SharePoint list? The column has been defined as 'Hyperlink or Picture'

If I use something like:

lookup('VendorList','Code','001-A','VendorWebsite') it returns #!Value

If I use the same lookup function in another calculated value to bring another field on the SharePoint ist, it worked fine (I.e.:

lookup('VendorList','Code','001-A','Vendor Name') it returns 'Acme'

I found out that is if I create another column with Text Format - Multiple Line of Text and put something like this on it:

<a href="http://www.google.com/">Google</a>

Nintex will return Google with the hyperlink - I will prefer not to do this as this is an existing list that already contains hundreds of rows

Thanks!

[sojanm]

Hi Jesus,

I tried the same and it worked.

lookup("TestLookup","ID","1","FldHyper"),

Make sure the field to filter and the value to filter are correct.

[#3]

Thanks Sojan...

Might it be that I need a patch or I'm in a different version than you? I can't get it to work. Everything is correct, the names are correct and the filter as well... it is working for all fields but the hyperlinks ones (web site and email address)

[sojanm]

Could be because of the version, What version are you working on?

[#5]

Version: 2.8.1.0. This is FORMS.

Please help!!