I inserted a List Lookup control on my Nintex Form (Office 365) so the user (a manager) can select an employee name & employee ID. The name & ID come from a SharePoint list which includes the manager name (which is how the List Lookup filters to get only the manager's employees) and many other fields like Job Title and Department. The List Lookup has the "Text connected to" set to a list column of single text (call it EmployeeNameAndID). The "ID connected to" is not connected because in this case the ID from that list is meaningless.
I want the lookup to populate a lot of fields / list columns, but the control only allows for 1. To get around this, I created 2 "calculated" columns in the SharePoint list that will split the value of EmployeeNameID and results in list columns for EmployeeName and EmployeeID.
It works okay, but now I also want Employee Job Title and Employee Department, and maybe more later on. It will start to get complicated trying to put all that into 1 text column and using calculated columns to extract each value.
Before I dive into that, is there a better way? Any suggestions?
To summarize, the user (a manager) opens a new form, uses a drop-down (List Lookup) control to select an employee, and I want at least 4 values auto-populated based on the selection (the values are all found on an employee list).
No, I cannot use User Profiles because not every employee has a user profile.