Referencing the sys_user email address

[Jason Stephens]

How would I create a reference variable that is referencing the email address from the sys_user field?

[Chuck Tomasi]

Jason,

Not sure what you mean. Can you give me an example?

Basics: Reference variables are just a sys_id to another table (e.g. go point to record 46d44a23a9fe19810012d100cca80666 in sys_user). The "Display" attribute on the dictionary entry tells the UI which field value to display. By default this is a field called 'name'. If there is no 'name' field in the table, then the Display attribute needs to be set on one of the fields.

If you're looking to display the user's email address on the incident form then your best bet is to 'dot walk' you way to that value when you personlize the form layout.

Let me know if that needs more detail, or provide me with an example of what you're looking for and I can get you closer.

[Jason Stephens]

I want a variable on an item called something like Email Address. I want it to be a reference variable that will be referencing the email field from the sys_user record. I need to know how to tie my variable to this field instead of just pulling the user names. I want my "type ahead" to be showing email addresses instead of names.

[Chuck Tomasi]

There isn't a way to display a different "display" field for the same reference.

What about displaying extended attributes and allowing your auto complete to find those also?

http://wiki.service-now.com/index.php?title=Reference_Fields#Auto-Complete

It's still a reference to sys_user so it wouldn't display the email address.

[Jason Stephens]

A better way to put it would be that I need to know what qualifier, condition, attribute, etc. to add to the variable to make it pull email address instead of name.