Hi,
you cannot have onChange validation on MRVS variable set.
So the only way is:
1) create onSubmit client script which applies on UI Type - ALL and Applies on Catalog Item
2) parse the JSON value from MRVS
3) sum up all the values
4) if it is more than 100 then ask user to remove rows and stop form submission
function onSubmit(){
var values = g_form.getValue('mrvsVariableName'); // give here mrvs variable name
var total = 0;
var parser = JSON.parse(values);
for(var i=0;i<parser.length;i++){
total = total + parseInt(parser[i].proportionVariableName); // give here the variable name for proportion
}
if(total >100){
g_form.addErrorMessage('Not allowed beyond 100 proportion');
return false;
}
}
Regards
Ankur
Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
