How to display email in the reference field instead of the user's name?

[JDX7913]

I am trying to get the email to display in the reference field. 

By default, the reference field will pull the user's name. What I am trying to do is to pull the user's email. 

All of this is on the sys_user table.

How can I do this? Do I need like a custom script, etc?

[SanjivMeher · Accepted solution]

You can add email while searching, but when you actually select that user, it will only the the name of the user.

If you want to show the email on selection as well, you will have to make email field as Display for user table which is not recommended

[JDX7913]

Ah, ok I see thank you.