I am completely new to Nintex Workflows. I'm very much affiliated with SharePoint 2013, and try to draft a new small business application. We are using Nintex 2013 at our company. This is what I want to achieve.
- We would have a regular SharePoint form. This form would have several dropdown fields for example type of physical flow, destination country or Plant code.
- Based on all user inputs, the application would calculate the correct routing rules (Intermediates) and show the correct results, preferably already on the form itself or on a follow up page.
- We have a master SharePoint list which would store all rules. All rules and results are completely depicted in that list. Basically the application would only search over the master data list, and based on the values that the user selected in the dropdown menus, it would show the correct output.
The list would look like this. Green columns are the values for my input (dropdown fields). Based on which values I select, the application would show the correct output (yellow columns).
|Flow type||Region source||Source type||Destination code||destination address||destination Region||Flash/ non flash||is Destination country = source country (U-turn)||exception dest||Intermediate 1||Intermediate 2||intermediate 3|
|Int site||EU||Site||BE-Pr(LSP dest)||LSP||EU||Flash||All||std||-||-||-|
|Int site||EU||Site||BE-Pr(LSP dest)||LSP||JP||Flash||All||JP||-||BE-Pr(VP HS source Region SG01)|
|Ext Sup||EU||Bysell-Supplier||BE-Pr(LSP dest)||LSP||EU||Flash||different||std||BE-Pr(VP ExtSup Dest Country)||-||-|
|Ext Sup||EU||Toll - Supplier||BE-Pr(LSP dest)||LSP||EU||Flash||different||std||BE-Pr(VP ExtSup Source country)||-||-|
Basically this is a very basic application, I just don't know how to achieve this within Nintex Workflows. Can you help?
Do I need to work with Query Actions?