Is there anyway to get a reference field to show multiple fields when typing in a value?

Wendy Peterson
Giga Guru

I have a reference field where someone starts typing a serial number and it's pointing to the asset table. Is there anyway to get it to display not only the Serial Number but also the Assigned to? It won't let me put the picture in as it shows it's broken but i've attached it. TIA

 

 

6 REPLIES 6

Chris Sanford1
Kilo Guru

Yes, the ref_ac_columns attribute.

See the attributes on the Configuration item column on the task table as an example.

Also see this documentation: Auto-complete for reference fields

I thought that I have ref_ac_columns=serial;assigned_to and it's pointing to the asset table but it doesn't change the display to include the assigned to.

Are you talking about the display value after a value is selected? This is only for auto-complete before a value is selected.

You can only have one column as the display value. You would have to make a custom column that is a calculated field concatenation of serial number and assigned to, then make that column the new display column for the cmdb_ci table.

Also, it's serial_number not serial. That could be a problem possibly. Another thing to check for is dictionary overrides. If you are adding the attribute to the task cmdb_ci field and using the change_request form, for example there could be a dictionary override that overrides the attributes for change requests.