HI @virajsapte99
Okay, I understand the requirement. You want to create two records in an MRVS (Multi-Row Variable Set) when the "Swap" checkbox is checked, effectively swapping the values of "User1" and "User2" in the second record.
Here's how you can achieve this in ServiceNow using a Catalog Client Script and potentially a Script Include (for cleaner code):
Catalog Client Script (onChange of the "Swap" variable)---Below is the script---
function onChange(control, oldValue, newValue, isLoading) {
if (isLoading) {
return;
}
// Assuming your MRVS variable name is 'my_mrvs' and 'swap' is the name of the swap checkbox variable.
var mrvs = g_form.getValue('my_mrvs');
var swapChecked = newValue === 'true';
if (swapChecked) {
// Get the current rows of the MRVS
var mrvsRows = JSON.parse(mrvs);
// If rows exist, proceed with swapping logic
if (mrvsRows.length > 0) {
g_form.hideFieldMsg('swap', true); // Hide any previous messages (optional)
// Call a Script Include to handle the swap and add logic (recommended)
var ga = new GlideAjax('SwapMRVSRows');
ga.addParam('sysparm_name', 'addSwappedRow');
ga.addParam('sysparm_mrvs_rows', JSON.stringify(mrvsRows));
ga.getXML(handleSwapResponse);
} else {
// Show a message if there are no rows in MRVS
g_form.showFieldMsg('swap', 'Please add at least one row to the MRVS before swapping.', 'error');
g_form.setValue('swap', 'false'); // Uncheck the swap checkbox
}
}
}
//call back function to process the response from the script include
function handleSwapResponse(response) {
var answer = response.responseXML.documentElement.getAttribute("answer");
if (answer) {
var newRows = JSON.parse(answer);
g_form.setValue('my_mrvs', JSON.stringify(newRows)); // Set the updated rows in the MRVS
//if you are using on submit client script then call this function from there also, with the script include function to create records.
}
}
2. Script Include:The addSwappedRow function receives the MRVS rows.[ You need to brainstorm and develope the script incldue , see the logic below ---]
It iterates through the rows, adding each original row to newRows.
If a row has both user1 and user2 values, it creates a new swappedRow object with the values swapped.
The swappedRow is also added to newRows.
Finally, it returns the updated newRows array as a JSON string.
The createRecords function receives the MRVS rows.
It iterates through the rows, and insert the values into the table.
3. Develope another onSubmit Client Script(Optional)
If you like this opinion and your problem is resolved after reviewing and applying it. Please kindly mark this your best answer‌🌠‌ OR mark it Helpful ‌⛑‌ if you think that you get some insight from this content relevant to your problem and help me to contribute more to this community
MackI | ServiceNow Developer | 2 *Mainline Certification | LinkedIn Top IT Operation Voice 2023 | Sydney,Australia
