Skip to main content
Nintex Community Menu Bar
Answer

Lookup against multi value keywords

  • January 11, 2017
  • 7 replies
  • 17 views
J
Forum|alt.badge.img+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

Best answer by janvonreith

Hey Jaap,

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

Hope this will help you!

Best regards,

Jan

    7 replies

    J
    Forum|alt.badge.img+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
    Forum|alt.badge.img+6
    • jaapsteenis
    • Author
    • January 13, 2017

    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
    Forum|alt.badge.img+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
    J
    Forum|alt.badge.img+6
    • jaapsteenis
    • Author
    • January 17, 2017

    Thanks Jan, appreciated !

    J
    Forum|alt.badge.img+6
    • janvonreith
    • Answer
    • January 30, 2017

    Hey Jaap,

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

    Hope this will help you!

    Best regards,

    Jan

    J
    TomaszPoszytek
    Forum|alt.badge.img+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
    J
    Forum|alt.badge.img+6
    • jaapsteenis
    • Author
    • February 5, 2017

    Hi Tomasz, good hunting :-) happy to see your reminders.

    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie SettingsAccessibility statement