AnsweredAssumed Answered

Lookup against multi value keywords

Question asked by jaapsteenis on Jan 11, 2017
Latest reply on Feb 5, 2017 by jaapsteenis

I want to calculate a field on a Form containing Product Locations based on the selection of a series of Products.

The Products are selected in a multi value keyword field.




BMW   -     Japan

BMW   -     Germany

Ford    -     The Netherlands

Renault  -    France


When I select the Car marks:    BMW, Ford


The calculated value for Product Location should be:  Japan, Germany


There is a lookup list applicable for example:


Car Mark       Product Location 

BMW              Japan

BMW              Germany

Ford                The Netherlands

Renault           France


The Idea is that when a series of products is registered, we can see what product locations are involved (and can be reported on)


We are using O365 Nintex Forms, Nintex Workflow

Did someone come across a similar requirement and provided a solution for this ?