How to create OnChange Client script for Multiple Row Variable set depending on main Catalog Item?

Kruthika BM · ‎06-14-2023

Hello Everyone,

We have the requirement where there are variables like Project start date and end date and also, Work package start date and end date on the main form. And, on the MRVS we have only Work package start date and End date.

Now, the work package start date and end date on the MRVS, should depend on the project start date and end date of the main form.

Is there any Possibilities to create OnChange Client script for Multiple Row Variable set depending on the main Catalog Item?

Can anyone please help with this?

Thanks and Regards,

Kruthika

Brad Bowman · ‎06-14-2023

You can simply use g_service_catalog.parent.getValue... to get the main form variable values in an MRVS script.

https://developer.servicenow.com/dev.do#!/reference/api/rome/client/g_service_catalogClientAPI#g_ser...

View solution in original post

Brad Bowman · ‎08-02-2023

So your onChange script would look more like this now to only run for one specific Catalog Item:

function onChange(control, oldValue, newValue, isLoading) {
    if (isLoading || newValue == '') {
        return;
    }
    var catitem = '';
    if (this) { //Service Portal method
        catitem = this.cat_g_form.getUniqueValue();
    } else { //native UI method
        catitem = parent.g_form.getUniqueValue();
    }

    if (catitem == '964185f78726a9100b25986d3fbb35c1') { //replace with the sysid of your Catalog Item
        var ProjectStartDate = g_service_catalog.parent.getValue('value of project start date of catalog item');
        var ProjectEndDate = g_service_catalog.parent.getValue(‘value of project end date of catalog item');
        var WorkPackageStartDate = g_form.getValue(‘MRVS wrkpckgestart date’);
        if (ProjectStartDate != '' && ProjectEndDate != '') { 
            if(!((WorkPackageStartDate >= ProjectStartDate) && (WorkPackageStartDate <= ProjectEndDate))) {
                g_form.addErrorMessage("Please enter the dates in between Your Project Start Date and Project End Date i.e " +ProjectStartDate+" and "+ProjectEndDate);
                g_form.clearValue((‘MRVS wrkpckgestart date’);
            } 
        } else {
            g_form.addErrorMessage('Please Enter Project Start Date and Project End Date');
            g_form.clearValue((‘MRVS wrkpckgestart date’);
        }
    }
}

then create an onLoad Catalog Client Script that applies to the Catalog Item:

function onLoad() {
	if (this) { // only needed for Service Portal
		// 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

Kruthika BM · ‎08-03-2023

I just had one more query, after creating these onload client script for main form and onchange client for MRVS. This will not affect the other catalog client scripts right which we have for MRVS?

Thanks and Regards,

Kruthika

Thanks and Regards,

Kruthika BM

Brad Bowman · ‎08-03-2023

The other client scripts for this Catalog Item and MRVS will be unaffected by the addition of these scripts.

Kruthika BM · ‎08-04-2023

Thank you for the Information.