Inserting empty in custom table(Multi row variable set)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-31-2022 10:00 PM
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();
}
})();
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-01-2022 03:26 AM
Can you share the screenshot of workflow?
Johnny
Please mark this response as correct or helpful if it assisted you with your question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-27-2022 11:58 PM
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();
}