I want to search field "Employee number" on callers module

[schd]

i create field "Employee number" on Callers module but is not find Employee number in table sys_user.

Thank you,

Suchawadee

[Pradeep Sharma]

Hi Suchawadee,

You have to just define the attribute to pull other fields whose display value are not set to "True" on reference tables.

Please check section 4 for more info.

Auto-Complete for Reference Fields - ServiceNow Wiki

P.S : A table can have only one display value set to true.

[ghsrikanth · Accepted solution]

For sys_user table, the display field is Name

hence whenever you select a value in a reference which is referring to sys_user table, it will always display the name.

You can create a String field Employee Number and on selecting the caller, you can write an onChange script to populate the employee number on the basis of caller selected.

This will help you, GlideForm (g form) - ServiceNow Wiki

Mark if it is helpful or correct, feedback is appreciated

[schd]

Thank you

[ghsrikanth]

I hope you have resolved the issue, please find a recent community post with the same requirement - the user posted wants the Country field to be populated by Company's country in the form onChange

You can refer this post for development -

Re: Presenting a value based on another value in another field

Hopefully it will help