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

• 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-assign Task Followers

  As task progresses, several users are required to stay aware of the updates to plan their upcoming work items efficiently. Manually adding users as followers for an active task might create additional overhead. With this automation, followers can be added

• WhatsApp Business Integration for Zoho Projects

  Delivery channel plays a decisive role in how quickly certain project updates translate into immediate actions. A release is ready to go live. An issue is marked critical. An approval is pending. These moments are less about tracking and more about timely

• Enhanced Collaboration and Global Web Tabs

  Hello Users, We are rolling out two key enhancements in Zoho Projects that will be part of our November release. Here’s what to expect: 1. Collaboration Section in the Left Navigation Panel What’s new? All communication and interactive tools will be grouped

• Choosing the Right Automation in Zoho Projects

  In any project, different types of actions are needed at different points. Some projects require control on how tasks move, some require reacting to updates, and some require executing additional actions beyond the task. Automation in Zoho Projects is

• Recent Topics

• Topics not loading in individual contact records in Zoho Marketing Automation

  When working correctly, an individual contact record in ZMA shows a "Topics" section in the "Subscription" tab of the individual record. However, in 2+ different Zoho accounts and different browsers, the "Topics" section doesn't load and instead it spins

• Help: Capture full page URL in hidden field when same Zoho Form is embedded on multiple pages (iframe)

  Hi all, Goal Use one Zoho Form across multiple pages and record the exact page URL (incl. subdomain + path + hash) where the user submitted it. Example pages: https://www.example.com/cargo/ https://www.example.com/cargo/containers/#contact https://cargo.example.com/auto/

• how to get transcripts with speaker and time marks?

  Hello, I downloaded the transcript of a recent meeting and noticed that the TXT file does not bring the speaker name and the time mark. Is there any way to make it happen using ootb resources from Zoho Meeting? best

• SalesIQ's Summer '26 Release: For The Moments That Matter

  Every customer journey is made up of moments. The moment someone discovers your business. The moment they need help. The moment you decide to reach out. The moment a simple chat turns into something more. And the moments that continue long after the conversation

• Cannot deploy digital employee-

  I followed the guide here https://help.zoho.com/portal/en/kb/salesiq-2-0/for-administrators/operators/articles/zia-agents-in-zoho-salesiq#Supported_SalesIQ_Tools but no matter how many times I try I cannot for the love of god make it work I get this error

• Displaying only unread tickets in ticket view

  Hello, I was wondering if someone might be able to help me with this one. We use filters to display our ticket list, typically using a saved filter which displays the tickets which are overdue or due today. What I'd really like is another filter that

• 【受付開始】Zoholics Japan 2026 開催のご案内

  Zoho が年に一度開催するユーザー向けイベント「Zoholics」。 今年は 「AI-Powered DX with Zoho」 をテーマに、2026年9月25日（金）に 東京駅直結の会場とオンラインのハイブリッド形式で開催します。 今すぐ申し込む AIの活用が加速する今、業務効率化やDX推進に取り組む企業にとって、 「どのようにAIを業務へ取り入れ、成果につなげるか」が重要なテーマとなっています。 Zoholicsでは、Zohoの最新AI機能や製品アップデートに加え、実際の活用事例や業務改善のヒントをご紹介します。

• Print checks for owner's draw

  Hi.  Can I use Zoho check printing for draws to Owner's Equity?  This may be a specific case of the missing Pay expenses via Check feature.  If it's not available, are there plans to add this feature?

• Reconciliation: don't auto-select transactions outside the entered Period

  When initiating a reconciliation for a defined Period (say April 1 to April 30), Zoho Books auto-checks transactions whose Statement Detail dates fall after the period end date. With "Show based on grouped bank statements" enabled (the default), the screen

• How can be requests for new job managed in Zoho recruit?

  If we use both Zoho people and recruit, can our managers (heads of department) use Zoho products to create requests for new job to HR department? The current workflow is following: a head of department needs some extra HR, he creates a request describing the job and send it to HR director, HR director approves a request and forward to a HR manager. I see only one way to partly solve the problem - grant the heads of departments recruit administrator permissions, so they could create new jobs. It is

• Linking the Overview window between reports on a dashboard

  Is there a way to link the Overview window for two or more charts on a dashboard? We have several dashboards where users often want to set the window for 3 or 4 reports to the same time period. Doing it manually is time-consuming and cumbersome, but I

• Subforms and automation

  If a user updates a field how do we create an automation etc. We have a field for returned parts and i want to get an email when that field is ticked. How please as Zoho tells me no automation on subforms. The Reason- Why having waited for ever for FSM

• "code":3001 ["Failed to update data."]

  I would like to seek your expertise - I might be wrong on my approach also.. I highly appreciate your advice. 1 problem remains is when a new row was added on the existing one [from another form that trigger upon Successful form submission ], it gets

• BUG: If you put "Blueprint" at the top of Workqueue, tab switching leads to long loading and no display

• WORKFLOW ISSUE: Zoho Finance Extension

  Workflows are no longer triggering in my extension. This is true for the testing environment and 5 other organizations it is installed on. There are no conditions set for the workflow, and this is true for both create and delete related actions. Workflows

• Drive Zoho CRM adoption and usage through our native integration with Zoho DAP

  You chose Zoho CRM for its depth: its powerful automation, its rich analytics, and its extensive customizability. But there's a hidden last mile in every rollout: the gap between the software's capabilities and your team's daily execution. When new hires

• Moving from Office365 to Zoho Mail

  I have few mailboxes on Office365. One of the mailbox is coming up for renewal. How can I move this mailbox to Zoho Mail and continue to have other mail boxes continue to use Office365 mail? Thanks, -Naveen

• Best sales insights for target accounts?

  Question for all the sales power-users out there: I would like to gain insights from Zoho CRM for a rotating list of target accounts. Each Outside Salesperson has 5 target accounts, and they can change these targets quarterly with management approval.

• WhatsApp Vendors

  Hello, so WhatsApp works with the below, mainly with the customer side modules. Can we get functionality on the vendor side modules? WhatsApp is often the preferred method of communication with some vendors. Credit Notes Payment Receipts Sales Receipts

• Text on Zoho Sign confirmation dialouge is very small compared to text used everywhere else on Zoho Sign.

  I've reported multiple times through Zoho's support email that the text on this notification is very small in contrast to all the other text on the Zoho Sign app. I think it's a bug and it just needs the font size to be increased. It's very minor but

• Time Zone is incorrect

  Time zone is not working properly...I've checked it twice. I'm eastern U.S. time it's currently 12:22 pm EST. CRM shows 3:22 pm EST.

• Over-the-Air (OTA) Updates for V3 Attendee Apps | Zoho Backstage

  Keeping participants on the latest version of your event app shouldn’t depend on App Store or Play Store review timelines. With Over-the-Air (OTA) updates for our V3 attendee app, the latest version is delivered directly to participants through an in-app

• Please Remove the Confirmation Popup

  Currently, every time a recruiter changes the status of a candidate in Zoho Recruit, a popup confirmation appears that requires clicking “OK, Got it” before proceeding. This creates unnecessary friction in the workflow, especially for users handling high

• Zoho Projects: Q2 Updates 2026

  Dear Users, During the first quarter, we launched our most advanced version of Zoho Projects, namely Zoho Projects Infinity. With support for Custom Modules, Custom Dashboards & Reports, along with built-in AI tools, we enabled users to create their own

• Overview on users IMAP settings

  We have about 30 users who all have the channels/email/email configuration/IMAP integration/O365 enabled and emails are synchronized. Here my problem: Passwords for the email accounts are expiring on individual bases and most of the users forget to update

• What is a realistic turnaround time for account review for ZeptoMail?

  On signing up it said 2-3 business days. I am on business-day 6 and have had zero contact of any kind. No follow-up questions, no approval or decline. Attempts to "leave a message" or use the "Contact Us" form have just vanished without a trace. It still

• crm to books

  We currently sync CRM Contacts to Zoho Books Customers using two-way sync. We now wish to change to "Accounts & their Contacts". What happens to existing Books customers? Will they be merged with CRM Accounts, duplicated, left unchanged, or recreated?

• Alternate color rows

  After I changed the background color to a dark gray and changed the alternate rows to a light gray. I have discovered that I can no longer change the text in the light gray rows to Bold.

• Tax/Vat Number Field As Standard - Customer & Vendor

  Hello, when are you'll going to have the customer & vendor tax/vat number as a standard field under the relevant profile pages? I find it strange that after 6 years of using Zoho Inventory that I still have to use a custom field for a tax/vat number,

• Is there a way to sync Tags between CRM and Campaigns/Marketing Hub?

  I wonder if there is a way to synch the tags between CRM and Marketing-Hub / Campaigns?

• Restricting coupon codes and plans to specific customers

  Having the ability to restrict coupon codes, plans and add ons to specific customers (new or existing) e.g. sending an invite link out to a certain customer or allowing a certain group of customers the ability to use a certain promo code or sign up to

• Coupon Management Lacks functionality

  Hey Zoho Team, Let me start of by saying I'm a huge fan of the entire Zoho suite. I have a couple of thoughts about the way coupons are handled and believe there they are in need of some improvement. There are a couple of key issues: 1. Coupons need to

• Free Webinar Alert! Zoho Mail + Zoho CRM: Turn inbox replies into CRM deals

  Hello Zoho Community! Are your sales conversations happening in Zoho Mail while your customer data lives in Zoho CRM? Join our upcoming webinar to learn how integrating the two can help you automate follow-ups, capture leads faster, and keep every customer

• Introducing the Employee Portal for internal job posting

  Employee referrals and internal applications are one of the most trusted hiring channels. But in many organizations, employees only hear about openings through messages, word of mouth, or after the role has already been open for a while. When employees

• Marketing Tip #42: Keep policy pages updated and accessible

  Policy pages may not be the most exciting part of your store, but they play a big role in building trust. Before buying, many customers look for information on shipping, returns, refunds, privacy, and terms. If these pages are missing, outdated, or hard

• Extend the Image Choice Field

  Hi, The New Yes/No field is great for what it does, and the Image Choice Field is good but could be better with some functions from the Yes/No field. Take an example, rather than just Yes/No you want Yes/No/Maybe (Or more than 3 choices), but unlike the

• Migrate from Zoho Mail to G Suite

  I am unable to find any documentation on how one can migrate from Zoho Mail to another platform, like G Suite or Office 365. Please point me to the right documentation. Thank you.

• The All New Attendee App | Zoho Backstage

  The Zoho Backstage attendee app is the primary touchpoint for attendees, speakers, exhibitors, and sponsors during an event. It helps participants access event information, manage their schedules, connect with other participants, engage with exhibitors

• How do I show file uploads in my Zoho Creator approval workflow?

  As far as I can tell I'm not able to add the file upload field to the approval workflow show fields list. As a work around I'm making a plain text field that links to the files URL. But I'm not sure how to get a link to that url that will me to preview

• Department Customization Copy/Paste

  Hello! I love the new customization of the layouts, rules and templates! However, we have several "departments" that operate similar and as I'm updating either ticket layout or workflow rules, I'm finding that I have to do it in each department. I would

• Next Page