Copy List collector values to a multi line text field

[Pravallika1]

Hi !!

I am facing issue on how to copy values from left slushbucket in a list collector field to a multi line text field in a record producer using catalog client script.

I have a list collector field which contains some state values , as soon as the user selects some values ,I should exclude those selected values and copy remaing values (left slushbucket) values in a multi line text field.

My list collector field is referenced to select box variable that contains choice values on question choices table.

I am unable to populate the values on change of the list collector variable using catalog client script.

Please do help me with the code.

From the above screenshot , i should be able to populate display users field with all other values from left slushbucket excluding Hawaii & Michigan as soon as the user selects them in list collector variable.

Caltalog Client script:

function onChange(control, oldValue, newValue, isLoading) {

    if (isLoading || newValue == '') {

        return;

    }

    var initialChoices = ['dc8b769893a0021035e6b2ddfaba10cc,1ecb365893a0021035e6b2ddfaba1009,4bebf65893a0021035e6b2ddfaba104e,fc2cfe9893a0021035e6b2ddfaba10e4,7d3cb6909320021035e6b2ddfaba10aa,2e5c3a9893a0021035e6b2ddfaba1066,b66c769893a0021035e6b2ddfaba10d6,ea8cf6d893a0021035e6b2ddfaba101f,ee9cf69893a0021035e6b2ddfaba10c8'];

    var traineeEmailCollection = [];

    var states = [];

    var traineeNameList = g_form.getValue('test_users');

    // give here list collector variable name in above syntax

    var trainees = traineeNameList.split(',');

    for (var j = 0; j < trainees.length; j++) {

        traineeEmailCollection.push(trainees);

    }

    g_form.addInfoMessage('Array=' + traineeEmailCollection);

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

        if (trainees.indexOf(initialChoices[i]) == -1) {

            states.push(initialChoices[i]);

        }

    }

    //g_form.setValue('display_users', states);

    var gaStates = new GlideAjax('u_AjaxUtils');

    gaStates.addParam('sysparm_name', 'getStatesDiff');

    gaStates.addParam('sysparm_states', states);

    gaStates.getXML(SetfieldValues);

    function SetfieldValues(response) {

        var answer = response.responseXML.documentElement.getAttribute("answer");

        g_form.addInfoMessage('answer= ' + answer);

        g_form.setValue('display_users', answer);

    }

}

Script Include:

 getStatesDiff: function() {

        var states = this.getParameter('sysparm_states');

        var statesList = states.split(',');

        var traineeEmailCollection = [];

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

            var gr = new GlideRecord('question_choice');

            gr.addQuery('sys_id', statesList[i]);

            gr.query();

            while (gr.next()) {

                traineeEmailCollection.push(gr.text);

            }

            gs.addInfoMessage('traineeEmailCollection = ' + traineeEmailCollection.toString());

        }

        return traineeEmailCollection.toString();

    },

Please do help me with the code.

Thanks in Advance!!

[Sohithanjan G]

Hi @Pravallika1 ,

Please mark as accepted solution & hit helpful !! if it helped you.

[Pravallika1]

Thanks all for you reply!!

I finally used this code to achieve my functionality.

Catalog Client Script:

function onChange(control, oldValue, newValue, isLoading) {

    if (isLoading) {

        return;

    }

    var selectedStates = g_form.getValue('field name of list collector');

    var selectedStatesArray = selectedStates.split(',');

    var gaStates = new GlideAjax('ajaxUtils');

    gaStates.addParam('sysparm_name', 'getStatesDiff');

    gaStates.addParam('sysparm_states', selectedStatesArray);

    gaStates.getXML(SetfieldValues);

    function SetfieldValues(response) {

        var answer = response.responseXML.documentElement.getAttribute("answer");

        g_form.setValue('give your variable name', answer);

    }

Script include:

 getStatesDiff: function() {

        var initialChoices = gs.getProperty('State Values').split(','); //contains all states sys ids

        var states = this.getParameter('sysparm_states').split(',');

        var StatesCollection = [];

        var finalStates = [];

        //To calculate difference between two arrays and the the remainaing values

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

            if (states.indexOf(initialChoices[i]) == -1) {

                StatesCollection.push(initialChoices[i]);

            }

        }

        //To the state display values for the remaining sys ids

        for (var j = 0; j < StatesCollection.length; j++) {

            var grCompositeTax = new GlideRecord('question_choice');

            if (grCompositeTax.get(StatesCollection[j])) {

                finalStates.push(grCompositeTax.text);

            }

        }

        //To return the remaining state names

        return finalStates.join(',');

},