Need to create a multiple record when the form submit

[vinuth v]

Hi All,

I am working on one of the form in this form I am using multi row variable set, contains Product Model, Keyboard Language, Quantity and Serial Number.

When the form submitted these 5 

4RW3GY3
3Q2XBY3
4962GY3
JQW3GY3
7QW3GY3 records will be created in the alm_hardware table.

I tried with the below script

var multiRowSet = [];
var array=[];
var ass;
var sub;
multiRowSet.push(abc);
multiRowSet = JSON.parse(multiRowSet);
workflow.scratchpad.assetlength= multiRowSet.length;
gs.log('start63:' + multiRowSet.length);
for (var i = 0; i < multiRowSet.length; i++) {
array.push(multiRowSet[i].serial_number_1);
ass = multiRowSet[i].serial_number_1;
sub = multiRowSet[i].model2;
gs.log("asssub " + i + multiRowSet[i].serial_number_1+"/"+multiRowSet[i].model2);
gs.log('asssub71:'+ass+ "-"+sub);
var gr1 = new GlideRecord('alm_hardware');
gr1.initialize();
//gr1.addQuery('serial_number',multiRowSet[i].serial_number_1);
// gr1.query();
// if(gr1.next()){
gr1.serial_number=ass;
gr1.install_status = "6";
gr1.stockroom=current.variables.stockroom;
gr1.acquisition_method=current.variables.acquisition_method;
gs.log("stoacq78:"+current.variables.stockroom +"-"+current.variables.acquisition_method);
gr1.model = sub;
gr1.insert();
}

This script is working fine when I give the single Serial number, like below

If I give the multiple serial number, then this script is not working.

Note : Tried without using multi row variable set, and it is working as expected.

var sto=current.variables.stock_reservation;
var serial_number =current.variables.ser_number.toString();
var arrSerialNumber = serial_number.split('\n');
for (var i in arrSerialNumber){
    insertHardwareBySerialNumber(arrSerialNumber[i]);
}

/**
* Create new Hardware by Serial Number
* @return {void}: insert new Hardware record
*/
function insertHardwareBySerialNumber(serial_number){
    var grHardware = new GlideRecord('alm_hardware');
    grHardware.addQuery('serial_number', serial_number);
    grHardware.query();
    if(grHardware.next()){
        return; //return if serial number existed.
    }

 //insert new hardware
    grHardware.initialize();
    grHardware.serial_number = serial_number;
    grHardware.install_status='9';
    //grHardware.substatus='Commissioned';
    grHardware.model=current.variables.Model;
    grHardware.stockroom=current.variables.stockroom;
   // grHardware.location='AE - Dubai City';
}

I need to create a multiple records using multi row variable set( Insert the multiple serial number on the serial number field)

Here I need to create 10 records when form get submitted.

Please any one provide me the input,

Thanks in advance,

Vinuth

[Vishal Birajdar]

Hi @vinuth v 

Can you use below logic :

/*1. Get the MRVS*/
var mrvs = current.variables.<your_mrvs_internal_name>;

/*2. Parse the MRVS*/
var parseMRVS = JSON.parse(mrvs);

/*3. Loop through parsed MRVS*/
for (var i = 0; i < parseMRVS.length; i++) {

/*4. Glide record on Hardware table */ 
var gr1 = new GlideRecord('alm_hardware');
gr1.initialize();
gr1.serial_number=parseMRVS[i].serial_number;   // variable from MRVS
gr1.install_status = "6";
gr1.stockroom=current.variables.stockroom;
gr1.acquisition_method=current.variables.acquisition_method;
gr1.model= parseMRVS[i].model2;  //variable fro  MRVS
gr1.insert();

}

[vinuth v]

Hi @Vishal Birajdar 

The provided script is working fine for single serial number added in the Serial Number field.

But If I mention two Serial numbers like below in the Serial Number field it's not working as expected, I need to create a two records.

Note: On the Serial number field I am giving the serial number like (using '\n')

JJLZ4Z9
JJLZ4Z10
JJLZ4Z11
JJLZ4Z12

But using above script one record is created like below,

[vinuth v]

Below script is working fine, when without using the multi row variable set (single "Serial Number" variable created on the form level)

var sto=current.variables.stock_reservation;
var serial_number =current.variables.ser_number.toString();
var arrSerialNumber = serial_number.split('\n');
for (var i in arrSerialNumber){
    insertHardwareBySerialNumber(arrSerialNumber[i]);
}

/**
* Create new Hardware by Serial Number
* @return {void}: insert new Hardware record
*/
function insertHardwareBySerialNumber(serial_number){
    var grHardware = new GlideRecord('alm_hardware');
    grHardware.addQuery('serial_number', serial_number);
    grHardware.query();
    if(grHardware.next()){
        return; //return if serial number existed.
    }

 //insert new hardware
    grHardware.initialize();
    grHardware.serial_number = serial_number;
    grHardware.install_status='9';
    //grHardware.substatus='Commissioned';
    grHardware.model=current.variables.Model;
    grHardware.stockroom=current.variables.stockroom;
   // grHardware.location='AE - Dubai City';
}

[Vishal Birajdar]

HI @vinuth v 

Okh got it...Serial number is Multi line text...

Can you try this...!!  You can adjust your code accordingly

var mrvs = current.variables.<your_mrvs_internal_name>;

/*2. Parse the MRVS*/
var parseMRVS = JSON.parse(mrvs);

/*3. Loop through parsed MRVS*/
for (var i = 0; i < parseMRVS.length; i++) {

/*4. Get the serial number from MRVS & split it , we will get the array*/
var serNum = parseMRVS[i].serial_number_1.toString().split('\n');

/*5. Loop through serNum*/
for(var j=0; j< serNum.length; j++){

/*6. Glide record on Hardware table */ 
var gr1 = new GlideRecord('alm_hardware');
gr1.initialize();
gr1.serial_number = serNum[j];  //serial number
gr1.install_status = "6";
gr1.stockroom=current.variables.stockroom;
gr1.acquisition_method=current.variables.acquisition_method;
gr1.model= parseMRVS[i].model2;  //variable fro  MRVS
gr1.insert();
}
/*End of serNum for loop*/
}
/*End of parseMRVS for loop*/