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

• Time Log Reminder

  Tracking the time spent on tasks and issues is one of the most important functions of a timesheet. However, users may forget to update the time logs because they have their own goals to achieve. But, time logs must be updated at regular intervals to keep

• 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

• Recent Topics

• 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

• WebDAV / FTP / SFTP protocols for syncing

  I believe the Zoho for Desktop app is built using a proprietary protocol. For the growing number of people using services such as odrive to sync multiple accounts from various providers (Google, Dropbox, Box, OneDrive, etc.) it would be really helpful

• Feature Request - Allow Customers To Pick Meeting Duration

  Hi Bookings Team, It would be great if there was an option to allow customers to pick a duration based on a max and minimum amount of time defined by me and in increments defined by me. For example, I have some slots which are available for customers

• Error Logs / Failure logs for Client Scripts Functions

  Hi Team, While we are implementing client scripts for the automation, it is working fine in few accounts but not working for others. So, it would be great if we can have error Logs for client scripts also just like custom functions. Is there any way that

• Support for Custom Fonts in Zoho Recruit Career Site and Candidate Portal

  Dear Zoho Recruit Team, I hope you're doing well. We would like to request the ability to use custom fonts in the Zoho Recruit Career Site and Candidate Portal. Currently only the default fonts (Roboto, Lato, and Montserrat) are available. While these

• YouTube Live streaming? how to? Zoom has this feature, built-in. Can't find it on zoho meetings.

  YouTube Live streaming? how to? Zoom has this feature, built-in. Can't find it on zoho meetings.

• Feature Request - A Way To Search Item Groups

  Hi Inventory Team, I can't find any way to filter or search by fields of Item Groups. It would be great to see that functionality added. I have a use case where a single product might come from 5 or more suppliers and each supplier's item is an Item in

• Feature Reqeust - Include MPN In Selectable FIelds

  I have noticed that the MPN is not available to show in the list view of Items. Please consider adding it as EAN, UPC and ISBN are all available, so it doesn't make much sense to exclude this similar option. Thanks for considering my feedback.

• Feature Request - Option To Hide Default System Fields on Items

  Hi Zoho Inventory Team, As far as I know it is not possible to hid some of the defult system fields on Items, such as UPC, MPN, EAN, ISBN. A good use case is that in many cases ISBN is not relevant and it would be an improved user experience if we could

• Making an email campaign into a Template

  I used a Zoho Campaign Template to create an email. Now I want to use this email and make it a new template, but this seems to be not possible. Am I missing something?

• Campaigns does not work!

  I am running into so many problems trying to use Zoho Campaigns, that I am seriously considering dropping the app from my (shrinking) list of Zoho applications I actually use. Apart from having to fight the software trying to create a design and email,

• Feature Request - Make Available "Alias Name" Field In Item List View

  Hi Zoho Inventory Team, I have noticed that the "Alias Name" field does not appear on the list of selectable columns in the Customise Columns feature in the Items module. This would be very useful to see for businesses who are using the Alias Name field

• Marketing Automation

  L.S. Marketing Automation is and has always been part of the Zoho One bundle - according to the information provided on the Zoho Website. Why when I open Marketing Automation do I get the following message?: "Your trial has expired. We hope you enjoyed

• Cliq iOS can't see shared screen

  Hello, I had this morning a video call with a colleague. She is using Cliq Desktop MacOS and wanted to share her screen with me. I'm on iPad. I noticed, while she shared her screen, I could only see her video, but not the shared screen... Does Cliq iOS is able to display shared screen, or is it somewhere else to be found ? Regards

• Bigin, more powerful than ever on iOS 26, iPadOS 26, macOS Tahoe, and watchOS 26.

  Hot on the heels of Apple’s latest OS updates, we’ve rolled out several enhancements and features designed to help you get the most from your Apple devices. Enjoy a refined user experience with smoother navigation and a more content-focused Liquid Glass

• project name field issue- n8n

  Hey guys, I have a question. I want to create a new product using the workflow. The problem is with the product name field; I don't know how to fill it in. The workflow starts with retrieving information from the leads table, retrieving links to scrape

• Automatic Matching from Bank Statements / Feeds

  Is it possible to have transactions from a feed or bank statement automatically match when certain criteria are met? My use case, which is pretty broadly applicable, is e-commerce transactions for merchant services accounts (clearing accounts). In these

• How to filter Packages in zoho inventory api

  Hi Team, I want to perform some tasks in a schedular on the packages which are in "Shipped" state. I tried to use filter_by in my api call but in return I get response as {"code":-1,"message":"Given filter is not configured"} My Api request is as follows

• CRM

  Is anyone else experiencing this issue? Our company is not moving out of using Gmail's web app. It just has more features and is a better email program than Zoho Mail. Gmail has an extension (Zoho CRM for Gmail) that we're using but we've found some serious

• ZOHO add-in issue

  I cannot connect ZOHO from my Outlook. I am getting this error.

• Automate pushing Zoho CRM backups into Zoho WorkDrive

  Through our Zoho One subscription we have both Zoho CRM and Zoho WorkDrive. We have regular backups setup in Zoho CRM. Once the backup is created, we are notified. Since we want to keep these backups for more than 7 days, we manually download them. They

• Syncing with Google calendar, Tasks and Events

  Is it possible to sync Zoho CRM calendar, task and events with Google Calendar's tasks and events. With the increasing adoption by many major tool suppliers to sync seamlessly with Google's offerings (for instance I use the excellent Any.do task planning

• How can i view "Child" Accounts?

  It can be very useful in our field of business to know the parent-child account relationship. However, there seems to be a shortcoming in the parent account view: no child account list. How can we view the child accounts per each account?

• Ability to assign Invoice Ownership through Deluge in FSM

  Hi, As part of our process, when a service appointment is completed, we automated the creation of the invoice based on a specific business logic using Deluge. When we do that, the "Owner" of the invoice in Zoho FSM is defaulted to the SuperAdmin. This

• Easily perform calculations using dates with the new DATEDIF function

  Hey Zoho Writer users! We've enhanced Zoho Writer's formula capabilities with the new DATEDIF function. This allows you to calculate the difference between dates in days, months, and years. Function syntax: =DATEDIF(start_date, end_date, unit) Inputs:

• Adding Comments Using Workflows - How to Change User Attributed

  We have worklflows in Desk where a comment is added to a ticket based on certain criteria. It seems that the comment added is always attributed to the user who last edited the workflow. This does not make sense for us because: - It's misleading to other

• Add Attachment Support to Zoho Flow Mailhook / Email Trigger Module

  Dear Zoho Support Team, We hope you are well. We would like to kindly request a feature enhancement for the Mailhook module in Zoho Flow. Currently, the email trigger in Zoho Flow provides access to the message body, subject, from address, and to address,

• Conect chat of salesiq with zoho cliq

  Is there any way to answer from zoho cliq  the chat of salesiq initiated by customers?

• Les dernières avancées en saisie de données et collaboration

  Après une année dédiée à la recherche et au développement, notre équipe est prête à dévoiler des améliorations majeures pour Zoho Sheet. Ces nouveautés seront lancées par étapes afin d’en assurer une prise en main optimale. Nous commençons avec des fonctionnalités

• Deluge Learning Series – Client functions in Deluge | January 2026

  We’re excited to kick-start the first session of the 2026 Deluge Learning Series (DLS) with Client functions in Deluge. For those who are new to DLS, here’s a quick overview of what the series is all about: The Deluge Learning Series takes place on the

• Rich Text For Notes in Zoho CRM

  Hello everyone, As you know, notes are essential for recording information and ensuring smooth communication across your records. With our latest update, you can now use Rich Text formatting to organize and structure your notes more efficiently. By using

• Implement Meeting Polls in Zoho Bookings

  Dear Zoho Bookings Support Team, We'd like to propose a feature enhancement related to appointment scheduling within Zoho Bookings. Current Functionality: Zoho Bookings excels at streamlining individual appointment scheduling. Users can set availability

• Zoho Bookings and Survey Integration through Flow

  I am trying to set up flows where once an appointment is marked as completed in Zoho Bookings, the applicable survey form would be sent to the customer. Problem is, I cannot customise flows wherein if Consultation A is completed, Survey Form A would be

• Service Account Admin for API Calls and System Actions

  Hello, I would like to request the addition of a Service Account Admin option in Zoho product. This feature would allow API calls and system actions to be performed on behalf of the system, rather than an active user. Current Issue: At present, API calls

• How to apply customized Zoho Crm Home Page to all users?

  I have tried to study manuals and play with Zoho CRM but haven't found a way how to apply customized Zoho CRM Home Page as a (default) home page for other CRM users.. How that can be done, if possible? - kipi Moderation Update: Currently, each user has

• Please can the open tasks be shown in each customer account at the top.

  Hi there This has happened before, where the open tasks are no longer visible at the top of the page for each customer in the CRM. They have gone missing previously and were reinstated when I asked so I think it's just after an update that this feature

• How to Customize Task Creation to Send a Custom Alert Using JavaScript in Zoho CRM?

  Hello Zoho CRM Community, I’m looking to customize Zoho CRM to send a custom alert whenever a task is created. I understand that Zoho CRM supports client scripts using JavaScript, and I would like to leverage this feature to implement the alert functionality.

• Send Whatsapp with API including custom placeholders

  Is is possible to initiate a session on whatsapp IM channel with a template that includes params (placeholders) that are passed on the API call? This is very usefull to send a Utility message for a transactional notification including an order number

• Configurable Zoho Cliq Notifications for Zoho People Alerts

  Hello Zoho People Product Team, Greetings and hope you are doing well. We would like to request an enhancement to Zoho People notifications, enabling a native delivery via Zoho Cliq with admin-level control, similar to the notification settings available

• Add Israel & Jewish Holidays to Zoho People Holidays Gallery

  Greetings, We hope you are doing well. We are writing to request an enhancement to the Holidays Gallery in Zoho People. Currently, there are several holidays available, but none for Israel and none for Jewish holidays (which are not necessarily the same

• Next Page