Client script to work only when the record is active

[Thrupthi]

Hi,

I have two forms as mentioned below

1. SIM

2.Company phone

I have return the below client script to populate assigned to information from company phone table in SIM form, when phone number field is populated and it is working fine.

I want the help for little additional thing, that is this client script should work only when both SIM and Company phone number is active.

The field is Active (u_active). How do i do it?

Client script:

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

var lp = new GlideAjax('Displaysimassignedto');

lp.addParam('sysparm_name','simassignee');

lp.addParam('sysparm_simdetails',g_form.getValue('u_associated_phone_number'));

lp.getXML(assignees);

function assignees(response)

{

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

g_form.setValue("u_assign", answer);

}
}

[Anurag Tripathi]

Yes for that you will have to make the change in your script include (Displaysimassignedto) also.

Include the active clause there too.

Finally getting somewhere.

Please mark my answer correct/helpful if it solves your issue.

-Anurag

[Thrupthi]

how do we use a clause for that script again? 

[Anurag Tripathi]

I believe in the script include function will have a glide record, in that gliderecord you will need to add another addQuery

[Thrupthi]

No Anurag it dint work..

can i get your help here again with the script please

Server Script :

var Displaysimassignedto = Class.create();

Displaysimassignedto.prototype = Object.extendsObject(AbstractAjaxProcessor, {

simassignee : function(){

var lp = new GlideRecord("u_company_phone_number");

lp.addQuery("sys_id",this.getParameter('sysparm_simdetails'));

lp.query();

if(lp.next())

{

return lp.getDisplayValue('u_assigned_to');

}
}

});

[Thrupthi]

Hi Anurag, can you please help me with this server script