Automation Series: Auto-update Phase Status

Hello Folks!

You can auto-update your phase's status based on status of underlying tasks using custom functions.

In this series, we will showcase how to create and run custom functions, using Deluge, with ease. Follow the steps below and automate your project management process.

Use-case

Consider a scenario where a sales representative manages all his customers conversations as tasks in Zoho Projects. To stay organised, he divides the year into four quarters and sets up one milestone for each.
He wants the milestone status to be updated automatically once all the tasks in a milestone are updated.

So, if every task in Q1 is marked In Progress, the milestone status should automatically be updated to In Progress. When all tasks are Completed, the milestone should also be completed.

Configuration Flow

To automate this process, the sales representative should

1. Create custom status for tasks and milestones.
   
2. Establish a connection.
   
3. Create a custom function using Deluge.
   
4. Define a Workflow Rule to set a trigger.
   

Create Custom Status:

Create a custom status by double-clicking the Status column name in the milestone and task list view.

Establish a connection:

A Connection is a secure and reusable authentication layer that lets your custom functions and integrations communicate with external services or other Zoho apps.

Users can select the relevant scopes to create a connection. Scopes for this particular use case are,

Zohoprojects.portals.all,

Zohoprojects.projects.all,

Zohoprojects.tasks.all,

Zohoprojects.milestones.all

Click here to learn how to establish a connection.

Create a custom function:

You don't need development expertise to execute this custom function. Zoho Projects manages the underlying execution. Simply add the function code, map the required inputs, and the system will run it automatically whenever the workflow is triggered.

Sample connection name - milestonestatus

Sample status name - In Review

Arguments required:

Arguments are variables or parameters that pass an input value to execute a custom function.

1. //scopes: Zohoprojects.portals.all, Zohoprojects.projects.all, Zohoprojects.tasks.all, Zohoprojects.milestones.all
2. endPointV3 = "https://projects.zoho.in/api/v3/portal/";
3. endPoint = "https://projects.zoho.in/restapi/portal/";
4. milestoneStatusIds = List();
5. milestoneStatusNames = List();
6. milestoneParameter = Map();
7. statusName = "In Review";
8. indexValue = 0;
9. rangeValue = 100;
10. taskStatusId = "";
11. state = true;
12. // Get task layout details
13. taskLayoutDetailsResponse = invokeurl
14. [
15. url :endPoint + portalId + "/projects/" + projectId + "/tasklayouts"
16. type :GET
17. connection:"milestonestatus"
18. ];
19. statusDetails = taskLayoutDetailsResponse.get("status_details");
20. for each status in statusDetails
21. {
22. if(status.get("name").notContains(statusName))
23. {
24. taskStatusId = taskStatusId + status.get("id") + ",";
25. }
26. }
27. taskStatusId = taskStatusId.removeLastOccurence(",");
28. taskResponse = zoho.projects.getRecordById(portalId,projectId,"Tasks",taskId,"milestonestatus");
29. milestoneId = taskResponse.get("tasks").get(0).get("milestone_id");
30. id_list = taskStatusId.toList(",");
31. chunk_size = 4;
32. count = 0;
33. chunk = List();
34. all_chunks = List();
35. for each id in id_list
36. {
37. count = count + 1;
38. chunk.add(id);
39. if(count == chunk_size)
40. {
41. all_chunks.add(chunk);
42. chunk = List();
43. count = 0;
44. }
45. }
46. if(chunk.size() > 0)
47. {
48. all_chunks.add(chunk);
49. }
50. for each sub_chunk in all_chunks
51. {
52. param = sub_chunk;
53. // Get All Tasks
54. taskParameter = Map();
55. taskParameter.put("custom_status",param.toString());
56. taskParameter.put("index",indexValue);
57. taskParameter.put("range",rangeValue);
58. taskParameter.put("milestone_id",milestoneId);
59. tasks = zoho.projects.getRecords(portalId,projectId,"tasks",taskParameter,0,"milestonestatus");
60. if(tasks.containKey("tasks"))
61. {
62. state = false;
63. break;
64. }
65. }
66. if(state)
67. {
68. // Get milestone layout details
69. info "in";
70. milestoneLayoutDetails = invokeurl
71. [
72. url :endPointV3 + portalId + "/projects/" + projectId + "/milestones/layouts"
73. type :GET
74. connection:"milestonestatus"
75. ];
76. milestoneCustomFieldDetails = milestoneLayoutDetails.get("section_details").get(0).get("customfield_details");
77. for each milestoneCustomFieldDetail in milestoneCustomFieldDetails
78. {
79. if(milestoneCustomFieldDetail.get("api_name").equalsIgnoreCase("status"))
80. {
81. milestoneStatusIds = milestoneCustomFieldDetail.getJSON("picklist_details");
82. milestoneStatusNames = milestoneCustomFieldDetail.getJSON("picklist_valuemap");
83. }
84. }
85. // Milestone re-open status id
86. indexOfReopen = milestoneStatusNames.indexOf(statusName);
87. // Get milestone details
88. milestoneResponse = zoho.projects.getRecordById(portalId,projectId,"milestones",milestoneId,"milestonestatus");
89. if(milestoneResponse.containKey("milestones"))
90. {
91. milestoneStatusId = milestoneResponse.get("milestones").get(0).get("status_det").get("id");
92. }
93. else
94. {
95. return "Couldn't update status of none milestone";
96. }
97. if(milestoneStatusId != milestoneStatusIds.get(indexOfReopen))
98. {
99. milestoneParameter = Map();
100. milestoneParameter.put("milestone_ids",{"" + milestoneId + ""});
101. milestoneParameter.put("update_fields",{"CUSTOM_STATUSID":"" + milestoneStatusIds.get(indexOfReopen) + ""});
102. updateMilestoneDetails = invokeurl
103. [
104. url :endPointV3 + portalId + "/projects/" + projectId + "/milestones/" + milestoneId + "/updatefieldvalue"
105. type :POST
106. parameters:toString(milestoneParameter)
107. connection:"milestonestatus"
108. ];
109. info updateMilestoneDetails;
110. }
111. }
112. return "success";

Define a Workflow Rule:

After creating the custom function, define a task-based workflow rule. Set the trigger as "when task is updated" and associate the custom function under Add Action.

Once the workflow rule is triggered, the custom function will update the phase status automatically.

We hope you found this post to be helpful. If you have any questions, please leave a comment below or email us at support@zohoprojects.com.

• Topic Participants

• Priyadharshini J

  

• Sticky Posts

• Introducing the Zoho Projects Learning Space

  Every product has its learning curve, and sometimes having a guided path makes the learning experience smoother. With that goal, we introduce a dedicated learning space for Zoho Projects, a platform where you can explore lessons, learn at your own pace,

• Update on V2 API End-of-Life Timeline

  Dear Users, Earlier this year, we shared the launch of the V3 APIs and requested users to migrate from the older V2 APIs by December 2025. We have received valuable feedback from our users and partners regarding their migration timelines. We are happy

• Automation Series: Auto-update Phase Status

  Hello Folks! You can auto-update your phase's status based on status of underlying tasks using custom functions. In this series, we will showcase how to create and run custom functions, using Deluge, with ease. Follow the steps below and automate your

• Automate Timesheet Approvals with Multi-level Approval Rules

  Introducing Approval Rules for Timesheets in Zoho Projects. With this automation, teams can manage how timesheets are reviewed and approved by setting up rules with criteria and assigning approvers to handle submissions. Timesheet, when associated to

• Accessibility Spotlight Series - 1

  Every user interacts with products differently, what feels intuitive to one may be challenging for another. Addressing this, accessibility is built into Zoho Project's design philosophy. This helps users navigate and perform actions with ease irrespective

• Recent Topics

• To print Multiple delivery notes in batches

  In Zoho Books, we can print a Delivery Note from an Invoice using the Print Delivery Note option, but it is non-editable and always prints all line items from the invoice. Our requirement is to deliver invoiced items in batches and print delivery notes

• Open sub form from a button as a popup form

  Is there a way within a form to use similar code as below to show a button in the form when clicked opens the subform for data to be added to the record being viewed in the form OpenUrl("#Form:<Customer_Delivery_Address>?<Delivery_Address>=" + input.ID,"popup

• UPLOAD A CREATED PDF AUTOMATICALLY

  Using the html header pdf+print button, I have managed to find a way to have a user create a pdf using entered form data. Using the schedule button, I can have a "file uploaded" pdf mailed to someone as an attachment. The missing piece is to be able to add the pdf, created in that html page to a file upload field automatically? Right now one has to save it to computer and then upload it in a FILE UPLOAD FIELD. Any help would appreciated !  

• Save HTML Snippet Page as PDF with Dynamic Data in Zoho Creator (Working Solution)

  Hi Zoho Creator Community 👋, I faced a common challenge while working with HTML Snippet Pages — I needed to generate a PDF with dynamic data and save it back into the record automatically. Here’s the working solution that might help others. Use Case

• Fix the speed

  It takes ages to load on every step even though my dataset is quite small.

• Consolidated Department-wise Payroll Cost Summary Report

  Hello Zoho Payroll Team and Community, I am writing to discuss a reporting requirement regarding department-level expense tracking within Zoho Payroll. As we scale and manage salary distribution for employees across multiple departments, such as Accounts,

• Write-Off multiple invoices and tax calculation

  Good evening, I have many invoices which are long overdue and I do not expect them to be paid. I believe I should write them off. I did some tests and I have some questions:  - I cannot find a way to write off several invoices together. How can I do that,

• What's new in Zoho Sheet: Simplify data entry and collaboration

  Hello, Zoho Sheet community! Last year, our team was focused on research and development so we could deliver updates that enhance your spreadsheet experience. This year, we’re excited to deliver those enhancements—but we'll be rolling them out incrementally

• CRM gets location smart with the all new Map View: visualize records, locate records within any radius, and more

  Hello all, We've introduced a new way to work with location data in Zoho CRM: the Map View. Instead of scrolling through endless lists, your records now appear as pins on a map. Built on top of the all-new address field and powered by Mappls (MapMyIndia),

• Easier onboarding for new users with stage descriptions

  Greetings, I hope all of you are doing well. We're happy to announce a recent enhancement we've made to Bigin. You can now add descriptions to the stages in your pipeline. Previously, when creating a pipeline, you could only add stages. With this update,

• Ability to Edit Ticket Subject when Splitting a Ticket

  Often someone will make an additional or new request within an existing ticket that requires we split the ticket. The annoying part is that the new ticket maintains the subject of the original ticket after the split so when the new ticket email notification

• How to remove chat icon from knowledge base?

  I have set up a knowledge base to hold FAQs and documentation. It is currently standalone, and not integrated into our website. On every page there is a chat button in the bottom left corner that says "We're offline, please leave a message." How can I

• [ZohoDesk] Improve Status View with a new editeble kanban view

  A kanban view with more information about the ticket and the contact who created the ticket would be valueble. I would like to edit the fields with the ones i like to see at one glance. Like in CRM where you can edit the canvas view, i would like to edit

• Automated Dismissal of Specific Notifications and Centralized Control of Toast Notification Settings

  Dear Zoho Team, I hope this message finds you well. We would like to request two enhancements related to notification handling within Zoho Desk: Automatic Dismissal of Specific Notifications: Currently, when certain actions are taken in the ticket list

• Knowledgebase SEO

  We have a custom-domain mapped help center that is not restricted via login. I have some questions: a) will a robots.txt file still allow us to control indexing? b) do we have the ability to edit the sitemap? c) do category URLs get indexed by search

• Create case via email

  Good Afternoon, I have just registered and am taking a look around the system. Is it possible to create a case via email.  I.e. an employee/client/supplier emails a certain address and that auto generates the case which then prompts a member of staff

• Show field in spreadsheet view depending on other field value

  Hello. Not sure if this is possible but let's say i have spreadsheet view in Creator with four different fields Field A, B, C and D Then i have a field named Response which for one record could contain only one of the pre-definde choices below A, B, C

• Improved Contact Sync flow in Google Integration with Zoho CRM

  Hello Everyone, Your contact sync in Google integration just got revamped! We have redesigned the sync process to give users more control over what data flows into Google and ensure that this data flows effortlessly between Zoho CRM and Google. With this

• Introducing Assemblies and Kits in Zoho Inventory

  Hello customers, We’re excited to share a major revamp to Zoho Inventory that brings both clarity and flexibility to your inventory management experience! Presenting Assemblies and Kits We’re thrilled to introduce Assemblies and Kits, which replaces the

• Intergrating multi location Square account with Zoho Books

  Hi, I have one Square account but has multiple locations. I would like to integrate that account and show aggregated sales in zoho books. How can I do that? thanks.

• Zoho Learn Zapier Integration

  Hello all, Is there any plan to integrate Zoho Learn with Zapier? It seems almost all Zoho products are in Zapier, with the exception of Learn and Marketing Automation.

• Notice: SalesIQ integration paused on Zoho Sites

  I have this notice on my Zoho Sites in the SalesIQ integration setup. Can someone assist? "This integration has been temporarily paused for users. Reconnecting SalesIQ after disconnection will not be possible until we provide further updates." thank

• Differences between Zoho Books and Zoho Billing

  Without a long drawn out process to compare these. If you were looking at these Books and Billing, what made you opt for one and not the other. Thanks

• New Feature : Copying tickets with all the contents such as conversations/history/attachments etc

  Sometimes our customers and distributors do create tickets (or send emails) which contain more than one incident in them and then also some of the further conversations which are either created by incorrect new tickets or replies to old tickets are being created as combined tickets. In such cases we require to "COPY" the contents of the tickets into separate tickets and merge them into their corresponding original tickets. The "CLONE" feature doesn't copy the contents (especially the conversations

• Como se agregan los empleados

  Necesito saber si para agregar empleados los mismos necesitan tener licencias

• Deluge Error Code 1002 - "Resource does not exist."

  I am using the following script in a Custom Button on a Sales Return. Basically, the function takes the information in the sales return (plus the arguments that are entered by the user when the button is pushed) and creates a return shipping label via

• Adding multiple Attendee email addresses when adding a Zoho Calendar event in Zoho Flow

  I am trying to integrate Notion and Zoho Calendar via Zoho Flow. However, the Attendee email address supported by Zoho Calendar - Create event only supports one email address, so I am having difficulty implementing automation to automatically register

• Deprecation of SMS-based multi-factor authentication (MFA) mode

  Overview of SMS-based OTP MFA mode The SMS-based OTP MFA method involves the delivery of a one-time password to a user's mobile phone via SMS. The user receives the OTP on their mobile phone and enters it to sign into their account. SMS-based OTPs offer

• Books & Desk. Client mapping

  Hi, I’ve been using Zoho Books for several years and am now looking to improve my customer service. I'm experimenting with Zoho Desk and want to sync and map my client data from Zoho Books. However, it seems that mapping requires both contacts to have

• Graceful Handling of Exceeded Option Limits

  Hi Zoho SalesIQ team. I would like to submit a feature request to deal with a bug in salesIQ Current Behavior (Bug): When a dynamic list passed to the Single Select Option Card contains more than 20 options, the Zobot stops responding (freezes/hangs)

• System default SLA descriptions can't be modified

  The system default SLAs have identical descriptions for all SLA levels, but their settings differ. However, I am facing an issue where I cannot modify these descriptions and save the changes. The content of the description box can be edited but the changes

• Adding non-Indian billing address for my Zoho subscription

  Hey Need help with adding a non-Indian billing address for my Zoho subscription, trying to edit the address to my Singapore registered company. Won't let me change the country. Would appreciate the help. Regards, Rishabh

• Zoho Desk - Zoho FSM Integration issue on Mobile and iPad

  Hello Team, I am trying to create a Work Order (WO) using the Zoho FSM integration (Add-on Service) that is integrated with Zoho Desk. The issue is that the integration is not working on mobile devices and iPads. While I am able to create the WO, Request,

• How to create one ZohoCRM organisation out of a multi-organization?

  Hi, we have a multi-org including two different Zoho CRM organizations for two companies using respectively EUR and USD as default currency. I was wondering if there is any easy way to merge the two organizations into just one, so that users may access

• Increase the "Maximum Saved Entries per User" Options Limit

  Hi, You can create lots of saved entries, yet the Limit when you apply one is 25, we may often expect 32 to be in draft, and therefore want to enforce that, can we increase the limit of this field from 25 to 100 (As you can just turn it off and have more

• Gray screen while signing documents

  We are all getting a "gray" screen when trying to sign documents in Zoho sign. Anyone else having issues?

• Reassign Partially Saved Entries

  Hi, I would like to be able to go to Partially Saved Entries and like the option to delete them I would like the option to multi-select and be able to reassign them to another user to complete (Such as when a user has left the company). Thanks Dan

• Improved Integration Failure Information (And Notification Options)

  Hi, When an attachment service for example fails, you just get "Field x - Error", I can check the field it is failing on and find nothing wrong, same file size, type, dimensions, etc. so more information as to the actual issue would be helpful. And an

• Set Frozen Cells in the Report Settings

  Hi, It would be nice to be able to set the frozen cells in the report Settings, and have an option if this is fixed or can be changed after loading (On the next load it still goes back to the Settings). Thanks Dan

• Link Purchase Order to Deal

  Zoho Books directly syncs with contacts, vendors and products in Zoho CRM including field mapping. Is there any way to associate vendor purchase orders with deals, so that we can calculate our profit margin for each deal with connected sales invoices

• Next Page