MRVS How to iterate and check each row if a variable value is not empty

[Ljone]

Hi,

I have an Onsubmit client script that should check if for each rows, 1 variable: 'member_replacement' is not empty and all rows are filled in. How to achieve this? 

We are auto-populating the addtion of row  and users need to update each row variable:member_replacement

below is my current script but not working .  Thank you.

function onSubmit() {
//Type appropriate comment here, and begin script below

var multiRowVariableSet = JSON.parse(g_form.getValue('group_creation_members')); //internal name mrvs
var numberOfRows = multiRowVariableSet.length;

for (var i = 0; i < multiRowVariableSet.length; i++) {
alert(numberOfRows);

if(multiRowVariableSet[i].member_replacement == ""){                //variable name
alert("With Value "+ multiRowVariableSet.member_replacement + " " + multiRowVariableSet.group_member_name);
}
else{
alert("Without Value "+ multiRowVariableSet.member_replacement + " " + multiRowVariableSet.group_member_name);

}
}

 }

[Brian Lancaster]

Just wondering my you would not just make the variables in the mrvs mandatory instead?  That way you don't need an onsubmit client script.

[Ljone]

Hi Brian, the value of the MRVS is dependent to another field and is auto-populated based on that, users are required to update 2 variables from that row. We have ui policy that enforces the mandatory when user clicks the EDIT form, but we have no way of checking if user did not click the EDIT icon. can you help please?

[Narsing1]

Hi,

Try like this.

var mrv = JSON.parse(g_form.getValue('group_creation_members')); // mrvs internal name

for(var row=0; row < mrv.length; row++){

if(mrv[row]["<sysid of member_replacement>"] == "" && mrv[row]["<sysid ofgroup_member_who_are_you_replacing>"] == ""){

alert('empty column');

}

}

Please mark it as correct answer if it helps.

[Ljone]

Hi Narsing, the sys_id doesn't seem to work. i updated my script to below but no luck, the if/else statement is not working properly. can you help please?

var multiRowVariableSet = JSON.parse(g_form.getValue('group_creation_members'));
var numberOfRows = multiRowVariableSet.length;

for (var i = 0; i < multiRowVariableSet.length; i++) {
alert(numberOfRows);

if(multiRowVariableSet[i].member_replacement == ""){
alert("With Value "+ multiRowVariableSet.member_replacement + " " + multiRowVariableSet.group_member_name);
}
else{
alert("Without Value "+ multiRowVariableSet.member_replacement + " " + multiRowVariableSet.group_member_name);

}
}