Power of Automation::Automate the process of re-opening the Milestone once Task is re-opened.

Hello Everyone,

Here we are again with another requirement that was fulfilled utilizing the Task custom functions.

In general, a custom function is a user-written set of code to achieve a specific requirement. Set the required conditions needed as when to trigger using the Workflow rules (be it Tasks / Project) and associate the custom function to it.

So, many of us would have explored the Gallery custom function - Milestone Autocomplete that will automatically update the status of the Milestone as completed once all the Tasks and Issues associated to the Milestone is closed.

Similarly, here is a custom function code which would update the Milestone status as Reopen when any of the Tasks status that is associated to the Milestone is updated to Reopen.

Custom function code:

endPointV3 = "https://projects.zoho.com/api/v3/portal/";
milestoneStatusIds = List();
milestoneStatusNames = List();
milestoneParameter = Map();

// Get milestone layout details

milestoneLayoutDetails = invokeurl
[
url :endPointV3 + portalId + "/projects/" + projectId + "/milestones/layouts"
type :GET
connection:"xxxxxxxxxx"
];
milestoneCustomFieldDetails = milestoneLayoutDetails.get("section_details").get(0).get("customfield_details");
for each milestoneCustomFieldDetail in milestoneCustomFieldDetails
{

if(milestoneCustomFieldDetail.get("api_name").equalsIgnoreCase("status"))
{
milestoneStatusIds = milestoneCustomFieldDetail.getJSON("picklist_details");
milestoneStatusNames = milestoneCustomFieldDetail.getJSON("picklist_valuemap");
}
}

// Milestone re-open status id

indexOfReopen = milestoneStatusNames.indexOf("Reopen");

// Get milestone details

milestoneResponse = zoho.projects.getRecordById(portalId,projectId,"milestones",milestoneId,"xxxxxxxxxx");
if(milestoneResponse.containKey("milestones"))
{
milestoneStatusId = milestoneResponse.get("milestones").get(0).get("status_det").get("id");
}
else
{
return "Couldn't update status of none milestone";
}
if(milestoneStatusId != milestoneStatusIds.get(indexOfReopen))
{
milestoneParameter = Map();
milestoneParameter.put("milestone_ids",{"" + milestoneId + ""});
milestoneParameter.put("update_fields",{"CUSTOM_STATUSID":"" + milestoneStatusIds.get(indexOfReopen) + ""});
updateMilestoneDetails = invokeurl
[
url :endPointV3 + portalId + "/projects/" + projectId + "/milestones/" + milestoneId + "/updatefieldvalue"
type :POST
parameters:toString(milestoneParameter)
connection:"xxxxxxxxxx"
];
}
return "success";

Make sure to replace xxxxxxxxxx in the above code with the connection name. Screenshot of the list of parameters to be mapped is attached for reference.

By utilising the custom function provided above, we have embraced automation as an alternative to manually adjusting the Milestone's status to "Re-open."

We hope you found this post useful. If you have any questions or wondering if your requirement could be met using custom functions, feel free to share them in the comments section below.