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]

u_company_phone_number is a custom table, i dont know if it has active field or not.

[Thrupthi]

It has a "active field" as 'u_active'

[Anurag Tripathi]

try this

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.addQuery('u_active', true);

lp.query();

if(lp.next())

{

return lp.getDisplayValue('u_assigned_to');

}
}

});

[Thrupthi]

works all fine..

Thank you so so much for all your help Anurag 🙂

[Anurag Tripathi]

cool. thanks for updating back.