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!!

[Ankur Bawiskar]

@Pravallika1 

what debugging have you done so far? what's your findings?

[Sohithanjan G · Accepted solution]

Hi @Pravallika1 
There are a few adjustments needed. Below is the revised version of your script:

function onChange(control, oldValue, newValue, isLoading) {
    if (isLoading || newValue == '') {
        return;
    }

    var initialChoices = ['dc8b769893a0021035e6b2ddfaba10cc','1ecb365893a0021035e6b2ddfaba1009','4bebf65893a0021035e6b2ddfaba104e','fc2cfe9893a0021035e6b2ddfaba10e4','7d3cb6909320021035e6b2ddfaba10aa','2e5c3a9893a0021035e6b2ddfaba1066','b66c769893a0021035e6b2ddfaba10d6','ea8cf6d893a0021035e6b2ddfaba101f','ee9cf69893a0021035e6b2ddfaba10c8'];
    var selectedChoices = g_form.getValue('test_users');
    var selectedChoicesArray = selectedChoices.split(',');
    var states = [];

    for (var i = 0; i < initialChoices.length; i++) {
        if (selectedChoicesArray.indexOf(initialChoices[i]) == -1) {
            states.push(initialChoices[i]);
        }
    }

    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.setValue('display_users', answer);
    }
}

Script Include:

var AjaxUtils = Class.create();
AjaxUtils.prototype = Object.extendsObject(AbstractAjaxProcessor, {

    getStatesDiff: function() {
        var states = this.getParameter('sysparm_states').split(',');
        var traineeEmailCollection = [];

        for (var i = 0; i < states.length; i++) {
            var gr = new GlideRecord('question_choice');
            if (gr.get(states[i])) {
                traineeEmailCollection.push(gr.text);
            }
        }

        return traineeEmailCollection.join('\n');
    }
});

HIT Helpful & Accept Solution !! 

[Akshay Gupta2]

Hi @Pravallika1 

It seems you are on right tracking, try these mentioned changed, I mentioned below, I hope it works for you

The main difference between the old and new code is that the new code uses the GlideAjax API to call the getStatesDiff function in the script include. This is necessary because the getStatesDiff function makes a server-side call to the question_choice table.

I have also removed the unnecessary var keyword from the beginning of some of the variables.

I hope this helps!

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'); // Replace 'test_users' with the actual list collector variable name

  var trainees = traineeNameList.split(',');
  for (var j = 0; j < trainees.length; j++) {
    traineeEmailCollection.push(trainees[j]);
  }
  g_form.addInfoMessage('Array=' + traineeEmailCollection);

  for (var i = 0; i < initialChoices.length; i++) {
    if (trainees.indexOf(initialChoices[i]) == -1) {
      states.push(initialChoices[i]);
    }
  }

  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);
  }
}

And here is the updated code for your 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();
},

Regards,

Akshay Gupta

[Service_RNow]

Hi @Pravallika1 

follow thread it will be helpful

list-collector 

copying-list-collector-values-to-multiline-text-field 

Please mark reply as Helpful/Correct, if applicable. Thanks!