Need to see two columns in reference variable and documented attribute is not working

Kirsten2
Tera Contributor

I have a catalog with a drop down for hardware name and I want the cost to appear next to that. My custom table is the reference table and 'cost' is a field for each record. Name is the main display. 

The attributes I added are: re_auto_completer=AJAXTableCompleter;ref_ac_columns=u_cost;ref_ac_columns_search=true

 

When I fill out the catalog item the dropdown still only shows name.

 

Kirsten2_0-1757551865049.pngKirsten2_1-1757551886487.png

 Any help is appreciated.

2 ACCEPTED SOLUTIONS

Chaitanya ILCR
Mega Patron

Hi @Kirsten2 , 

you have to use comma (,) instead of semicolon(;) in the variable attributes

try putting this in the variable attributes

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_cost,ref_ac_columns_search=true

 

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

View solution in original post

Bhuvan
Mega Patron

@Kirsten2 

 

There is a typo in the variable attributes, it must be 'ref' and comma instead of semicolon

 

Update the variable, save the record and try again. If it does not work, clear the cache or try from Incognito or InPrivate window of your browser.

 

Below is reference post,

 

https://www.servicenow.com/community/servicenow-ai-platform-forum/how-to-get-two-columns-to-display-...

 

If this helped to answer your query, please mark it helpful & accept the solution. 

 

Thanks,

Bhuvan

View solution in original post

7 REPLIES 7

Chaitanya ILCR
Mega Patron

Hi @Kirsten2 , 

you have to use comma (,) instead of semicolon(;) in the variable attributes

try putting this in the variable attributes

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_cost,ref_ac_columns_search=true

 

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

Thank you. I have been trying commas, semi-colons, changing the order and nothing was working. I also realized I had left off the 'f' in 'ref'.

Bhuvan
Mega Patron

@Kirsten2 

 

There is a typo in the variable attributes, it must be 'ref' and comma instead of semicolon

 

Update the variable, save the record and try again. If it does not work, clear the cache or try from Incognito or InPrivate window of your browser.

 

Below is reference post,

 

https://www.servicenow.com/community/servicenow-ai-platform-forum/how-to-get-two-columns-to-display-...

 

If this helped to answer your query, please mark it helpful & accept the solution. 

 

Thanks,

Bhuvan

@Kirsten2 

 

Did you get a chance to review this as I believe the information provided should answer your question

 

If my response helped to answer your query, please mark it helpful & accept the solution.

 

Thanks,

Bhuvan