Autopopulate date time field to today + 10 business days using Business rule

[sooriyakala]

Hi All,

I have to auto populate a date time field(due date) in problem Task form when the short description is "RCA" .The date should be current day + 10 Business days.

[Anurag Tripathi]

Have you seen this

https://docs.servicenow.com/bundle/kingston-application-development/page/app-store/dev_portal/API_reference/GlideDateTime/concept/c_GlideDateTimeAPI.html#ariaid-title4

[Shishir Srivast]

You can create a onChange() Client script on short description field to check if it has RCA text then make the GlideAjax call to add number of days. Please check if this helps.

Onchange()

function onChange(control, oldValue, newValue, isLoading, isTemplate) {
if (isLoading || newValue === '') {
return;
}

if(newValue.match(/RCA/g).length == 1){
var gr = new GlideAjax('MyDateTimeAjax');
gr.addParam('sysparm_name', 'setBusinessDays');
gr.getXML(ajaxResponse);
}

function ajaxResponse(serverResponse) {
var answer = serverResponse.responseXML.documentElement.getAttribute("answer");
g_form.setValue('u_due_date', answer);
}
}

Client callable Script Include:

var MyDateTimeAjax = Class.create();
MyDateTimeAjax.prototype = Object.extendsObject(AbstractAjaxProcessor, {
setBusinessDays: function () {
var gdt = new GlideDateTime();

if(gdt.getDayOfWeekLocalTime() == 6)
gdt.addDaysLocalTime(13);
else if(gdt.getDayOfWeekLocalTime() == 7)
gdt.addDaysLocalTime(12);
else
gdt.addDaysLocalTime(14);

return gdt.getDisplayValue();
},
type: 'MyDateTimeAjax'
});

[sooriyakala]

Thanks Shishir..

It is not working 😞

[Shishir Srivast]

Can you please share the screen and also can you please confirm if RCA keyword would be added when you are going to create the PR ?