I have a list called “Requests” with approx. 40 fields. One field is called “Request Type”
(lookup field to lstRequestTypes) . lstRequestTypes contain 15 different request types. I use a Nintex form to capture the data and it is processed through a Nintex workflow which is running fine.
The business has requested additional fields for the Request form. If the Request Type is “CGA”, collect 8 different fields on 1 to 4 employees. For example
If Request Type = “CGA”, provide values for the following 8 fields for each employee.
| Emp ID | LAN | OPID | Skill | From Dt | To Dt | Location | Approver List |
Employee 1 |
|
|
|
|
|
|
|
|
Employee 2 |
|
|
|
|
|
|
|
|
Employee 3 |
|
|
|
|
|
|
|
|
Employee 4 |
|
|
|
|
|
|
|
|
From my relational Database days, I would have set this up in its own table joined by request ID. In SharePoint, would I have to set up 32 new fields (4 Employees x 8 fields). The first concern is that these 32 fields would be blank for all of the other Non-CGA Request types. CGA is less than 5% of the requests.
The business said that they usually don’t have more than 4 employees on a request, but if they did, they would ask the user to submit another request. I think it would be good if 1 to X employee items could be created.
How would you set this up and display it on a Nintex form?