Getting an Employee ID to be it's own column in List View

Rob Sestito · ‎07-07-2017

Okay - I am going to try and explain this as best as I can in hopes to ask the right question.

While looking at List View, having all your columns. I wanted to create a Column that can display employee's company ID number. Now, while in a Case, there are Tabs called: Case Notes/Related Knowledge/About Employee/Employment Information/Contact Information. In the Employment Information, the "requested for" employee's ID number is generated. Even when filling out a Case form, we are able to search for an employee by their name and or ID number. So I know the system is configured to see/find/generate the Employee ID numbers.

What I am looking to do, is have that ID number, be it's own column when looking at the List View of all cases. That way, I will be able to generate reports using the employee's ID numbers.

As of now, I did create a new column called Employee ID Number. But I am stomped on how I can get this column to look at the employee ID number and show it in the column.

Anyone able to understand what I am looking for and possibly help?

Thanks so much in advance!

-Rob

Ahmed Hmeid1 · ‎07-07-2017

It looks like you have personalised your list View. If you go into the list view tand click the cog in the left hand corner, there'll be an option in there to reset columns to default. your list will then reflect the list settings above.

(One of the things I find a bit frustrating is when you personalise your list view, if you remove a dot walked field, you can't add it back again without resetting everything back to default)

View solution in original post

Chuck Tomasi · ‎07-07-2017

Hi Robert,

It sounds like a simple case of dot-walking. You can place the field from a related (reference) record on the list using Configure> List Layout. If you want it on a report, then you can do something similar in the report field layouts.

Dot-Walking - ServiceNow Wiki

Rob Sestito · ‎07-07-2017

Thanks for replying Chuck - and yes I know how to dot-walk. I have the column I created for Employee ID Number. However, that is not looking at anything to generate the numbers.

but wait - I think I found it.. When going to the Configure Form list, and looking at "requested for" - that option has the added extensions drop down menu. And I see "requested for.userID". that may be what I am actually looking for!

I will test that and let you know if it works. I had already "added" it to the form, but when the form refreshes, it's not showing the change.

-Rob

Chuck Tomasi · ‎07-07-2017

Were you adding this to a list or a form?

What needs to happen when the form refreshes? I'm not entirely clear of the requirements, Robert. Screenshots would be helpful.

Rob Sestito · ‎07-07-2017

Sorry for the confusion Chuck -

So I am going to List Layout:

Then from there - I already found the "Requested for.User ID" from the available section, and added it to my selected List section.

But after I save it - Requested for.User ID still does not show up when I go back to my list view.