Power of Automation: Streamline status update for linked issues.
Hello Everyone,
A Custom Function is a user-written set of code to achieve a specific requirement. Set the required conditions needed as to when to trigger using the Workflow rules (be it Tasks / Project) and associate the custom function to it.
We have complied a gallery of the most frequently solved use cases for Issues custom functions. You can access the same using the steps available in this link.
And, today I would like to highlight one of the Gallery custom functions - updateTheStatusOfALinkedIssue.
Use case:-
Let us assume there are two issues Issue A and Issue B linked with type "is duplicate of" then the status update done for Issue A will be streamlined to Issue B as well i.e when Issue A status is updated to "In Progress" then Issue B status will automatically be updated to the same status.
Below is the custom function code for reference. We can associate this code with Business rule available within Issue tracker settings.
Custom function code:-
projectsDomain = "https://projectsapi.zoho.com";
getIssueDetailsUrl = projectsDomain + "/restapi/portal/" + portalId + "/projects/" + bugProjectId + "/bugs/" + bugId + "/";
getBugDetResp = invokeurl
[
url :getIssueDetailsUrl
type :GET
connection:"XXXXXXX"
];
//info getBugDetResp;
currentIssueStatusId = getBugDetResp.get("bugs").get("0").get("status").get("id");
getLinkedIssuesUrl = projectsDomain + "/api/v3/portal/" + portalId + "/projects/" + bugProjectId + "/bugs/" + bugId + "/linkedissues";
getLinkedIssuesResp = invokeurl
[
url :getLinkedIssuesUrl
type :GET
connection:"XXXXXXX"
];
//info getLinkedIssuesResp;
issueLinked = getLinkedIssuesResp.get("issue_linked");
reverseLinkedIssues = getLinkedIssuesResp.get("reverse_linked_issues");
info issueLinked;
if(issueLinked.get("linked_issues") != null)
{
linkedIssues = issueLinked.get("linked_issues");
duplicateOfIssues = linkedIssues.get("is duplicate of");
for each duplicateIssue in duplicateOfIssues
{
duplicateIssueId = duplicateIssue.get("issue_id");
duplicateIssueStatusId = duplicateIssue.get("status_id");
if(!duplicateIssueStatusId.equals(currentIssueStatusId))
{
updateIssueStatusUrl = projectsDomain + "/restapi/portal/" + portalId + "/projects/" + bugProjectId + "/bugs/" + duplicateIssueId + "/";
updateIssueStatusParam = Map();
updateIssueStatusParam.put("status_id",currentIssueStatusId);
updateStatusResp = invokeurl
[
url :updateIssueStatusUrl
type :POST
parameters:updateIssueStatusParam
connection:"XXXXXXX"
];
info updateStatusResp;
}
}
}
if(issueLinked.get("reverse_linked_issues") != null)
{
linkedIssues = issueLinked.get("reverse_linked_issues");
duplicateOfIssues = linkedIssues.get("is duplicate of");
for each duplicateIssue in duplicateOfIssues
{
duplicateIssueId = duplicateIssue.get("issue_id");
duplicateIssueStatusId = duplicateIssue.get("status_id");
if(!duplicateIssueStatusId.equals(currentIssueStatusId))
{
updateIssueStatusUrl = projectsDomain + "/restapi/portal/" + portalId + "/projects/" + bugProjectId + "/bugs/" + duplicateIssueId + "/";
updateIssueStatusParam = Map();
updateIssueStatusParam.put("status_id",currentIssueStatusId);
updateStatusResp = invokeurl
[
url :updateIssueStatusUrl
type :POST
parameters:updateIssueStatusParam
connection:"XXXXXXX"
];
info updateStatusResp;
}
}
}
Make sure to replace XXXXXXX with the Zoho Projects connection link name with scope ZohoProjects.bugs.READ, ZohoProjects.bugs.UPDATE. Check this link to learn how to create the connection. Also, a screenshot of the sample Business rules is attached for reference.
We hope you found this post useful. If you have any questions, feel free to share them in the comments below.
Topic Participants
Saraswathi S
Sticky Posts
Create Your Own Issue Management System
Effective issue management is a cornerstone of project success. Every bug or issue, no matter how small, needs to be tracked and resolved in time to maintain project momentum. In this post, we’ll explore how an issue management system in Zoho ProjectsTime 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 keepEnhanced 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 groupedTip 37: Time Log Restriction in Zoho Projects
Timesheet in Zoho Projects helps you big time in entering log hours for the tasks and issues and approving them. Now, with the new Time Log Restriction option, you can set daily and weekly log hour limits. You can restrict users from entering extra log hours than the permissible limit. The limits are restricted to 24 hours per day and 168 hours per week by default based on business hours. To customize, navigate to Task & Timesheet settings under Portal Configuration in Zoho Projects setup and enableRename Task Module To Suit Your Project
Task Module in Zoho Projects gives a comprehensive view of all the action items, known as Tasks, across all projects. However, different industries may use alternative terminology for similar processes, which might not always be recognised when labelled
Recent Topics
Finding draft ticket replies
Is there a way to see all tickets which have draft replies?Number of Workflow runs
Is there a way in Zoho desk to see statistics regarding workflows, rules and other automation objects? Would be nice for several reasons: You could ensure that your workflows are actually running. You could determine which ones weren't being used so youMail is no longer populating CRM contacts
Hi! For the last few days, my mail hasn't been populating my CRM contacts. Even people I email multiple times per day. In fact, it keeps trying to send mail to myself. Notice, I started typing Amy and only got as far as, "Am" and it suggested myself.Zoho Support is indeed shocking and difficult to get a response with
All our business emails have an auto-foward set up on them so that they also go to our GMAIL accounts so that we receive them to the relevenat people. The emails are indeed auto forwarding and arriving to our GMAIL accounts but when you log into yourDirectly Edit, Filter, and Sort Subforms on the Details Page
Hello everyone, As you know, subforms allow you to associate multiple line items with a single record, greatly enhancing your data organization. For example, a sales order subform neatly lists all products, their quantities, amounts, and other relevantI want the currency in my account to be Mexican pesos.
Hello, I am a Mexican citizen and live in Ukraine. When I registered to your system, it was seen that I was from Ukraine, so the default currency is Euro. This is causing me a problem. Please change the standard currency in my account to Mexican PesNot able to change colors help center
Hi. How can I change the orange color in the help center? You can change everything besides this font color And how can I remove the part on the bottom?Chart with Filtered Data vs Unfiltered Data
I am looking to create a chart view that displays the full data set vs a subset of the data filtered by user filter. However I do not seem to find any method by which to exclude a plot from the applied filter or any other method by which to display theHow to get a list of selected records into a button-function? Here is how!
So, you might know already how to get a button on a page somewhere and perform actions with a function when pressed, but how about a button that only works with the records you selected in the list view? The button selected is a custom button in the modulesIssue with Create Note Button and Popup Form in Leads Module
Hello Zoho Community, I am trying to implement a "Create Note" button in the Leads module with the following functionality: 1. When the button is clicked, a form should pop up with fields to add notes. 2. After filling out the form and clicking Send,How to Add Break line / Return on button click
I need to return the text concate with difference field from lead with line break i try "\r" ,"\n" "<br>" return "ali \r\n <br> baba"; None of above work. i expected result something like this ali baba but got this ali \r\n <br> baba so, how can iHow to get batch number of item by api?
Hi there, Is there any way to get batch number of item by api? Batch number is the batch reference number in https://www.zoho.com/inventory/help/advanced-inventory-tracking/batch-tracking.html . When I call the https://www.zoho.com/books/api/v3/#Items_Get_an_itemAutomatically assign Contacts to Account owners
Hi, I have a finite number of accounts set up in the CRM, and each new contact that comes in is automatically assigned to an Account according to a rule I set up. I want the Contact owner in the Contacts module to be assigned to the relevant Account owner.Filter embedded report
How to filter embedded report in a page, below code is not working. dateField => startDate & dateField=< endDate The report should print on page containing records from startDate to endDate. params='zc_Header=true&Service_Date__gte=<%=startDate%>&Service_Date__lte=<%=endDate%>'Serious question: Are there actually "solo-preneurs"/small business owners who made Zoho-one work well for them?
L.S. After already many years of continued struggle with Zoho-One, I am seriously wondering if there are actually solo-preneurs (one person small business owners - without a large, dedicated IT dept.) who got it (Zoho-One) to work well for their businesses.Announcing new features in Trident for Windows (v.1.18.6.0)
Hello Community, Trident for Windows is here with some new features to elevate your workplace communication. Let's take a quick look at what's new. Ask and send read receipts for emails You can now request read receipts for specific emails while composing,Increase subscription prices for existing subscriptions
Hi, Does anyone know how we could achieve the ability to increase the subscription fee for our existing customers based on a % increase. We are not yet using Zoho Billing (Subscriptions) and I'm not sure if it is a good fit for us. But we would need toWhy developing custom function development made so difficult for Zoho Projects!!
Hi Zoho Team, I am trying to write function to automate a process but whatever API name or Column Name I use, the API isn't populating certain fields. Even the standard fields aren't getting populated through API. It's already exhausting to find all APIDelete / Modify Default Career Site - Zoho Recruit
Hello, It would be very useful if we could delete a default career site or change which of our career site is the default. Our Career site was created when there were issues with Zoho Recruit creating English CTA buttons on French Career sites. The onlyData not visible in sheet cells
I'm having an issue where my data is not visible in my sheet cells. If I click on an individual cell, the data does display above in the little "fx" box. But all the boxes in the sheet just look blank. My collaborators do not have this issue. I have checkedPO receive limitations
It is VERY common to receive more or less that the PO quantity. It's totally ludicrous to limit the maximum receive to the PO quantity! What if the receive is 0.00001 less than the PO quantity - it leaves the PO as "Partially received" The current options are to edit the PO manually before finalizing the receive, an outrageous situation ! Please Zoho guys - this is an infuriating oversight & can be easily resolved by introducing the option as shown in the attached document ......How to view shared mailbox in Outlook
How to view shared mailbox in Outlook or in another softwareDocument images
We used to be able to rotate the images but this has now been removed ???How to add new deal to existing contact
Hi, I want to add new deal to existing contact.Why don't we have better integration with Mercado Pago or Pagseguro?
Currently, the integration between Zoho Commerce and Mercado Pago for Brazil is very poor... Since it is old, it does not include the main payment method in Brazil today, which is PIX. Is there a date for this to finally be launched? There are numerousWhy is there no integration with native Brazilian shipping methods?
Zoho Commerce is a powerful platform for e-commerce, but its lack of integration with native Brazilian shipping solutions is a significant limitation for users in Brazil. Integrating with popular shipping providers like Correios, Frenet, and Kangu wouldAlert for Back Navigation in Zoho Creator Widgets on Mobile Apps
In Zoho Creator widgets, when a user navigates back on mobile devices, the data within the widget is reset. This leads to a loss of any unsaved changes or inputs, causing frustration for users. To enhance user experience, we need to implement a confirmationMapping Zoho Projects into Cliq Channels
why arent all the Zoho Projects listed from the drop down menu when trying to Map them into Zoho Cliq Channels. The system doesnt allow me to type the name of the project but gives a drop down of a list of projects however it doesnt give me a list ofInput GST Reversal for damaged goods
In our line of business, some items are damaged and we are doing inventory adjustments to remove them from stock. However, as per GST guidelines, there is a specific rule that we have to reverse Input GST availed for such items and needs to be reportedDevelop and publish a Zoho Recruit extension on the marketplace
Hi, I'd like to develop a new extension for Zoho Recruit. I've started to use Zoho Developers creating a Zoho CRM extension. But when I try to create a new extension here https://sigma.zoho.com/workspace/testtesttestest/apps/new I d'ont see the option of Zoho Recruit (only CRM, Desk, Projects...). I do see extensions for Zoho Recruit in the marketplace. How would I go about to create one if the option is not available in sigma ? Cheers, Rémi.Tracking new lead response time
Hi, I have a team of Sales Development Reps, who have a KPI of responding to a lead within 20 mins or less once it hits the system. I seem to recall that Zoho CRM had the capability to track this in a previous version, but don't see it anywhere. It'sCanadian Anti Spam Law
In order to be able to comply with the new Canadian Anti Spam Law, I need to send out a Confirm Subscription email to all of our existing contacts. If I use the Subscribe tag, the user gets the following message: Registration Failed. Sorry! This contact is already present in the selected list. You can check this with your update profile link. If I include an 'Update Profile' link, it then sends an email which does not arrive immediately. Can you provide a tag or URL I can put in a Campaign EmailConfigure Notes Title for Blueprint Transition
It'd be very helpful to be able to configure note titles on blueprint transitions when requiring notes. This would help tie back the history of notes to the blueprint actions. We have some approval processes in our blueprint and require notes for theChange work hours per day for employees
Hello, Is there a way to modify the work hours per day for employees in Zoho projects? This would be helpful for resource allocation to more accurately see when an employee who works 35 hours a week vs 40 hours has a full schedule. Thanks.Record GST Paid for Imported Goods
In Australia, goods that imported from overseas needs to pay GST per invocied value. In most case, the freight forwader (logistic agent) paid this on behalf of importer (us), and invoice us in together in their freight invocie. How do we setup a properUnable to produce monthly P&L reports for previous years
My company just migrated to Books this year. We have 5+ years financial data and need to generate a monthly P&L for 2019 and a monthly P&L YTD for 2020. The latter is easy, but I'm VERY surprised to learn that default reports in Zoho Books cannot createBulk Editing Multiple Invoices with Overwriting at time of upload
Hello, I would like to edit a few 100 invoices. Only the HSN needs to be updated. When I am trying to upload the excel sheet with the data updated, I get an error: The Invoices are skipped as they already exist. I know the invoices exist but I would onlyChange format of quantity format
Hi, I would like to change the qunatity format from 1,00 to 1. Is this possible? thanks!Oauth Redirects me to sign in page
I am developing a postman script for me to securely get my credentials via Zoho Vault. With that, I need to authorize my postman to be able to access Zoho Vault. I am currently on Step 1 in this Zoho Vault | API Reference which redirects me to this guideHere's why you should refrain from using EasyShip
This is a screen recording which shows EasyShip performance issues. Note well! While we do use the Zoho-to-Easyship integration, the problems are wholly on the EasyShip side. The actual integration of data to EasyShip, and status updates back to Inventory,Next Page