How to change the options in the reference column

[Kentaro Numata]

Hello, It's Ken.

We are creating a form with record producer.

Inside the form, the user can select an asset in the reference column of alm_hardware.

Display Name (display_name) will be displayed when we select the reference column.

We want to change Display Name (display_name) to Asset tag (asset_tag) and Model (model).

"ref_auto_completer=AJAXTableCompleter, ref_ac_columns=asset_tag," is set in Type Specifications -> Variable attributes.
However, Display Name is displayed.

Thanks,

Kentaro.

[Vishal Birajdar · Accepted solution]

Hello @Kentaro Numata 

As it's reference variable, Display name is showing because on table 'alm_hardware' display value is true for this field.

In your case, if possible you can use 'lookup select box' variable.

Lookup field = sys_id

Label = Asset tag

Note : if there are more records use reference qualifier to restrict the result as it may slow down performance.