How do I get two columns to display in a reference dropdown?

[kimberlylp]

For example when I start typing in a reference field for a sys_user like a record producer I created it shows the user and the email.

The example pic below is from SN documentation showing the name and the department in the dropdown.

How do I do the same on a reference field I have for disposition codes and resolution codes?

[SanjivMeher · Accepted solution]

You can add something like below to the attribute of the field

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=field1;field2,ref_ac_columns_search=true

refernce: https://docs.servicenow.com/bundle/london-platform-administration/page/administer/field-administrati...

[SanjivMeher]

If it worked kindly mark my response correct

[kimberlylp]

Thanks for you help. This was helpful.

[sachin_namjoshi]

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=department;id,ref_ac_columns_search=true

Then after clicking the Magnifying Glass on your new field, right click on one of the column headings and choose Configure > List Layout.

Regards,

Sachin