The CreatorCon Call for Content is officially open! Get started here.

Catalog item - reference field to sys_user. get more info

asd22
Tera Contributor

Hello.

 

in my catalog item i have a reference field that goes to sys_user. when i use the drop down reference field in my catalog item i can only see a users "name" and "email". How can i get 1 more tab with info in this reference field? I want "name" "userid" and "email".

3 REPLIES 3

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @asd22 

 

Are you referring this

LearnNGrowAtul_0-1707309088049.png

 

 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0686318

 

  1. Navigate to System UI > Views.

  2. Search for name = sys_ref_list and open the record.

  3. Select the Lists related list.

  4. Search for the table for which you want to change the view and open the record.

    This is the table you are referencing.

    Once you open the record, you will see a related list called List Elements. This related list shows the columns that will be displayed on the pop-up view for the reference field.

  5. Modify the List layout by either deleting columns or adding new ones by clicking New

    If you are creating a new column, you can use the same format as one of the other columns on the view. For example:


    • Element: Column name
    • Position: Position you want this column to be in relation to the rest
    • List ID: Table
*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Sorry, i was trying in native view

 

You need toadd atrribiute

 

LearnNGrowAtul_0-1707309418399.png

 

LearnNGrowAtul_1-1707309436409.png

 

 

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Sandeep Rajput
Tera Patron
Tera Patron

@asd22 Navigate to your Reference field on catalog item and put following lines in the variable attribute field on your reference field.

 

Screenshot 2024-02-07 at 6.02.38 PM.png

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=name;user_name;email,ref_ac_order_by=user_name,ref_ac_columns_search=true

 

Here is the outcome

Screenshot 2024-02-07 at 6.00.51 PM.png

Hope this helps.