g_form.removeOption for setting choices in a select box

[patricklatella]

Hi gang,

I'm looking to use an onChange client script and a script include to do the following:

- when the "location" field is set on a form I need the onChange client script/script inlude to lookup the 'region' of the entered 'location' from our location table.  

- then based on that location I want to remove certain options from a (separate) select box variable on the form.

I'm seeing a little chatter on the community that using g_form.removeOption may not work on a catalog item?   This is actually going to be on the "Describe Needs" (first page) of an order guide.

Does anyone know if this is possible, whether there's a better way, and can help with the script?

thanks!

[Pradeep Sharma]

Hello Patrick,

Change line from

if{

'answer' = 'APAC';

g_form.removeOption('computer',Workstation);//Workstation is the choice I want to remove

to

if(answer = 'APAC')

{

g_form.removeOption('computer',Workstation);//Workstation is the choice I want to remove

}

[patricklatella]

or maybe this is heading in a better direction:

function onChange(control, oldValue, newValue, isLoading) {

    if (isLoading || newValue == '') {

          return;

    }

    //Type appropriate comment here, and begin script below

    var ga = new GlideAjax('u_New_Hire_Scripts_Ajax');//name of script include

ga.addParam('sysparm_name', 'getRegion');//name of function on script include

ga.addParam('sysparm_user', g_form.getValue('emp_location'));//name of field on form triggering call

ga.getXML(EmployeeRegionLookup); // Always try to use asynchronous (getXML) calls rather than synchronous (getXMLWait)

}

// Callback function to process the response returned from the server

function EmployeeRegionLookup(response) {

var answer = response.responseXML.documentElement.getAttribute("answer");

if(answer == 'APAC'){

g_form.removeOption('computer',Workstation);//Workstation is the choice I want to remove

}}

[patricklatella]

ok, and then to accommodate for multiple responses...something like?

function onChange(control, oldValue, newValue, isLoading) {

    if (isLoading || newValue == '') {

          return;

    }

    //Type appropriate comment here, and begin script below

    var ga = new GlideAjax('u_New_Hire_Scripts_Ajax');//name of script include

ga.addParam('sysparm_name', 'getRegion');//name of function on script include

ga.addParam('sysparm_user', g_form.getValue('emp_location'));//name of field on form triggering call

ga.getXML(EmployeeRegionLookup); // Always try to use asynchronous (getXML) calls rather than synchronous (getXMLWait)

}

// Callback function to process the response returned from the server

function EmployeeRegionLookup(response) {

var answer = response.responseXML.documentElement.getAttribute("answer");

if(answer == 'APAC'){

g_form.removeOption('computer',Workstation);//Workstation is the choice I want to remove

}

if(answer == 'EMEA'){

g_form.removeOption('computer',Desktop);//Workstation is the choice I want to remove

}}

[Pradeep Sharma]

Correct. One more modification.

g_form.removeOption('computer',Workstation); should be g_form.removeOption('computer','Workstation'); //Assuming Workstation is the value of the select box

Same applies to Desktop as well.

[patricklatella]

So my script include needs a tweek, I put in the gs.info and got this

getRegion: function(){//this function is to determine which computers need to be removed from the choice list

var retVal; // Return value

var location = this.getParameter('sysparm_location');

var RegionRec   = new GlideRecord('cmn_location');//table where desired variable lives

RegionRec.addQuery('sys_id',location);

RegionRec.query();

// Query user records

if(RegionRec.next())

{

retVal = RegionRec.u_region.getDisplayValue();//name of field with info you want to grab and send back

}

gs.info('the region is '+retVal);

return retVal;

}