Form Reference list showing multiple table fields

[Karen16]

Hi,
I thought that using ref_ac_columns on a form reference field allowed you to display multiple fields in the selection list. But I haven't been able to get this to work. Is there something else that allows you to show multiple table fields in the reference dropdown that I'm missing? Basically, we have created a reference table with a title and description. The users will need to see the description in order to select the appropriate title.
Thanks,
Karen

[Community Alums · Accepted solution]

Use this as a template :

ref_ac_columns=u_level2_code;u_level2_name;u_level1_code;name,ref_ac_columns_search=true,ref_ac_display_value=false,ref_auto_completer=AJAXTableCompleter

[Karen16]

Thanks, I was missing the ref_ac_display_value part!

[Community Alums]

Glad I helped !

Cheers!

[Anurag Tripathi]

Hi,

Check this out, very well described.

Auto-complete for reference fields | ServiceNow Docs

From what I understand, you already have a table created. Now you need to add attribute to the reference field, where you are going to point to this new table of yours.

-Anurag