Reference field with 3 columns

[Amit104]

This is related to a variable for a catalog item. I want to create a reference field with 3 columns

i know we can perform search on a reference field for more than one column like ref_ac_columns=name;phone;location

But can we have a reference field with 3 columns as a display value like 'John|+916545123|India' ? And when this value is selected it will give its actual display value which is name for sys_user table in the backend

I got this 'John|+916545123|India' with Lookup select box but when the request is raised it is not showing as a reference value. 

I need to create a variable to display 3 columns as a value and in the backend when the request is raised it should have a reference to the selected record

[Alikutty A]

Hi,

In your lookup select box, you can set the Lookup Value field to Sys_ID. This will store its value as a reference to user table.

If you really need to display it in a reference field, then you can create an additional read only reference variable and populate its value from the lookup select box. The lookup select box will act as input and read only field as the display. You cannot have multiple display value setup on a reference field.

Thanks!

[Rahul Kumar17]

hi

u can set the attribute value

like

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=user_name;email

more details go for this link

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

thanq