Employee ID

[DeIvory Gordon]

Hello,  I have to add an Employee ID field to a catalog item.  I have two questions:

1. I created a variable titled "Employee ID", I made the Type "Look up Select Box", I referenced the Sys-user table, I selected  "Sys ID" for the Lookup value field and the I added "Employee ID" on the Lookup label field(s)".I tried the form and the "Employee ID" field came back "Null".  How do I get the Employee ID field to show the employee ID?

2. I also would like this field to already lead with a capital “C” for contractor- is that possible?  Please see the attached screen shots.  Thank you!

[Tanushree Maiti · Accepted solution]

Hi @DeIvory Gordon 

Employee ID - you should use reference variable  as Look Select box allow to show only 10,000 record and user experience is not good.

Also in real time, organizations populate Employee Number field in sys_user.

Employee ID should be pointing Employee Number. How a people can read sys_id, its very backend data.

If you lookup sys_id , it will come like this

It will look like this