Client Script to set form due_date based on "start_date" variable

[Bcrant]

Afternoon.

Hoping to get some guidance on a client script to set due_date on a task from to 3 days prior to a variable date input on employee start date. Any assistance is appreciated as my initial attempts with onLoad client script haven't produced desired result.

Thanks!

[-O-]

If this is a Catalog Item, you should do this in the Flow or Workflow that runs for it.

If this is a Record Producer, you should do this in an insert before business rule.

It is easier to do it server side, plus it is not nice to modify values onLoad - it will be registered as a change and the user will get a data loss prompt even though no modification have been made - confusing.

[Pavankumar_1]

Hi @Bcrant ,

Use before update/insert  business rule on the sc_req_item table and give specific condition when it needs to update.

Use below script on business rule

(function executeRule(current, previous /*null when async*/ ) {

    var startdate = current.variables.start_date;

    var dt = new GlideTime();
    var time = dt.getDisplayValue().split(' ')[1];//get time
    var finaldatetime = startdate + ' ' + time; //it will give start date and time

    var gdt = new GlideDateTime(finaldatetime); //using finaldatetime to subtract 3 days from start date
    gdt.addDays(-3); //substract 3 days
    current.due_date = gdt;//update on due date field

})(current, previous);

[-O-]

current.update() - really?

[Pavankumar_1]

Hi @-O- ,

I know it is not recommended but we can these lines when we can't avoid current.update()

current.setWorkflow(false);
current.update();
current.setWorkflow(true);