- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-24-2020 11:30 PM
Hi all,
I want to know that whether there is any way through which we can show email address of the user in the list collector field on record producer instead of just name.
For ex- I want to show Kiel Mubrach (kiel.mubrach@company.com) instead of just Kiel Mubrach in the field when a user is selected from the list in a list collector field.
The table for list collector field is sys_user.
I have read that it can be done something by marking display value true for sys_user table but that is something that will change for all the list collector fields used. I just want to make this change for a particular record producer.
Thanks in advance
Solved! Go to Solution.
- 5,624 Views
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-25-2020 12:42 AM
Hi Rohit,
You can add additional fields to the Name such as email, company etc but you cannot remove Name
For adding additional fields you need to update the variable attributes as this
ref_auto_completer=AJAXTableCompleter,ref_ac_columns=name;email,ref_ac_columns_search=true,ref_ac_order_by=name
Output:
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-24-2021 02:50 PM
Thank you!!
I guess I shouldn't be surprised that ServiceNow's documentation is inaccurate/out of date (it says all those attributes are for Reference fields, specifically excluding List Collectors), but I'm glad to see that it works this way.
Terribly unfortunate there's no ootb way to see these additional fields after the fact though. It's one thing if you can't see them on the Portal because that's for end users who only need that info to submit the request, unlike fulfillment teams that more likely need to see that info after submission, but it looks the same on Agent Workspace, which is where fulfillment teams are being pushed...
Take note of this deficiency ServiceNow...

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-14-2021 08:29 PM
Ankur, I'm familiar with these attributes. If I add glide_list, it fails. Thoughts?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-09-2022 02:17 AM
Hi, I added this for my list collector variable for a catalog item . But I can only see name.
ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_name;u_description,no_filter,ref_ac_columns_search=true.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-09-2022 02:22 AM
list collector is referring to which table?
which field other than name you want user to see?
add it there
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-09-2022 03:01 AM - edited 12-09-2022 03:17 AM
This is referring to a custom table and I need to see description next to name.
As I pasted above , I used both name and description in the attribute
ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_name;u_description,no_filter,ref_ac_columns_search=true.