- 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,619 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
11-25-2020 12:12 AM
Hi,
You need to add like this in the Variable Attributes of the List Collector.
ref_auto_completer=AJAXTableCompleter,ref_ac_columns=name;email,ref_ac_columns_search=true,ref_ac_order_by=name
Thanks,
Narsing
- 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
11-25-2020 04:33 AM
Is there any way Ankur that after I select a user from the list. It should not only show name of the person selected but also name (email). Like here Abel tutter will appear in the box when you select it. However how can I get Abel Tutter (abel@example.com) after selection.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-25-2020 04:43 AM
Hi Rohit,
Not possible.
It would only show 1 field which is display=true
or
in this case name field on user table as there is no field with display=true
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader