cancel
Showing results for 
Search instead for 
Did you mean: 
cmikhaiel
Nintex Newbie

Calculated field with runtime Lookup function from another site

Jump to solution

Is there a way to lookup a calculated field from another site within the same site collection?

I'm putting in a calculated field on my Nintex2010 form, with a lookup runtime function to display department codes from the parent site.

I've used it before with lookups from the same site, but I can't get it work from another site.

Here is a formula: (I know this one will work if the lookup lists are under the same site where the workflow is being implemented)

lookup("Department-Code Lookup", "ID", Hospitals, "Code")

I also tried this and didn't work:

lookup("/Departments/Finance/Department-Code Lookup", "ID", Hospitals, "Code")

the site hierarchy is: Intranet-> departments-> Finance -> my lookup lists are here

any hints or help is greatly appreciatedSmiley Happy

0 Kudos
Reply
9 Replies
Automation Master
Automation Master

Re: Calculated field with runtime Lookup function from another site

Jump to solution

check the doc for proper syntax http://help.nintex.com/en-US/nintex2013/help/#Forms/RootCategory/Designer/Nintex.Forms.LookupFunctio... 

it should be like 'siteURL|listname'

lookup‌ lookup function‌ other site‌ sept2017mh‌

Reply
pwarrak
Nintex Newbie

Re: Calculated field with runtime Lookup function from another site

Jump to solution

Dear,

Here an example, 

Am working with a web called "POC" and I want to retrieve a field from a list named "Countries" from another web called business "BusinessTrip" both under the same site collection:

Below the code:

lookup("/BusinessTrip|Countries","Title","Italy","VAT") 

Cheers... 

Reply
fmorales
Nintex Newbie

Re: Calculated field with runtime Lookup function from another site

Jump to solution

This solution can be use for Nintex form 365???

Fms.

0 Kudos
Reply
Automation Master
Automation Master

Re: Calculated field with runtime Lookup function from another site

Jump to solution

Hi ‌, were you able to resolve this?

Reply
cmikhaiel
Nintex Newbie

Re: Calculated field with runtime Lookup function from another site

Jump to solution

Hi Marian Hatala‌, yes, The trick was the vertical bar... "/BusinessTrip|Countries".

Thanks for following up. 

Reply
fmorales
Nintex Newbie

Re: Calculated field with runtime Lookup function from another site

Jump to solution

But use nintex form 365 or on premise???

Fms

0 Kudos
Reply
cmikhaiel
Nintex Newbie

Re: Calculated field with runtime Lookup function from another site

Jump to solution

It resolved it on the on-Premise version. Might be worth a try on office 365, give it a shout.

Reply
Automation Master
Automation Master

Re: Calculated field with runtime Lookup function from another site

Jump to solution

glad to hear

Reply
fmorales
Nintex Newbie

Re: Calculated field with runtime Lookup function from another site

Jump to solution

Yes, I dont know if this solution can be use in Nintex Form 365... :-(

Fms.

0 Kudos
Reply