In the Email field on catalog form reference to sys_user table would like to see email not name

[darshan-pra]

In the Email field on catalog form reference to sys_user table would like to see email not name after selection , this field is not in related to request for or such 

[Chaitanya ILCR · Accepted solution]

Hi @darshan-pra ,

3rd one looks something like this where users can search using the emails along with names and it will show name and emails

if not 

why not stick with a plain email field?

or better create a new field which shows up the selected users email

if you don't want an additional field just create Email field and valid if a valid user exist with the email

what's your business requirement 

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

[darshan-pra · Accepted solution]

when you select the option it will display name not email ,the requirement is  email field which should able to search and retrieve users email also after the selection email should be visible not name .  

[Dr Atul G- LNG]

Hi @darshan-pra 

You can use dot-walking to access the email field from the Caller. If you select a user, the email will be auto-populated based on the same relationship.

https://www.servicenow.com/community/developer-articles/auto-populate-reference-data-in-service-cata...

[darshan-pra]

as mention above there is no relation to request for field would like to select emails of users and after selection would like to see email not name 

[Chaitanya ILCR]

HI @darshan-pra ,

you can do couple of things

1. make it a LookUp select box

and select label value = email 

lookup value can be of your choice sysid or email

or

you can change the display value of user table email (I won't recommend) 

or 

you can show additional info like email using variable attributes to show email

put below in the variable attributes

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=email,ref_ac_columns_search=true

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

[darshan-pra]

the lookup select box as there are more than more than 2 lakh user applying the reference qualifier creating slowness in catalog and also lookup select box limit to 10000 only , second not feasible , 3rd is not working out