List collector - how to manupulate data in the dropdown of List collector

GladysI
Kilo Contributor

Hi Team,

I have a list collector where the data is getting retrieved form a table and by default it's taking the 'Name' column. I want to manupulate and concatenate some data to the name column values and display it in the dropdown of the list collector. 

2 REPLIES 2

J Siva
Tera Sage

Hi @GladysI 
Use the variable attribute to display multiple columns in the dropdown suggestions as shown below.

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=<fiedl1>;<field2>;<field3>,ref_ac_columns_search=true,ref_ac_display_value=false

JSiva_1-1746760650639.png

 

 Replace field1field2, and field3 with the field names you want. It will look like the example below.

JSiva_0-1746760498120.png

Regards,
Siva

Ankur Bawiskar
Tera Patron
Tera Patron

@GladysI 

you can use ref_ac_columns attribute and show the additional field in list collector variable as shared by @J Siva 

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