How to hide/disable one multi row variable set(MRVS) based on condition of another Multi Row Variable Set(MRVS) on Record Producer

Raviteja Kunal1 · ‎08-16-2021

Hi All

Need help on Multi Row Variable Set client side scripting on an Record Producer. I have 2 MRVS.

Based on first MRVS entry another needs to be disabled or hidden.

Any suggestions how to achieve or reference is highly appreciated.

Thank You

Brad Bowman · ‎08-16-2021

You need to write an onChange Catalog Client Script within the 1st MRVS, when your particular variable in the variable set changes. So for any row in MRVS1, when a certain value is selected, MRVS2 will become hidden. The script would look like this to hide the 2nd MRVS.

function onChange(control, oldValue, newValue, isLoading) {
   if (isLoading || newValue == '') {
      return;
   }

	if(newValue == 'My Choice'){//replace with the value that should hide MRVS2
		if(this){//Service Portal method
			this.cat_g_form.setDisplay('mrvs2', false);//replace with the internal name of 2nd MRVS
			
		}
		else{//native UI method
			parent.g_form.setDisplay('mrvs2', false);//replace with the internal name of 2nd MRVS
		}
	}
}

If you are using Service Portal, you will also need an onLoad Catalog Client Script within the Record Producer, not the MRVS.

function onLoad() {
	if (this) {//we only need to do this for Service Portal
		//We need to make the g_form object for the parent item available from the MRVS window
		this.cat_g_form = g_form;
	}
}

View solution in original post

LivyaP · ‎01-20-2025

Did you get solution for this query, even i need help on same

asifnoor · ‎08-16-2021

Hi,

you can write onChange client script on one of the fields of 1st MRVS and based on that, hide/show the 2nd mrvs.

Raviteja Kunal1 · ‎08-16-2021

Thank You Asif, any sample script is highly appreciated please because I tried as much I could.

Ankur Bawiskar · ‎08-16-2021

I already shared the sample script to show/hide the MRVS

based on 1 variable of 1st MRVS yes you can hide/show the 2nd MRVS

g_form.setDisplay('2ndMRVSVariableName', false);

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Raviteja Kunal1 · ‎08-16-2021

How to get the values of 1st MRVS?