Service Portal Widget - How can I display multiple columns for a referenced field

[Peter Bishop]

In the Service Portal, I have a page that's used to add records to a table. On the page is a widget which shows the form from a table and one of the fields in this table is a reference field.

When the user accesses the reference field (to select a value), only the "display=true" column of that referenced table is listed. I have tried adding the collection attribute "ref_ac_columns=column1;column2" but this hasn't made any difference.

Can anyone advise how I can achieve this functionality?

[Pranesh072 · Accepted solution]

try this 

replace your field in highlighted 

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=email,ref_ac_order_by=name

https://community.servicenow.com/community?id=community_question&sys_id=46924b21dbd8dbc01dcaf3231f96...

[Peter Bishop]

Thanks for the info. Unfortunately that doesn't appear to have made any difference.

[Pranesh072]

for me it is working fine 

[Peter Bishop]

Hi. Can you confirm *where* you're setting this? I just want to make sure I'm putting it in the right place:

• Tables - navigate to referenced table
• Show list
• Right-click on referenced field and select Configure/Dictionary
• Select collection
• Select Advanced view
• In the attributes field, I have:
• ref_auto_completer=AJAXTableCompleter,ref_ac_columns=col1;col2,ref_ac_columns_search=true

Does that look right?

Also your "ref_ac_columns" value only shows one column but your screenshot is displaying two 😕