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
Ford The Netherlands
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 ?