Multi row variable set dupicate restriction

[pk2184046]

Hi there, 

I have a multi row variable set having two variables. here is don't want users to select the same option twice below is the code I was trying but it is not working and throwing javascript error in you console.

function onSubmit() {

    var mrvs =parent.g_form.getValue("additional_responsibilities_and_security_roles"); //name of the multi row variable set

       var arr = JSON.parse(mrvs);

    var res = g_form.getValue("responsibility_add");  // name of the variable1

    var sec = g_form.getValue("security_role_add");  //name of the variable2

    for (var i = 0; i < arr.length; i++) {

        if (arr[i].responsibility_add == res && arr[i].security_role_add==sec ) {

            return false;

        }

    }

    return true;

}

Additionally tried in place of parent.getvalue just getvalues same result 

[Robert H · Accepted solution]

Hello @pk2184046 ,

Please use this onSubmit script on your Variable Set:

function onSubmit() {

    var mrvs = g_service_catalog.parent.getValue("additional_responsibilities_and_security_roles");
    if (!mrvs) return true;
    var arr = JSON.parse(mrvs);

    var res = g_form.getValue("responsibility_add");
    var sec = g_form.getValue("security_role_add");
    var duplicate = arr.some(row =>
        row.responsibility_add === res &&
        row.security_role_add === sec);

    if (duplicate) {
		g_form.addErrorMessage('Row with same values already present.');
		return false;
	}

}

Regards,

Robert

[J Siva]

Hi @pk2184046 
Could you share the pic of your MRVS & it's configuration?

Regards,
Siva

[pk2184046]

Hi Siva,

Please see the attached screenshot

[Robert H · Accepted solution]

Hello @pk2184046 ,

Please use this onSubmit script on your Variable Set:

function onSubmit() {

    var mrvs = g_service_catalog.parent.getValue("additional_responsibilities_and_security_roles");
    if (!mrvs) return true;
    var arr = JSON.parse(mrvs);

    var res = g_form.getValue("responsibility_add");
    var sec = g_form.getValue("security_role_add");
    var duplicate = arr.some(row =>
        row.responsibility_add === res &&
        row.security_role_add === sec);

    if (duplicate) {
		g_form.addErrorMessage('Row with same values already present.');
		return false;
	}

}

Regards,

Robert

[pk2184046]

Hi Robert ,

I have tried the above code it's throwing the error and not working