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
When you define the ProjectID lookup in the ProjectContract list, you can specify additional columns like Shortname. It will show up as ProjectIDhortname (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.