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.

 

Example:

 

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 ?

Thanks

Jaap

Outcomes