Inserting empty in custom table(Multi row variable set)

Sneha39
Mega Guru

Created MRVS on catalog item and inserting these variable values into the custom table but its adding empty value in the custom table.

 

using below script in task activity of workflow ( As i want task to be created and in the same time variables values to be submitted in custom table as well)

(function() {

        var rowsInt = current.variables.server_request.getRowCount();

        for (var i = 0; i < rowsInt; i++) {

           var grTask = new GlideRecord('u_customtbl);

            grTask.initialize();

            grTask.u_usercerts = current.variables.user_certs;

            grTask.insert();

        }

 

})();

find_real_file.png

 

 

26 REPLIES 26

Can you share the screenshot of workflow?

Thanks
Johnny

Please mark this response as correct or helpful if it assisted you with your question.

RiteshSwarnakar
Giga Guru

Script:

var count = producer.variable_set_name.getRowCount();
var gr = new GlideRecord('custom_table');

for(var i = 0; i < count; i++) {
gr.initialize();
gr.setValue('table_field1', producer.variable_set_name.getRow(i).variable1);
gr.setValue('table_field2', producer.variable_set_name.getRow(i).variable2);
gr.insert();
}