Catalog Items, variables

[Fatemeh Rahimi]

Hi everyone,

I have a table that includes several fields, such as Number and Vehicle Model. I'm trying to use two variables in a catalog item, both referencing this table.

The first variable is Number, which works fine. The second is for Vehicle Model — I set it as a Reference to the same table. However, when I view the catalog item in the Service Portal, the dropdown for this variable still shows the Number field values, instead of the actual Vehicle Model.

I would like the dropdown to display the Vehicle Model field, not the Number. Is there a way to do this without using a script?

Thanks in advance for your help!

[J Siva · Accepted solution]

Hi @Fatemeh Rahimi 

This is the expected behavior of the "Reference" type field. The "Number" field should be set as the display field for that table. If you want to show the Vehicle Model field instead, you can use a "Lookup Select Box" type variable.

Note: Using a Lookup Select Box may cause performance issues if the table has a large number of records.

May I know the reason why you are using two different variables to select the record from the same table.

If you.are looking to Auto-populate the vehicle model based on the number, then you should use "Auto-populate" feature.

Regards,

Siva

[J Siva · Accepted solution]

Hi @Fatemeh Rahimi 

This is the expected behavior of the "Reference" type field. The "Number" field should be set as the display field for that table. If you want to show the Vehicle Model field instead, you can use a "Lookup Select Box" type variable.

Note: Using a Lookup Select Box may cause performance issues if the table has a large number of records.

May I know the reason why you are using two different variables to select the record from the same table.

If you.are looking to Auto-populate the vehicle model based on the number, then you should use "Auto-populate" feature.

Regards,

Siva

[Fatemeh Rahimi]

Thanks, that was really helpful!

[Rafael Batistot]

Hi @Fatemeh Rahimi 

Create a reference variable to look up the Number field (which you've already done), and another variable of type Single Line Text for the Vehicle Model.

Then, create a Catalog Data Lookup Definition, where you map the Number field as the input and the Vehicle Model text field as the output.

[Anubhav24]

Hi @Fatemeh Rahimi ,

Under your variable for vehicle there is variable Attribute under this you can use this attribute "ref_ac_columns" and use the field which you want to display under vehicle variable.

Also you can refer below documentation :

https://www.servicenow.com/docs/bundle/yokohama-platform-administration/page/administer/field-admini...

Please mark correct/helpful if my response helped you