cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Calculated Value to obtain and Email Address or WebSite

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!

0 Kudos
Reply
4 Replies
Workflow Hero

Re: Calculated Value to obtain and Email Address or WebSite

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.

0 Kudos
Accept as Solution Reply
Not applicable

Re: Calculated Value to obtain and Email Address or WebSite

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)

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: Calculated Value to obtain and Email Address or WebSite

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

0 Kudos
Accept as Solution Reply
Not applicable

Re: Calculated Value to obtain and Email Address or WebSite

Version: 2.8.1.0. This is FORMS.

Please help!!

0 Kudos
Accept as Solution Reply