Populate Record Producer Field with UserId

[Shy]

I am new to ServiceNow. I am attempting to create a drop-down field on a record producer where the user can select an employee's "User ID". However, I am not able to find the field under the "[User] sys_user" table. Does anyone know where or how I can get this field to populate? I am not familiar with scripting within the platform either. I appreciate any help. Thanks!

[Sandeep Rajput · Accepted solution]

@Shy There is a field User ID (user_name) defined on the sys_user table which can be used for showing the select box variable with user id fields.

[Sandeep Rajput · Accepted solution]

@Shy There is a field User ID (user_name) defined on the sys_user table which can be used for showing the select box variable with user id fields.

[Sandeep Rajput · Accepted solution]

This is how you should configure your lookup select box.

[Shy]

Thank you so much for this Sandeep!!!! This worked. 

Do you know if it is possible to do a concatenation of First Name + Last Name + ' - ' + UserID  inside of the field?

[Sandeep Rajput]

Glad it worked for you. Please mark my answer correct and helpful.

Regarding concatenation, you can make following changes in the lookup label fields to show first name, last name and user id as a display label.