Is It Possible to Show Multiple Fields in a Single Reference Variable in Service Catalog?

[Flavio Tiezzi]

I have a requirement where I need to display multiple values in a single reference variable within a catalog item.

• Example:
  Table: u_matter
  I need the reference field to display a combination of u_name and u_client_number, such as:
  TPGROUP – 124596

I’m fairly certain this isn’t directly supported, but I’d like to confirm whether there’s any alternative or workaround to achieve this.

As a fallback, I’m considering showing a message below the field to display the combined information.

[Robert H]

Hello @Flavio Tiezzi ,

Please set the Variable attributes field of your reference variable to:

ref_ac_columns=u_name;u_client_number

Demo using a different table:

Result:

Regards,

Robert

[Flavio Tiezzi]

Hi @Robert H. Thanks for your input.

However, after the record is selected, it only displays the display value from the table, right? The requirement is to show both values together after the selection is made.

[Swapna Abburi]

Hi @Flavio Tiezzi

You cannot show the combination of two fields in the reference field/variable after selection is made. You can try below options.

1. You can create another read-only variable and populate both u_name and u_client_number after your reference variable is updated.

2. you can create another field on custom table 'u_matter' something like "Display name" and make it a calculated field by combining u_name and u_client name fields. ***Please note that you need make the newly created field 'display value' as true from dictionary record and this change will be applied in all reference fields/variables where ever this table is used.

[Robert H]

Hello @Flavio Tiezzi ,

Ok, in this case you only have two options:

1. Create a new field on the u_matter table, and an "on Before" Business Rule on the same table with the condition "Name changes OR Client number changes". The script of that BR would then concatenate the two field values and put the result into the new field. Finally, make that new field the Display field of the table.
   This approach would have impact beyond your Catalog Item, though, and will affect all Reference fields for the u_matter table in the platform.
2. Go ahead with your own proposal of showing the concatenated values as a message after making the selection. If you need that concatenated value later as well you could also put it into an additional single line text variable.

Regards,

Robert