I have a nintex form that has two calculated fields using runtime lookup functions. Lookup function on calculated field 1 returns multiple values. I want to be able to extract one of those values and pass it as a parameter to the lookup formula in calculated field 2. How can I do that ?
lookup("LIST TO LOOKUP","COLUMN TO LOOKUP",VALUE TO FILTER ON,"COLUMN VAUE TO FETCH", True)
The last parameter "true" will bring in multiple values if the lookup results in multiple matches
I may be out in left field here as relative newbie, but I'll take a stab...
Can you send the result of calculated field 1 to a collection variable. Then, on the collection variable perform a 'for each' action which contains the logic and actions needed to extract the desired value? The resulting value would then output to a variable which would supply the parameter to the lookup formula in calculated field 2.
Just a thought based on my limited experience.