List collector to show email address along with name

Rohit54 · ‎11-24-2020

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

Ankur Bawiskar · ‎11-25-2020

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

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

View solution in original post

Khan_ Monazzam · ‎05-09-2024

Hi Ankur
Thanks