cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Combine two drop down answers to set a new column

Jump to solution

Hi all,

I'm currently doing a trial of Nintex and I've been asked to create a proof of concept for management although I've only trialled really simple stuff so far.

We've picked a business form and process to "Convert" to Nintex but I have a question regarding the best way to achieve the following as I'm not sure what workflow I should create or even if it's a workflow piece or maybe a form piece.

So, on a form there will be two drop downs:

ColumnA and ColumnB. A will have 5 separate selections and B will have another 5.

I have a matrix which shows the results of all the combinations of A and B. E.g. If A1 and B1 are selected then the result will be Low, A1/B2 is Low, A1/B5 is Moderate, etc...There are 25 possible combinations which cover 4 results

Whatever result is obtained through the combination selection then needs to be placed in a SP column and become part of the workflow, so at the end of the workflow it's included in the notification. The results need to be hidden or calculated from the drop downs as the end user can't make the result decision on their own.

How could I go about this?? Thanks....

Tags (1)
0 Kudos
Reply
1 Reply
jimmy_hang
Nintex Newbie

Re: Combine two drop down answers to set a new column

Jump to solution

Hi Aaron,

I guess there is multiple ways to solve this, as far as i can see unless you use custom scripting ect.. Nintex Form alone cannot do this, I'm checking the lates Form Online, not sure about the version for SharePoint Server 2013. This because Nintex Forms lacks the ability(Rule) to append a value to a field based on another fields values, InfoPath could do this.

Nintex Workflow on the other hand can handle this, I've created one simple example, just to demonstrate some actions:

I have this combination:

A1/B1 - Low

A2/B2 - Moderate

A3/B3 - High

Created my list with ColumnA and ColumnB

The results column is hidden in the form, but visible in the view just to show the results.

I've use the "Conditional Branch" action and "Set field in current Item" to demonstrate.

Condition for A1/B1

Results...

Hope this will help of some help...

0 Kudos
Reply