Nintex for SharePoint Forum
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forÂ
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 appreciated:)
Solved! Go 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‌
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...
This solution can be use for Nintex form 365???
Fms.
Hi Marian Hatala‌, yes, The trick was the vertical bar... "/BusinessTrip|Countries".
Thanks for following up.
But use nintex form 365 or on premise???
Fms
It resolved it on the on-Premise version. Might be worth a try on office 365, give it a shout.
glad to hear
Yes, I dont know if this solution can be use in Nintex Form 365... 😞
Fms.