Display Name and Email Address in Reference Field

[Dazler]

Hi, can any tell me how to include the email address in the reference field.  Our non role users (standard users) when on the client portal and they choose the reference field that points to the sys_user table, they can only see the user name.  We have some users that have the same name and to distinguish between them, we want to include their email address in there.  How can we do this?

[asifnoor]

Hi,

In the reference specifications of the field, you can add the below attribute to show the other details in the reference lookup box.

ref_ac_columns=user_name;email;

Kindly mark the comment as a correct answer and helpful if it helps to solve your problem.

[Dazler]

ref_ac_columns=name and ref_ac_columns=email is in the attributes for the the field, but for standard users, they can't see the email.

[asifnoor]

Hi under attributes, it should be like this

ref_ac_columns=name;email

Ref: https://docs.servicenow.com/bundle/orlando-platform-administration/page/administer/field-administrat...

When you say they can't see the mail, is it coming blank or you don't see the column itself?

[Allen Andreas · Accepted solution]

Hi,

If you already have the attribute for this field to also show the email address (in addition to the name) and those users can't see the email...can you check your "read" ACLs for the sys_user table? Particularly for the email field on that table. If you don't see one and the overall read is restricting, can you add one for that table and field and see if that resolves your issue?

Please mark reply as Helpful/Correct, if applicable. Thanks!