As part of my ECO workflow I have users input up to 12 names in an Excel doc to get approval. Depending on the product line and manufacturing plants affected, the actual approvers needed can be as few as 2 and as many as 12. I have everything setup to work using a combination of automatic transitions and Dispatch scripts to treat empty approver cells as "approved." Where I am struggling is that we want to use full user names (i.e. John Doe), but our logins are coded based on location and user initials (i.e. pcjd001). Dispatch will only understand the logins, but the ECO form needs full names to be user-friendly.
There are 2 options I can think of for how to solve this problem:
1.) Figure out how to get Dispatch to convert full names to logins
2.) Have Excel lookup the login from the database using the full name
Does anybody have any suggestions on how to accomplish either of these? We don't have any API programming experience in house, so I apologize in advance for needing entry-level explanations.