Hello @Samiksha2
To create separate records in a custom table based on list collector values in ServiceNow, you can use a combination of client scripts and server-side scripts
Create an onSubmit client script to capture the list collector values and call a Script Include to create the records.
function onSubmit() {
var listCollectorValues = g_form.getValue('your_list_collector_field'); // Replace with your list collector field name
var ga = new GlideAjax('CreateCustomRecords');
ga.addParam('sysparm_name', 'createRecords');
ga.addParam('sysparm_values', listCollectorValues);
ga.getXMLAnswer(function(response) {
var answer = response.responseXML.documentElement.getAttribute("answer");
if (answer == 'success') {
g_form.addInfoMessage('Records created successfully.');
g_form.submit(); // Submit the form to refresh it
} else {
g_form.addErrorMessage('Error creating records.');
}
});
return false; // Prevent form submission until records are created
}
Create a Script Include to process the list collector values and create records in the custom table.
var CreateCustomRecords = Class.create();
CreateCustomRecords.prototype = Object.extendsObject(AbstractAjaxProcessor, {
createRecords: function() {
var values = this.getParameter('sysparm_values');
if (!values) {
return 'error';
}
var valuesArray = values.split(',');
var customTable = 'u_custom_table'; // Replace with your custom table name
for (var i = 0; i < valuesArray.length; i++) {
var gr = new GlideRecord(customTable);
gr.initialize();
gr.u_field_name = valuesArray[i]; // Replace with your field name and set other fields as needed
gr.insert();
}
return 'success';
},
type: 'CreateCustomRecords'
});
If my response has helped you hit helpful button and if your concern is solved do mark my response as correct.
Thanks & Regards
Viraj Hudlikar.
