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,

I think there is no issue with removal of choice form select box. Can you please share your script so that we can take a look.

[patricklatella]

Hi Pradeep,

thanks for the reply.   Here's my script include so far.   Still working on my client script, any help would be great.   I'll reply with what I have so far in a couple minutes

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',region);

RegionRec.query();

// Query user records

if(RegionRec.next())

{

retVal = RegionRec.u_region;//name of field with info you want to grab

}

return retVal;

}

[Pradeep Sharma]

Sure. In the meanwhile adjust the line RegionRec.addQuery('sys_id',region); to RegionRec.addQuery('sys_id',location);

[patricklatella]

great thanks.   So here's my client script so far.

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

}