- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-12-2020 06:29 PM
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-12-2020 07:06 PM
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
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-12-2020 07:06 PM
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
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-12-2020 09:19 PM
Thank you Ankur. That did work, however, it's not an option I can use as it is global change as you stated.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-12-2020 07:38 PM
Hello,
Use the below three dictionary attribute for the field to bring your intended result.
ref_ac_columns | list of field names separated by semi-colons | any 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_search | true/false | any 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_value | true/false | any 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_columns, ref_ac_columns_search, and ref_ac_display_value attributes. See Remove the display value column. |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-12-2020 09:23 PM
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.