Display multiple columns on a reference field within a catalog item

[Dellbridges]

Hello, 

I am creating a form for customers to request changes to the hardware approvers. Within the form I have a reference field asking the customer to select which team the approver is to be approving for referencing u_department_approver. 

The display value for the table is set to the approver (name), but I have got the field showing both the department and name when selecting.

However once the customer has made a selection it only shows the display value (name). I really need it to show both in order for the agent dealing with the request to know which team is selected.

I cannot change the display value to department as I have other fields that directly require the approver name. 

Can anyone tell me a way (if it is possible) to force the field to display both 'columns' after selection.

Regards

[Peter Bodelier · Accepted solution]

Hi @Dellbridges 

This is not possible unfortunately.

[CCZMAX1]

Hi Peter, you have have already found a solution for this but if not, I used a multi row variable set to achieve this.

Maxine

[AmolJ]

Variable attribute - ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_field1;u_field2,ref_ac_columns_search=true,ref_ac_order_by=name

[ReutM]

It worked.