How i can set the "Due Date" field (on the fly) to be equal to Today date, when the "Status" dropdown list is changed to "In progress"

Question

I am working on an issue tracking list inside SharePoint enterprise server 2013, where it contains these fields:-

• 1. “Due Date”
• 2. Item status

Now our customer, asked us to implement this capability:-

When a user change the item status to be “In progress”, to change the “Due Date” to be equal to today date.

Now my question is what are the approaches I can follow within SharePoint, to implement this inside the create form, edit form & quick edit grid?

From a pure development point of view, I can write a JavaScript which fires when the item status got changed to “In progress”, and populate the “Due Date” field to be equal to today date.. But not sure how I can implement this inside SharePoint? In a way that can work on create & edit forms, and on the quick edit grid?

Thanks

Answer 1

For client-side implementation, use JSLink to override field rendering. You can also add your javascript dropdown change handler to PostRender function of JSLink.

Using server side, you can use event receiver to calculate Due Date on item created and updated events.

Answer 2

Client side rendering or code to set fields won't work in datagrid view. I recommend using a workflow. Using the Wait For action (run workflow on create) is a better option than checking the status every time an item is edited.

Answer 3

A simple workflow could accomplish this.

May need to add some additional logic to prevent due date from being set again if the item is going to be modified frequently.