Can you display email addresses in the List Collector field for a service catalog item instead of the name??

mzmoore
Mega Expert

I have a variable field named - Team Owner(s), the field type - List Collector.

I would like to choose and display email addresses instead of the names from the user [sys_user] record. 

Is that possible? I've looked at questions from past blogs and I haven't found anything that works.

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

you can set email field on user table as display=true

Marking Display as true, will make the value of that field to be shown when the user is referenced in other

records such as list field etc. But that would be global change and will affect all places where user table is being referred

Mark Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

4 REPLIES 4

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

you can set email field on user table as display=true

Marking Display as true, will make the value of that field to be shown when the user is referenced in other

records such as list field etc. But that would be global change and will affect all places where user table is being referred

Mark Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Thank you Ankur. That did work, however, it's not an option I can use as it is global change as you stated.

Sateesh Kumar 2
Kilo Guru

Hello,

 

Use the below three dictionary attribute for the field to bring your intended result.

 

ref_ac_columnslist of field names separated by semi-colonsany reference field with an auto completer (see ref_auto_completer)Specifies the columns whose display values should appear in an auto completion list in addition to the name. See the cmdb_ci field (Configuration Item) on the Incident form for a working example.
ref_ac_columns_searchtrue/falseany reference field with an auto completer (see ref_auto_completer)Causes auto-complete to work with all fields specified in the ref_ac_columns attribute. This attribute overrides the default behavior, which searches only the display value column. See Configure auto-complete to match text from any reference field.
ref_ac_display_valuetrue/falseany reference field with an auto completer (see ref_auto_completer)Causes the reference field to hide the display value column so that auto-complete only matches text from the columns listed in the ref_ac_columns attribute. This feature requires the use of the AJAXTableCompleter class and the ref_ac_columnsref_ac_columns_search, and ref_ac_display_value attributes. See Remove the display value column.
  

Hi Sateesh,

I was already using ref_auto_completer=AJAXTableCompleter,ref_ac_columns=email,ref_ac_columns_search=true,ref_ac_display_value=false

It would show the email address but it doesn't populate the field with the email address, which is what I'd like to see happen.

Thank you for helping.