Hi,

In this article, I will share a code snippet on how to auto populate a multi variable set based on a specific value in the record producer.

In my example, based on a field change in record producer I want to fetch the entries from the database and prefill them in the multirow variable set.

Client Script

function onChange(control, oldValue, newValue, isLoading) {
  if (isLoading || newValue == '') {
    return;
  }
  var ga = new GlideAjax('MyScriptInclude');
  ga.addParam('sysparm_name', 'getItems');
  ga.addParam('sysparm_type', newValue);
  ga.getXML(parseData);

  function parseData(response) {
    var answer = response.responseXML.documentElement.getAttribute('answer');
    var oDetails = JSON.parse(answer);
    var my_varset = g_form.getField("my_multirow_varset"); //get your multivarset
    for(var sKey in oDetails){
      if (sKey == "my_multirow_varset") {
    g_form.setValue(sKey, oDetails[sKey]); //This will set the multirow once the key is matched.
      } else if (sKey == "total_rows") {
          //sets the max rows to the available count, bcoz of which the add button will be disabled. you can also set max_rows_size=0 to disable add.
      my_multirow_varset.max_rows_size = oDetails[sKey]; 
      }
    }

    if(answer == 0) {
      //No data for this Type. So hide the multirow var set
      g_form.addInfoMessage('There are no Items for this Type '+newValue);
      g_form.setVisible('my_multirow_varset',false);
    }
  }
}

Script Include

var MyScriptInclude = Class.create();
MyScriptInclude.prototype = Object.extendsObject(AbstractAjaxProcessor, {
  getItems: function(){
    var itemID = this.getParameter('sysparm_type');
    var oDetails = {};
    var aDetails = [];
    oDetails = new MyScriptInclude().getAllDetails(itemID);
    aDetails = [{
       "total_rows": oDetails["total_rows"],
       "my_multirow_varset": JSON.stringify(oDetails["my_multirow_varset"])
    }];
    return JSON.stringify(aDetails[0]);
  },
  getAllDetails: function(itemID){
    var oDet = {};
    var aDet = [];
    var total_rows=0;
    var grItem = new GlideRecord("mytable");
    grItem.addQuery('u_item_id', itemID);
    grItem.query();
    while(grItem.next()){
      total_rows++;
      oDet = {"type": grItem.u_type+ "",
              "title": grItem.u_title+ "",
              "description": grItem.short_description+ "",
              "in_stock": grItem.u_stock+ "",
              "supervisor": grItem.u_manager+ "",
              "item_number": grItem.u_number+ ""
         };
    aDet.push(oDet);
      }
      return {"total_rows": total_rows, "my_multirow_varset": aDet};
   },

  type: 'MyScriptInclude'
});

To disable edit and delete icons, make the multirow variable set readonly.

You can create a ui policy and can make it readonly or from the client script, you can do it

g_form.setReadOnly('my_multirow_varset',true);

To disable Add button, you can call

my_multirow_varset.max_rows_size=0;

Let me know if you have any questions in the comments below.

Mark the article as helpful and bookmark if you found it useful.