How to concatenate fields in look up select box?

[Radhika11]

Hi,

Currently we are using a lookup select box to get Assigned to data from alm_asset table.  However, it only shows one Assigned to data in the the drop down.  It there a way to concatenate two fields such as "Assigned To and Department" values to display on the drop down?  

Thank you

[anubhavritolia]

Hi Radhika,

I guess we cannot do that as Assigned To is nothing but Reference to User Record. Though it shows name on front end but at backend sys_id is storied.

[Muhammad Khan · Accepted solution]

This should work for you.

[Muhammad Khan]

Output