Power of Automation :: Dynamically generate Tasklists based on values selected in Task Custom Fields

Power of Automation :: Dynamically generate Tasklists based on values selected in Task Custom Fields

Hello Everyone,


A custom function is a software code that can be used to automate a process and this allows you to automate a notification, call a webhook, or perform logic immediately after a workflow rule is triggered. This feature helps to automate complex tasks and calculations. 


Lets take the below use case from a customer - 


A custom field named ‘Category’ has been created within the Tasks module. This field contains values that correspond directly to the names of the task templates available in the portal.

In every project, there is a predefined task called ‘Development’. Depending on the value selected in the ‘Category’ field of this Development task, a tasklist should be automatically generated. This tasklist will be created by applying the task template that matches the value specified in the custom ‘Category’ field.

This automation ensures that the appropriate task template is used to create the tasklist without requiring manual selection, streamlining project setup and maintaining consistency across all projects.

This can be accomplished using the features Custom Functions & Workflow Rules. Create a connection using the scopes “ZohoProjects.tasklists.ALL, ZohoProjects.tasks.ALL" and update the connection name ‘projects’ in the below code. Find the attached screenshot of the Arguments & Workflow.

Below is the code
if(tasklist_picklist == null)
{
	return "No value selected";
}
else
{
	info tasklist_picklist;
	tasklists = tasklist_picklist.toList();
}
endpoint = "https://projectsapi.zoho.com/";
getAllTasklists = invokeurl
[
url :endpoint + "api/v3/portal/" + portalId + "/projects/" + projectId +
 "/tasklists"
type :GET
connection:"projects"
];
// info "getAllTasklists : "+getAllTasklists;
for each  tasklist in getAllTasklists.get("tasklists")
{
	tasklistName = tasklist.get("name");
	if(tasklists.contains(tasklistName))
	{
		tasklists.remove(tasklists.indexOf(tasklistName));
		info tasklistName + " removed";
	}
}
info " tasklists : " + tasklists;
taskTemplateResponse = invokeurl
[
	url :endpoint + "api/v3/portal/" + portalId + "/templates/tasklists"
	type :GET
	connection:"projects"
];
if(taskTemplateResponse.containKey("task_list_templates"))
{
	templates = taskTemplateResponse.get("task_list_templates");
	templateMap = Map();
	for each  template in templates
	{
info "Template Name : " + template.get("name") + "-------- >  Id : 
"+ template.get("id");
	if(tasklists.contains(template.get("name")))
	{
		templateMap.put(template.get("name"),template.get("id"));
	}
	}
}
info templateMap;
for each  template in templateMap
{
// info template;
taskTemplateId = template;
associateTaskTemplateParameter = Map();
associateTaskTemplateParameter.put("task_template_id",taskTemplateId);
associateTaskTemplateParameter.put("shift_days",toString
(zoho.currenttime,"YYYY-MM-dd'T'HH:mm:ss") + "Z");
associateTaskTemplateResponse = invokeurl
[
url :endpoint + "restapi/portal/" + portalId + "/projects/" + projectId +
 "/tasklists/"
type :POST
parameters:associateTaskTemplateParameter
connection:"projects"
];
	info associateTaskTemplateResponse;
}
return "success";


Creating custom functions in Zoho Projects is straightforward and well-documented. Zoho provides a range of built-in functions that you can use as a starting point, and you can also easily define your own functions using Zoho's scripting language, Deluge. Give it a try and see how it can save your time and boost your productivity!

 

Watch this space for more such custom function codes. 

    • Sticky Posts

    • Set Custom Business Calendars and Holidays for Global Teams

      Managing a project across diverse teams means accounting for more than just tasks and deadlines; it means acknowledging how and when each team actually works. Users might follow different working days or observe region-specific holidays that cannot be
    • Introducing Version-3 APIs - Explore New APIs & Enhancements

      Happy to announce the release of Version 3 (V3) APIs with an easy to use interface, new APIs, and more examples to help you understand and access the APIs better. V3 APIs can be accessed through our new link, where you can explore our complete documentation,
    • Restore Trashed Records Anytime Within 30 Days

      Access the recycle bin from the Data Administration tab under the settings page in Zoho Projects, which gives better control over the trashed data. When records like projects, phases, task lists, tasks, issues, or project templates are trashed, they are
    • Organize and Clone Task Custom Views

      We have rolled out two new enhancements to task custom views: Custom View Groups and Custom View Clone. Custom View Groups Similar to predefined view groups, we have introduced groups for custom views to help organize and categorize them. My Custom Views:
    • Flexible Milestone Invoicing

      If your Zoho Projects portal is integrated with Zoho Invoice/Books, you can now create an invoice for your milestones. You can enable it under Integration Preference and invoice milestones regardless of the project's billing type. For instance, consider
      • Recent Topics

      • Multi-currency - What's cooking ?

        Hi,       We have been doing this feature for sometime and we would like to give you some glimpses of it.  Working with Multi Currency :        Multicurrency support gives you the ability to handle business transactions in multiple currencies. You can define a base currency for your organization and add more currencies with exchange rates based on the base currency.  Setup :        From the setup page, you can manage all the currencies supported by your organization.       Currencies page        
      • Integrating Chatbot with Zoho Creator Application

        Is it possible to integrate a chatbot with a Zoho Creator application?
      • How to reduce programmatically the image uploaded by user?

        I need a function that will automatically reduce the pixel dimension to 800 x 600 pixels / 180 resolution or (approx. 1.37MB) of image uploaded by user from digital camera, for example, 2271 x 1704 pixels /180 resolution or approx. 11.1MB. After the user selected the image, the function will able to detect if pixels is above 800x600, process the photo (crop/ reduce) and resume upload. Need help...  
      • Dark mode for Zoho Creator / Zoho CRM Code editor

        Hi Team, Is there any plans for Dark mode in Zoho creator / Zoho Crm code editor and development pages in pipeline?
      • Is there a way to make a button scroll down?

        Looking to have a button on a landing page scroll down to another section on the page. Any recomendations outside of coding?
      • Collective-booking event not added to all staff calendars

        We assign two staff to certain events. When the client books this event, it adds it to one staff calendar (the 'organiser') but not the other. How can I ensure all staff assigned to a collective booking get the event in their calendar? (A side note: it
      • Issue showing too many consultations in my workspace link.

        Hi Team, I’ve set up two Workspaces to track meetings from different sources. So far, this has been working well, and the two Workspaces are differentiated without any issues. However, when I navigate to Consultations and share the link to my personal
      • ZOHO Android Client

        Hi, I installed the Android app, but it had an issue, so I reinstalled it. I was able to add multiple accounts, but now when I add the next account, it just duplicates the one I already have and will not even allow me to enter the info for another account.
      • I'd like to suggest a feature enhancement for SalesIQ that would greatly improve the user experience across different channels.

        Hello Zoho Team, Current Limitation: When I enable the pre-chat form under Brands > Flow Controls to collect the visitor’s name and email, it gets applied globally across all channels, including WhatsApp, Messenger, and Instagram. This doesn't quite align
      • Enhance Barcode/QR Code scanner with bulk scanning or continuously scanning

        Dear Zoho Creator, As we all know, after each scan, the scanning frame closes. Imagine having 100 items; we would need to tap 100 times and wait roughly 1 second each time for the scanning frame to reopen on mobile web. It's not just about wasting time;
      • 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?
      • Non-depreciating fixed asset

        Hi! There are non-depreciable fixed assets (e.g. land). It would be very useful to be able to create a new type of fixed asset (within the fixed assets module) with a ‘No depreciation’ depreciation method. There is always the option of recording land
      • Managing Rental Sales in Zoho Inventory

        I am aware that Zoho Inventory is not yet set up to handle rental sales and invoicing. Is anyone using it for rentals anyway? I'd like to hear about how others have found work arounds to manage inventory of rental equipment, rental payments, etc. Th
      • Megamenu

        Finally! Megamenu's are now available in Zoho-Sites, after waiting for it and requesting it for years! BUT ... why am I asked to upgrade in order to use a megamenu? First: Zoho promised to always provide premium versions and options for all included Zoho-applications
      • Cannot access KB within Help Center

        Im working with my boss to customize our knowledge base, but for some reason I can see the KB tab, and see the KB categories, but I cannot access the articles within the KB. We have been troubleshooting for weeks, and we have all permissions set up, customers
      • Zoho Flow to Creator 3001 Respoonse

        I have updated my Flows with the new V2 connection to Zoho Creator, but now some Flows do not work. They take in data from a Webhook and are supposed to create a record in Creator, however creator returns a 3001 message along with a failure, but I cannot
      • File Upload to Work Drive While Adding Records in Zoho Creator Application

        Hi I am trying to set a file attachment field in zoho creator form, to enable the user to upload a scanned document from their local pc. The file should be uploaded to zoho workdrive and not to the default zoho creator storage. The file link should be
      • COQL order by COUNT not working

        Dear community, I am trying to get a list of deal amounts per planner working on it and sorted to get see who has the least amount of deals. For some reason, I am unable to use sort by in combination with a COUNT. My original code was: query = "select
      • Why not possible to generate?

        Using this https://desk.zoho.com/DeskAPIDocument#TicketCount#TicketCount_Getticketcountbyfield on my ZML script url :"https://desk.zoho.com/api/v1/ticketsCountByFieldValues?departmentId=XXXXXXXXXXX&accountId!=XXXXXXXXX&customField1=cf_country_1:XXXXXX&field=overDue"
      • email

        Hi My crm email is not working, can you check, I have zoho one account.
      • Need option to see Mass Emails & Cadences in Gmail Outbox OR a dedicated Zoho Outbox

        Hi everyone, Right now, when we send 1:1 emails from gmail (with gmail API connected to Zoho CRM), those emails appear both in gmail's sent folder and in Zoho CRM. That works well. But when we send Mass Emails or Cadence emails form Zoho CRM, they are
      • Integración Books para cumplir la ley Crea y Crece y Ley Antifraude (VeriFactu)

        Hola: En principio, en julio de 2025, entra en vigor la ley Crea y Crece y Ley Antifraude (VeriFactu). ¿Sabéis si Zoho va a cumplir con la ley para cumplir con la facturación electrónica conectada a Hacienda? Gracias
      • I can't found API for Sales Receipts

        Hello May you please help me to find an API document for Sales Receipts to get data and retrive a custom fields like Invoice and credit notes Regards
      • Problem with reports due to "Connected" items change

        Now that the change has been made to use "connected" items I can no longer run the reporting I need in CRM. I should be able to start with Deals as the parent, connect down to the Account (Account_Name) on the deal as the child, then to any child items
      • Kaizen #205 - Answering Your Questions | Managing Picklists and Enabling History Tracking via Zoho CRM APIs

        Hello everyone! Welcome back to another post in our Kaizen series. In this post, we will look at how you can manage picklist fields in Zoho CRM using APIs. This topic was raised as feedback to Kaizen #200, so we are taking it up here with more details.
      • Custom Fonts in Zoho CRM Template Builder

        Hi, I am currently creating a new template for our quotes using the Zoho CRM template builder. However, I noticed that there is no option to add custom fonts to the template builder. It would greatly enhance the flexibility and branding capabilities if
      • Multiple Vendor SKUs

        One of the big concerns we have with ZOHO Inventory is lack of Vendor Skus like many other inventory software packages offer. Being able to have multiple vendor skus for the same product would be HUGE! It would populate the appropriate vendor Sku for
      • Internally created tickets

        Hi there When tickets are created internally on-behalf of customers - there is nothing to show that the ticket was created by an internal agent. This means, that it's easy for our agents to confuse tickets which were created by internal team members and
      • Spilt Axis for stacked column and line graph

        Each month around this time I prepare a business review deck. One of the biggest annoyances I have with Zoho, also happens to be something that most other platforms have provided for a long time now, and that is being able to create a chart with stacked
      • Automatically change website passwords

        Hi everyone, We just switched to a Professional package to also use the "Automatically change website passwords" function. But I cannot find anything about it, how to use it, anywhere. Does anyone know how I can use this function? Best, Caspar
      • Zoho Desk Integration - Add the option to send the estimate from the Zoho Desk Ticket Integration

        Hi, Currently in the Zoho Desk integration, the user is able to create an estimate from a ticket, once the estimate is created the user can see the estimate under the ticket (see screenshot below), but is not able to send that estimate from Zoho Desk.
      • Change Invoice Prices for an Effective Date

        Hi, It would be a really good feature to be able to change the prices on invoices/recurring invoices from an effective date in the event of price increases. For instance, I am in the process of increasing prices that will be effective from a specific
      • "Other Current Asset" accounts as "Paid Through" accounts in Expense

        It would be incredibly useful to be able to assign accounts of type Other Current Asset as Paid Through accounts in Expense. Currently, Other Current Liability are permitted as Paid Through Accounts. This makes sense, as Credit Cards are current liabilities.
      • Multi column open text questions that allows respondents to add rows for additional information

        I need to create a question that has 2 columns with open text, but I also need to allow respondents to click a "+" button, or something similar, so that they can add additional information if they choose to. I've tried using the Multiple Textboxes type
      • Bot Filtering & Apple Mail Privacy Protection Compliance in Zoho Campaigns

        Dear Campaigns Users, The wait is over! We’re excited to announce that the enhanced bot filtering feature is now live in Zoho Campaigns. This update brings greater accuracy to your email campaign reports by distinguishing real user engagement from automated
      • Découvrons les détails qui simplifient vos journées de travail avec Trident

        Nous nous installons dans des routines efficaces et rodées avec le temps. Chaque matin, nous ouvrons nos e-mails, passons aux messages, consultons notre agenda, puis attaquons nos tâches. Ce processus nous semble maîtrisé, mais est-il réellement optimisé
      • No option for pick up in Zoho Books / Inventory but yes on commerce

        Is it planned to release soon on books/inventory?
      • Issue with Purchase Rate Showing as “0” After Importing Items List

        Dear Zoho Books Support Team, Good day. I’m reaching out regarding an issue I’m facing while importing my items list into Zoho Books. Despite mapping all fields correctly and including the purchase price for each product in my Excel file, the Purchase
      • API for Task Entity in Zoho Books

        I’m working on automating task creation in Zoho Books via a custom button in the Bills Module. The goal is to create a task in the Tasks Module and assign it to the Finance Team, so they can track progress efficiently. While reviewing Zoho Books documentation,
      • create invoice in zoho books from the zoho forms

        Is there a native way to have create invoice in zoho books, when zoho form is completed?
      • Next Page