I have a requriment that, While requesting the SW, In software variable can we made view of coloums?

mastan babu ko1
Tera Contributor

I have a catalog item in that we have variable called "software to installed" which is reference filed, IF is select any Software we need to show price coloum in the list along with software name. How can we achive that please?

2 REPLIES 2

Ankur Bawiskar
Tera Patron
Tera Patron

@mastan babu ko1 

you can configure the list layout when you click the Lookup icon and then show your fields you want on the list

AnkurBawiskar_0-1744610156786.png

 

AnkurBawiskar_1-1744610183336.png

 

AnkurBawiskar_2-1744610202256.png

 

Also you can add ref_ac_columns so that when user types they see the price

you need to give the ref_ac_columns attributes for that and give the additional fields

I did it for my variable, please use your variable and table and fields

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=category;serial_number,ref_ac_columns_search=true,ref_ac_order_by=name

Variable attributes sections

AnkurBawiskar_3-1744610215435.png

 

Output: I have added category and serial_number as extra fields to be shown along with name

AnkurBawiskar_4-1744610215437.png

 

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

J Siva
Tera Sage

Hi @mastan babu ko1 
You can achieve that in different ways as Ankur mentioned.
The one more way is change the type of the field as Lookup select box and inlcude the price field column in the lookup labels.

JSiva_0-1744611258292.pngJSiva_1-1744611304769.pngJSiva_2-1744611323069.png

Regards,
Siva