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

Need help in List Lookup Control

I have two lists - one is VHProjectList & other is Project Contracts. The VHProjectList has the fields as Ops Project ID, Short Name, Proj Manager. The Project Contracts also has the fields Project ID, Short Name. I created a look up field for ProjectID to Ops Project ID in VHProjectList and want the value in Short Name in Project Contracts list to be autopopulated based on ProjectID from the VHProjectList. I am using the Listlookup runtime function in nintex forms. The formula I used is lookup("VHProjectList", "Ops Project ID", ProjectID, "Short Name") and also changed the drop down to recalculate on View mode. But when I run it, I see the value in Short Name is calculating but not populating in the form. Please help me what wrong I am doing in the formula

0 Kudos
Reply
2 Replies
Highlighted
jpmhuls
Nintex Newbie

Re: Need help in List Lookup Control

When you define the ProjectID lookup in the ProjectContract list, you can specify additional columns like Shortname. It will show up as ProjectIDSmiley Frustratedhortname (which you also can rename into Shortname). And as such you don't need it to be populated using an inline function. Hopefully this helps resolving your requirement in a different way.

0 Kudos
Reply
Automation Master
Automation Master

Re: Need help in List Lookup Control

if ProjectID is lookup field or control, then its value looks like ID;#TextValue

you have to use parseLookup() runtime function to get one or the other part out of it.

0 Kudos
Reply