Eliminating Manual Consolidation: Automating Currency Field Sync from Task to Project
Hello Everyone,
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.
Requirement:
One of our customers has created four custom currency fields at the Task level and a related set of four custom currency fields at the Project level. Their requirement is to roll up the cumulative values from the Task-level fields and automatically sync them to the corresponding Project-level fields. This requirement was successfully achieved using Custom Function along with Workflow rules.
This approach ensures that project level data stays accurate and up to date without the need for manual consolidation.
Custom function code:
projectsv3APIEndPoint = "https://projectsapi.zoho.com/api/v3";
projectsAPIEndPoint = "https://projectsapi.zoho.com/restapi";
totalMilestoneRev = 0;
totalActualRev = 0;
totalMilestoneGP1 = 0;
totalActualGP1 = 0;
indexValue = 1;
rangeValue = 100;
loop = {1,2,3};
// This loop fetches up to 300 tasks. Increase the count as needed, e.g., loop = {1,2,3,4,5}; to fetch 500 tasks.
for each i in loop
{
taskParameter = Map();
taskParameter.put("index",indexValue);
taskParameter.put("range",rangeValue);
// info taskParameter;
taskResponse = zoho.projects.getRecords(portalId,projectId,"tasks",taskParameter,0,"XXXXX");
// info taskResponse;
if(taskResponse.containKey("tasks"))
{
for each task in taskResponse.get("tasks")
{
if(task.containsKey("custom_fields"))
{
customFields = task.get("custom_fields");
customFields = task.get("custom_fields");
for each customField in customFields
{
if(customField.get("label_name").equalsIgnoreCase("Milestone Rev"))
if(customField.get("label_name").equalsIgnoreCase("Milestone Rev"))
{
milestoneRev = customField.get("value");
if(milestoneRev.equalsIgnoreCase("-"))
{
milestoneRev = 0;
milestoneRev = 0;
}
totalMilestoneRev = totalMilestoneRev + milestoneRev.remove(",").toDecimal();
totalMilestoneRev = totalMilestoneRev + milestoneRev.remove(",").toDecimal();
}
if(customField.get("label_name").equalsIgnoreCase("Actual Rev"))
{
actualRev = customField.get("value");
if(actualRev.equalsIgnoreCase("-"))
{
actualRev = 0;
}
totalActualRev = totalActualRev + actualRev.remove(",").toDecimal();
}
if(customField.get("label_name").equalsIgnoreCase("Milestone GP1"))
{
actualRev = 0;
}
totalActualRev = totalActualRev + actualRev.remove(",").toDecimal();
}
if(customField.get("label_name").equalsIgnoreCase("Milestone GP1"))
{
milestoneGP1 = customField.get("value");
milestoneGP1 = customField.get("value");
if(milestoneGP1.equalsIgnoreCase("-"))
{
milestoneGP1 = 0;
}
totalMilestoneGP1 = totalMilestoneGP1 + milestoneGP1.remove(",").toDecimal();
totalMilestoneGP1 = totalMilestoneGP1 + milestoneGP1.remove(",").toDecimal();
}
if(customField.get("label_name").equalsIgnoreCase("Actual GP1"))
{
actualGP1 = customField.get("value");
if(actualGP1.equalsIgnoreCase("-"))
{
actualGP1 = 0;
}
actualGP1 = customField.get("value");
if(actualGP1.equalsIgnoreCase("-"))
{
actualGP1 = 0;
}
totalActualGP1 = totalActualGP1 + actualGP1.remove(",").toDecimal();
}
}
}
}
}
indexValue = indexValue + 100;
}
else
else
{
break;
}
}
/*Rollup to project*/
projectParams = Map();
projectParams.put("baseline_revenue",{"amount":totalMilestoneRev.round(2)});
projectParams.put("projects_cf_0002",{"amount":totalActualRev.round(2)});
projectParams.put("baseline_gp1",{"amount":totalMilestoneGP1.round(2)});
projectParams.put("actual_gp1",{"amount":totalActualGP1.round(2)});
info projectParams;
updateProject = invokeurl
[
url :projectsv3APIEndPoint + "/portal/" + portalId + "/projects/" + projectId
type :PATCH
parameters:projectParams.toString()
connection:"XXXXX"
];
info updateProject;
return "success";
Make sure to replace XXXXX with Zoho Projects connection link name along with scopes: ZohoProjects.projects.ALL, ZohoProjects.Tasks.ALL and the custom fields based on your requirement. Please find the screenshot of the list of parameters to be mapped for reference.
We hope you found this post useful. If you have any questions, feel free to share them in the comments below.
Access your files securely from anywhere
New to Zoho Recruit?
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
Saraswathi S
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 keepIntroducing 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 happyAutomation 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 yourAutomate 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
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
Nederlandse Hulpbronnen
ご検討中の方
Recent Topics
Optimising CRM-Projects workflows to manage requests, using Forms as an intermediary
Is it possible to create a workflow between three apps with traceability between them all? We send information from Zoho CRM Deals over to Zoho Projects for project management and execution. We have used a lookup of sorts to create tasks in the past,This domain is not allowed to add. Please contact support-as@zohocorp.com for further details
I am trying to setup the free version of Zoho Mail. When I tried to add my domain, theselfreunion.com I got the error message that is the subject of this Topic. I've read your other community forum topics, and this is NOT a free domain. So what is theThis user is not allowed to add in Zoho. Please contact support-as@zohocorp.com for further details
Hello, Just signed up to ZOHO on a friend's recommendation. Got the TXT part (verified my domain), but whenever I try to add ANY user, I get the error: This user is not allowed to add in Zoho. Please contact support-as@zohocorp.com for further details I have emailed as well and writing here as well because when I searched, I saw many people faced the same issue and instead of email, they got a faster response here. My domain is: raisingreaderspk . com Hope this can be resolved. Thank youCannot connect to imap.zoho.eu on iOS26
Hey, I recently migrated to another iPhone and since then use iOS26. Every since then, I was not able to connect to "imap.zoho.eu" from Apple Mail. I tried deleting the account and adding it again, did not work. I tried creating an app password, didn'tPersonalize your booking pages with Custom CSS
Greetings from the Zoho Bookings team! We’re introducing Custom CSS for Zoho Bookings, designed to give you complete control over the look and feel of your booking pages. With this new feature, you can upload your own CSS file to customize colors, fonts,Customer address in Zoho Bookings
Hello, Is it possible to add customer address information to the Zoho bookings appointment screen? Or have it pull that information automatically from the CRM? We are wanting to use this as a field management software but it is difficult to pull the address from multiple sources when it would be ideal to have a clickable address on the appointment screen that opens up the user's maps. It would also be advantageous for the "list view" to show appointment times instead of just duration and bookingBulk bank rule creatioin
Hi team, I am exploring Option to create a multiple bank rule. Could please suggest the option to implement this?Marketer's Space: Plan smarter with Zoho Campaigns' Calendar
Hello Marketers, Welcome to another post! Today, we'll talk about a discreet yet significant feature that's neatly tucked inside Zoho Campaigns: the calendar. It might look like an optional but somewhat unnecessary feature that you can use occasionally,User
If user is already part of manage engine endpoint central , what hapens when i try to add them to another Zoho org / directory? Are these users added as external users?Add an background image to an email template in CRM
Hi all, We wants to put an background image behind all our email templates. Is there a way to import this thru html. If i put the option background image in <body style="background-image:...</body> and i look to the preview it shows our background, butCreate static subforms in Zoho CRM: streamline data entry with pre-defined values
Last modified on (9 July, 2025): This feature was available in early access and is currently being rolled out to customers in phases. Currently available for users in the the AU, CA, and SA DCs. It will be enabled for the remaining DCs in the next coupleOutlook - Zoho CRM Calendar Integration
I'm facing an issue integrating Outlook with Zoho CRM. Has anyone successfully connected their Outlook to Zoho, and are all your meetings and emails being captured correctly in the CRM? Any insights or troubleshooting tips would be appreciatedCan 1 Zoho CRM instance sync with 2 Zoho Marketing Automation instances?
Can 1 Zoho CRM instance sync with 2 Zoho Marketing Automation instances?【Zoho CRM】ポータル機能のアップデート
ユーザーの皆さま、こんにちは。コミュニティチームの藤澤です。 今回は「Zoho CRM アップデート情報」の中から、ポータル機能のアップデートをご紹介します。 ポータル管理の新機能「自動招待」により、Zoho CRMからポータルへの招待を自動化できるようになりました。これまで必要だった、ユーザーごとの手動設定は不要になります。設定した条件に基づいて、対象ユーザーに自動で招待が送信されます。 ポータルの新機能 条件に基づく自動招待：指定した条件を満たすユーザーに、自動で招待を送信 招待設定：招待メールの言語を選択し、言語ごとに条件を設定可能Contact data removes Account data when creating a quote
Hi, Our customer has address fields in their quote layout which should be the address of the Account. They prefill the information, adding the account name - the address data is populated as per what is in the account - great. However when they then addI need to know the IP address of ZOHO CRM.
The link below is the IP address for Analytics, do you have CRM's? IP address for Analytics I would like to know the IP address of ZOHO CRM to allow communication as the API server I am developing is also run from CRM. Moderation Update: The post belowEmail was sent out without our permission
Hi there, One customer just reached out to us about this email that we were not aware was being sent to our customers. Can you please check on your end?Export all of our manuals from Zoho Learn in one go
Hi, I know there's a way to export manuals in Zoho Learn, but I want to export everything in one go so it won't take so long. I can't see a way to do this, can I get some assistance or is this a feature in the pipeline? Thanks, HannahAutomation#31: Automate Splitting Names for New Contact Records
Hello Everyone, This week, we present to you a custom function, which allows you to split the first and last names from the user's email ID based on the separator used in the ID. Having grown into a large firm, Zylker Techfix aims to optimize its processes,Automatically remove commas
Team, Please be consistent in Zoho Books. In Payments, you have commas here: But when we copy and paste the amount in the Payments Made field, it does not accept it because the default setting is no commas. Please have Zoho Books remove commas automCan not add m365 outlook account to zohomail.
I am attempting to use zoho mail as an imap client to add my outlook.com m365 account. In the m365 exchange admin center i have made sure the imap is enabled. In zoho mail i go to settings, mail accounts, add account, add imap account, i select "outlook",Error AS101 when adding new email alias
Hi, I am trying to add apple@(mydomain).com The error AS101 is shown while I try to add the alias.Transfer ownership of files and folders in My Folders
People work together as a team to achieve organizational goals and objectives. In an organization, there may be situations when someone leaves unexpectedly or is no longer available. This can put their team in a difficult position, especially if thereProject Change Orders and Additions
We are in the process of migrating from QuickBooks Online to Zoho Books. We have Zoho One and like the ability to sync all of our data across everything. And I like that projects work in a way that's less dumb than QuickBooks. I'm trying to figure outZOHO Desk - Description of slave ticket disappeared after Merge
Dear Support, On Zoho Desk the description of a ticket disappeared after merging two ticket. The one which was the slave one completely disappeared. The problem that in this description there was an image which i had only on Desk in that ticket. CouldHow do I insert a cross-reference link to a different section within one Knowledge Base article using Zoho Desk?
I would like to insert a link within a Knowledge Base article to a different section of that same article. The section I want to link to is formatted with the Heading 3 style and is displayed within my TOC. However, I do not see any way to add a linkProblem Adding Facebook Account
Hi, I'm new here, I'm having trouble setting up my Facebook account as a social channel. I think the issue is down to how my Facebook is set up, which is pretty confusing. I have a personal Facebook account (let’s called it A) which is my main FacebookZoho Desk Teams App is not loading
Hi Zoho Desk support. Need an assistance on the Zoho Desk Teams app. Once I click View Ticket, it isn't showing anything. Kindly refer to attached: ZohoDesk Teams App_View Ticket Error.jpg For our Dashboard, we are still experiencing the same issue. KindlyAbout Meetings (Events module)
I was working on an automation to cancel appointments in zoho flow , and in our case, we're using the Meetings module (which is called Events in API terms). But while working with it, I'm wondering what information I can display in the image where theCliq 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 ? RegardsZoho People - Retrieve the Leave Details - get("LeaveCount")
Hi, Zoho People I need to collect all of an employee's leave requests for the calendar year and check how many half-days they have taken. If I run the script on the query he just modified, I can retrieve the information related to that query and use theMapping a new Ticket in Zoho Desk to an Account or Deal in Zoho CRM manually
Is there any way for me to map an existing ticket in Zoho desk to an account or Deal within Zoho CRM? Sometimes people use different email to put in a ticket than the one that we have in the CRM, but it's still the same person. We would like to be ableWhich WhatsApp API works seamlessly with Zoho CRM?
I’m exploring WhatsApp API solutions that integrate seamlessly with Zoho CRM for customer communication, lead nurturing, and automation. I would love to hear insights from those who have successfully implemented WhatsApp within Zoho CRM. My Requirements:Allow people to sign a zoho form by using esign or scanned signature
Allow people to sign a zoho form by using esign or scanned signatureButton to Reapply Filters on Sheet(s)
I wrote a macro that I attached to a button to reapply the filters on all my sheets and it says it works, but it doesn't actually do anything. What is wrong with it? Is there another way? Or even make it work for one sheet? Sub UniversalFilterRefresh()Integrate Multiple ZohoBooks organization with zoho projects
We have successfully connected our Zoho Books with Zoho Projects for synronizing timesheet data. Our Business specialty is, that the staff of the Main company (A) is working on several projects, but the Clients are sometimes contracted and paying to aZoho OAuth Connector Deprecation and Its Impact on Zoho Desk
Hello everyone, Zoho believes in continuously refining its integrations to uphold the highest standards of security, reliability, and compliance. As part of this ongoing improvement, the Zoho OAuth default connector will be deprecated for all Zoho servicesHow to drag row(s) or column(s)?
Hi. Selecting a row or column and then dragging it to a new position does not seem to work. Am i missing something or this is just not possible in Zoho Sheet? Cheers, JayFlexible Partial-Use Coupons (Stored Value Credits)
Subject: Feature Request: Ability for users to apply partial coupon balances per transaction Problem Statement Currently, our coupons are "one-and-done." If a user has a $50 coupon but only spends $30, they either lose the remaining $20 or are forcedUnable to Assign Multiple Categories to a Single Product in Zoho Commerce
Hello Zoho Commerce Support Team, I am facing an issue while assigning categories to products in Zoho Commerce. I want to assign multiple categories to a single product, but in the Item edit page, the Category field allows selecting only one categoryNext Page