Solved

Lookup against multi value keywords

  • 11 January 2017
  • 7 replies
  • 3 views
J
Badge +6

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

icon

Best answer by janvonreith 30 January 2017, 20:55

View original

7 replies

J
Badge +6

Hey Jaap,

is it really necessary to do this directly in the form? Why not implementing a workflow that get's the location for every brand and at the end writes it into a custom column?

Best regards,

Jan

J
Badge +6

Hi Jan, thanks for your response,

Because it's a large list to lookup against I am not sure if that is working with a workflow and performs in the cloud.

It should be than a separate workflow anyway. Do you have an example of such a type of workflow ?

Regards

Jaap

J
Badge +6

Hey Jaap,

the performance shouldn't be a problem! I just tried to build the worklfow, which is unfortunatley harder then in an On-Premise environment as the values that we see aren't the values we get when we try to work with them in the workflow. I will try to implement it on Friday and then catch up with you again ;-)

Best regards,

Jan

J
Badge +6

Thanks Jan, appreciated !

J
Badge +6

Hey Jaap,

I finally found the time to write a short blog post about it:  

Hope this will help you!

Best regards,

Jan

TomaszPoszytek
Userlevel 7
Badge +17

Hey ‌ does ‌ answer helped you? Is it a correct answer? Or have you found a better solution you could share with us?

Regards,

Tomasz

Regards, Tomasz Poszytek
J
Badge +6

Hi Tomasz, good hunting 🙂 happy to see your reminders.

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings