Can we display the required the column from the table in the reference field

[Community Alums]

Hi All, 

 having a requirement that, 

In the catalog item we have a reference field. 

Can we get the required column value form the table without changing the display value in the table. 

Is there any other possibility to achieve it. 

Any suggestions. 

[Sohail Khilji]

Hi @Community Alums ,

The idea would be :

On a form level you can create a display business rule which gets the other field info and presents it in the field message. I hope this helps...

or do you mean to ask show 2 field values in field ? explain...

[shyamkumar VK]

@Community Alums , use attribute option display multiple columns

ex;

"Try this in the attributes section instead (replacing "department;id" with your field values): ref_auto_completer=AJAXTableCompleter,ref_ac_columns=department;id,ref_ac_columns_search=true

add this under variable attribute, amend according to your requirement , let me know if you need any more help

Regards,

Shyamkumar