Make reference field only show 1 column from table

asd22
Tera Contributor

Hello, i have a reference field where i only want 1 coloumn to show up thats "budget unit"

asd22_0-1687863653557.png

 

How do i go about doing this?

1 ACCEPTED SOLUTION

Voona Rohila
Kilo Patron
Kilo Patron

Hi @asd22 

Can you explain in detail of your requirement?

You want to show only 1 column when refernce icon is clicked?

You can click on Refernce icon and configure list layout to show the fields that are required.

VoonaRohila_0-1687864987883.png

 


Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for
Kind Regards,
Rohila V
2022-25 ServiceNow Community MVP

View solution in original post

7 REPLIES 7

Voona Rohila
Kilo Patron
Kilo Patron

Hi @asd22 

Can you explain in detail of your requirement?

You want to show only 1 column when refernce icon is clicked?

You can click on Refernce icon and configure list layout to show the fields that are required.

VoonaRohila_0-1687864987883.png

 


Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for
Kind Regards,
Rohila V
2022-25 ServiceNow Community MVP

oh yes sorry, but what you said is just what i wanted. Thank you

only issue i dont have that option in my reference on my record producer:

asd22_0-1687865797669.png

 

Open the record produce in Native UI using Try It Button but This will not be applicable in Portal view.

 

You can also add attributes to the Variable so when user types in the field value will be shown like below

 

VoonaRohila_1-1687866430846.png

To Configure you need to add this in variable dictionary attributes( Modify field names accordingly)

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_budge_unit,ref_ac_order_by=u_budge_unit

https://docs.servicenow.com/bundle/sandiego-platform-administration/page/administer/field-administra...

 


Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for
Kind Regards,
Rohila V
2022-25 ServiceNow Community MVP