Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

how to get list collector selected values in to "description" field

keerthilatha
Tera Expert

Hi Team,

I have to show record producer-list collector selected values in to "description" field on the table. i have written below code on record producer script cell. please correct me if any wrong here. because it is not working as expected

var myList = g_form.getValue('u_include_all_worker_locations_select_co');

var myArray = myList.split(',');

for (var i = 0; i < myArray.length; i++) {

        var gr = new GlideRecord('core_country');

        if (gr.get(myArray[i])) {

                  // Do what you want to the retrieved record

v_desc += '\nSelected Countries to include :'+ producer.u_include_all_worker_locations_select_co;

        }

}

1 ACCEPTED SOLUTION

Edit :




var myList = producer.u_include_all_worker_locations_select_co.toString();


if(myList !='') {


var myArray = myList.split(',');


var str='';


for (var i = 0; i < myArray.length; i++) {


        var gr = new GlideRecord('core_country');


      if (gr.get(myArray[i])) {


str += 'Selected Countries to include :'+ gr.name ;



        }


}


current.v_desc =str;


}


View solution in original post

21 REPLIES 21

Hi Mihir,


it is returning sys id's.


and if i selected 2 values it is showing 2 sys id's in to 2 lines. please see below screen shot.


My Code:


var myList = producer.u_include_all_worker_locations_select_co.toString();


var myArray = myList.split(',');



for (var i = 0; i < myArray.length; i++) {


        var gr = new GlideRecord('core_country');


        if (gr.get(myArray[i])) {


                  // Do what you want to the retrieved record


v_desc += '\nSelected Countries to include :'+ producer.u_include_all_worker_locations_select_co;


        }


}



find_real_file.png


In place of



v_desc += '\nSelected Countries to include :'+ producer.u_include_all_worker_locations_select_co;



line you have to use



v_desc += '\nSelected Countries to include :'+ gr.name;


Hi Mihir, This is worked but please help with out creating 3 times and should be created as in same line with comma separated.



var myList = producer.u_include_all_worker_locations_select_co.toString();


var myArray = myList.split(',');



for (var i = 0; i < myArray.length; i++) {


        var gr = new GlideRecord('core_country');


      if (gr.get(myArray[i])) {


v_desc += '\nSelected Countries to include :'+ gr.name;



        }


}



find_real_file.png


Try this



var myList = producer.u_include_all_worker_locations_select_co.toString();


var myArray = myList.split(',');


var str='';


for (var i = 0; i < myArray.length; i++) {


        var gr = new GlideRecord('core_country');


      if (gr.get(myArray[i])) {


str += 'Selected Countries to include :'+ gr.name ;



        }


current.v_desc =str;


}


Edit :




var myList = producer.u_include_all_worker_locations_select_co.toString();


if(myList !='') {


var myArray = myList.split(',');


var str='';


for (var i = 0; i < myArray.length; i++) {


        var gr = new GlideRecord('core_country');


      if (gr.get(myArray[i])) {


str += 'Selected Countries to include :'+ gr.name ;



        }


}


current.v_desc =str;


}