Power of Automation: Automatically send an email to all portal users with today's list of Open tasks.

Power of Automation: Automatically send an email to all portal users with today's list of Open tasks.

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.


Requirement:-


One of our customers wanted to email all the portal users with their list of daily Tasks which are in open status along with details like Project name, Task name, Task URL, start date, due date, status. Sample email notification screenshot is attached for reference.

All you need to do is schedule the frequency for how often the below custom function should be executed. Here is the help document to know more about Schedule Functions.


Custom function code:-


projectParam = Map();

projectParam.put("status", "active");

getAllProjects = invokeurl
[

url : projectsEndpoint +portalId+"/projects/"

type : GET

parameters : projectParam

connection : "XXXXXXX"

];

if(getAllProjects.containKey("projects"))
{

projects = getAllProjects.get("projects");

usersParam = Map();

usersParam.put("user_type", "active");

getAllUsers = invokeurl
[

url : projectsEndpoint+portalId+"/users/"

type : GET

parameters : usersParam

connection : "XXXXXXX"

];

if(getAllUsers.containKey("users"))
{

users = getAllUsers.get("users");

for each user in users

{

userId = user.get("id");

taskParam = Map();

taskParam.put("status", "open");

taskParam.put("owner", userId);

taskParam.put("time", "today");

getAllTasks = invokeurl
[

url : projectsEndpoint + portalId+"/mytasks/"

type : GET

parameters : taskParam

connection : "XXXXXXX"

];

if(getAllTasks!="")

{

tasks = getAllTasks.get("tasks");

taskRow = "";

for each  task in tasks

{

taskRow = taskRow + "<tr> <td>" + task.get("project").get("name") + "</td> <td>" + task.get("name") + "</td> <td>" + task.get("link").get("self").get("url") + "</td>  <td>" + task.get("start_date") + "</td> <td>" + task.get("end_date") + "</td> <td>" + task.get("status").get("name") + "</td> </tr>";

}

sendmail

[

from :zoho.loginuserid

to : user.get("email")

subject :"Today's tasks"

message :"<html> <style> table, th, td { border:1px solid black; border-collapse: collapse; } </style> <body> <h2>Today's Tasks</h2> <table style=\"width:100%\"> <tr> <th>Project Name</th> <th>Task Name</th> <th>Task URL</th>  <th>Start date</th><th>Due date</th>  <th>Status</th></tr> " + taskRow + " </table> </body> </html>"

]

info taskRow;

}

}

}

}


Make sure to replace XXXXXXX with the Zoho Projects connection link name with scope ZohoProjects.Tasks.READ, ZohoProjects.portal.READ, ZohoProjects.Users.READ. Check this link to learn how to create the connection.  Please find the screenshot of sample schedule function attached for reference. 


We hope you found this post useful. If you have any questions, feel free to share them in the comments below.


    Zoho Desk Resources

    • Desk Community Learning Series


    • Digest


    • Functions


    • Meetups


    • Kbase


    • Resources


    • Glossary


    • Desk Marketplace


    • MVP Corner


    • Word of the Day


      • Sticky Posts

      • Zoho Projects Roadshow, USA - 2024

        Dear Users, We are happy to announce the Zoho Projects Roadshows 2024 in USA. This is an excellent opportunity to learn more about Zoho Projects and gain in-depth knowledge of the advanced features. Our team will also discuss industry specific solutions
      • Project Billing with the Staff Hours Method in Zoho Projects

        The Staff Hours Billing Method in Zoho Projects allows you to bill your clients based on the actual time spent by each team member on a project, at the rate set for each user. This is useful for projects where different skill sets are needed and service
      • Tip 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 enable
      • Organize and Track Phases with Phase Custom Views

        Phase Custom Views let you filter and display phases based on specific criteria. This helps you focus on what’s most relevant for you and your team. Filter phases using criteria such as budget, status, and more. Share views with specific users or teams
      • 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 Projects

      Zoho CRM Plus Resources

        Zoho Books Resources


          Zoho Subscriptions Resources

            Zoho Projects Resources


              Zoho Sprints Resources


                Zoho Orchestly Resources


                  Zoho Creator Resources


                    Zoho WorkDrive Resources



                      Zoho Campaigns Resources

                        Zoho CRM Resources

                        • CRM Community Learning Series

                          CRM Community Learning Series


                        • Tips

                          Tips

                        • Functions

                          Functions

                        • Meetups

                          Meetups

                        • Kbase

                          Kbase

                        • Resources

                          Resources

                        • Digest

                          Digest

                        • CRM Marketplace

                          CRM Marketplace

                        • MVP Corner

                          MVP Corner




                          Zoho Writer Writer

                          Get Started. Write Away!

                          Writer is a powerful online word processor, designed for collaborative work.

                            Zoho CRM コンテンツ






                              ご検討中の方

                                • Recent Topics

                                • 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
                                • Due date calculation

                                  Hello, can the due date on a recurring invoice be one day before the next invoice? I tried to use the term "Net 30" but this won't work because some months have 30 days and some have 31. Example: invoice date: 20/10/2024 I want the due date to be 1 day
                                • Design customized business forms to collect data

                                  Hello users, Did you know you can design customized fillable forms and even share them with your users to collect business data using Zoho Office Integrator? In fact, Office Integrator's Fillable APIs allow you to do it right from your web app. Read on
                                • One Contact with Multiple Accounts with Portal enabled

                                  I have a contact that manages different accounts, so he needs to see the invoices of all the companies he manage in Portal but I found it not possible.. any idea? I tried to set different customers with the same email contact with the portal enabled and
                                • decimal point separator will dissapear when editing the value

                                  as you can see here, the decimal point in weight field is available but when I am editing the value, the decimal point is no longer appear here is the current field setting on Deal Module
                                • Multi Select Lookup Support for Zoho Forms Integration

                                  The title says it all. Please develop this. We have to create custom coded widgets for every little thing because this is not supported. This is really annoying. Zoho Creator does not support custom modules. Zoho Forms does not support Multi-select-
                                • What can be done after signing

                                  I was wondering how do you change an email signature to an in person signature if possible after documents have already been signed by other signers? I know you can change it before documents are signed however if someone does want to switch it to in
                                • Importing MAC files - pages, numbers, keynote

                                  Hi we are a company of mac users - so now looking to use Zoho but it looks like we can't import any of our MAC files unless we convert them first?  Is there any way we can do this?
                                • CRM does not map to CRM Plus

                                  I was looking to upgrade some of my users to Zoho CRM Plus. They are currently using Zoho CRM. But I have been told by my account manager that 'The CRM data within your current Zoho CRM subscription will not be mapped to CRM Plus.' So what's the point
                                • Zoho Sheets hide or unhide columns. How it impacts other users

                                  Hi I would like to know, when someone hides a column in the Zoho sheet, the hidden column is also hidden from everyone else that is using the file. The collaboration feature seems to not work.
                                • How can I add a calendar invite to my campaign emails?

                                  I use Zoho Campaigns to attract prospects to a series of webinars that we run. I have a general pool of contacts that I campaign to, and I have them join a new list for the specific webinar they wish to join. What I would like to do next is send an email to those that want to join a webinar, with a calendar invite that they can accept to add to their Outlook calendars (containing the URL and details of the webinar). How can I do this?
                                • Enhanced Sign-in UI and OTP-Based Password Reset for Portals

                                  As of 5th December, 2024, we are introducing enhanced sign-in interfaces and One-Time Password (OTP) based verification for password reset in an effort to improve security and stream the user journey across all portals. What's changing New Interface for
                                • Zoho Forms to CRM Lookup Field

                                  Hi There, We have a public link for our stores to complete a daily safety audit, we used to be able to link Zoho Forms into CRM and connected related modules however don't seem to be able to get it to work. Zoho Forms has a drop down of the store listings - as this is a public form the CRM function doesn't work When the form is completed I want to integrate into a custom module (Safety Audit) with one of the fields a lookup field (Store) that links to another custom module (Store Listing) Is there
                                • Rescheduling service appointments

                                  I want to be able to schedule the same resource for several service appointments whether or not they are closed out or rescheduled. I dont want them to conflict....i want to be able to double book our techncians. Is there a way?
                                • ¿Cómo puedo configurar las contraseñas creadas bajo una directiva para que nunca caduquen y no aparezcan como caducadas en los informes?

                                  ¿Cómo puedo configurar las contraseñas creadas bajo una directiva para que nunca caduquen y no aparezcan como caducadas en los informes? La razón por la cual contraseña estas no deben caducar es porque su actualización depende de mi cliente y no de mí.
                                • Enhanced duplicate management and unified approvals in Forms

                                  Greetings, I hope all of you are doing well. We're happy to announce a few recent enhancements we've made to Bigin. We'll go over each one in detail. Introducing unified form approvals We're excited to announce our new unified approvals feature, designed
                                • Improve Collaboration and Communication with Mass Comments

                                  Hello everyone, Customer service is a dynamic space where agents are often required to collaborate with other teams to resolve customer issues with quick and accurate solutions. For example, imagine multiple customers raise tickets stating that they are
                                • Zoho Books - Baixa como Remissão - Status = Pago

                                  Ao Baixar uma fatura como Remissão (Prejuízo) o Zoho coloca o status como Pago. Quero dar baixa em algumas faturas pendentes (Cliente que não vai pagar), mas quando faço isso, o status das faturas aparece como "Pago". Claramente, esse não é o caso e preciso
                                • When Zoho Tables Beta will be open to EU data center

                                  Hello all, We in EU are looking at you all using and testing and are getting jealous :) When we will be able to get into the beta also? We don't mind testing and playing with beta software. Thank you!
                                • Is it possible to do validation for the Actions added to Reports?

                                  We have an all-around On Validate function that checks all the possibilities before the Created/Edited form submissions. We want to have a button in the report view, so we can change records without entering. We are able to add this button, and it does
                                • Deluge Count Function for Subform is it supported

                                  Hi This var1 = count(SubForm_1[ID!=0 ]); Gives the error Form SubForm_1 does not exist in this application Is there a syntax mistake or is it no supported in such a manner
                                • BUG do APP IOS do Zoho Mail

                                  Olá, Percebi que quando abro um anexo no APP IOS do Zoho Mail não existe um botão de retorno à caixa de e-mail. Tenho que fechar o aplicativo e abrir novamente. Vocês já mapearam isso? Existe algum botão que não vi? Abs Marco
                                • Introducing advanced statistics for TikTok and other Social enhancements

                                  Dear customer,   We've introduced some exciting and much-awaited updates on Zoho Social. You can now interact with your TikTok videos and do much more. These enhancements will help you publish your Tiktok content smoothly, understand your audience better
                                • Bigin Calendar view - set Monday as first day of week

                                  Hi, is there a way to set Monday as first day of the week on Bigin Calendar view? Antonio
                                • Create list dropdown of all form names

                                  Hi everyone, Can i create dropdown list by all form names? Thank you
                                • When Field not empty -> Mandatory subform entry

                                  Here is the scenario. 1. Field: Days of delay is not empty 2. Then: Show Subform below and require to add entries: I managed to setup a layour rule to show the subform when the field has some values. Even though the subform as well as its columns are
                                • Multiple products per account issue

                                  We are currently looking to move to Zoho CRM from another package.  I have a need to be able to track multiple lines of the same product for an account.  For instance, we track the product (concurrent user license) for every time a customer orders an
                                • Zoho Sites "pages" management page

                                  I have 80 plus pages on zoho sites. When I go to the "pages" link to view and edit pages, They are not in any kind of order, so I spend lots of time searching for pages when I need to edit or create new. How can I change the view order of all my pages
                                • Zoho und die Art, Dinge zu tun

                                  Zoho und die Art, Dinge zu tun Ich habe Zoho seit über zehn Jahren in verschiedenen Projekten implementiert – einige groß, andere sehr groß – und habe sogar für einen der weltweit führenden Zoho-Partner gearbeitet. Jedes Mal, wenn ich ein Zoho-Implementierungsprojekt
                                • Missing users in CRM workflow notification and "share with zoho cliq"

                                  Hi, I'm creating a workflow that should send a notification to a Zoho Cliq user when a Lead with specific lead source enters the CRM. The problem is that not all users are showing up in the select menu, when I choose "Notify to Zoho Cliq - Users". As
                                • Zoho mail account not active

                                  Hello, i'm trying to login to zoho mail but it sends a error message saying my "account is not active". What should i do to fix this out? Thanks Regards
                                • Is it possible to have conditional pages?

                                  We have a Document, which consists of multiple different subdocuments. We want to have the subdocuments as pages inside a doc and only show them in specific cases. Is it possible to have conditional pages inside of a mail merge based on CRM data?
                                • Zoho Connect Ultimate in Zoho Workplace bundle ?

                                  Hello, I'm using Zoho Workplace for few years now, that includes Zoho Mail, Zoho Cliq, Zoho Workdrive and Zoho Connect Enterprise. I would like to use Zoho Connect Ultimate. How could I upgrade ? Thanks. Joffrey
                                • Sync info from Accounts to Deals in Zoho CRM

                                  Hey! How do i set it up so that the data i put in the account automatically syncs to the deal that i create from the accounts page?
                                • How can i download zoho meeting transcription by api ?

                                  I am using this api to get transcription download url https://meeting.zoho.com/meeting/api/v2/%7Bid%7D/recordings.json I tried to download using transcriptionDownloadUrl in response, but I got 403 error. Is there any endpoint to download it or any scope
                                • Power of Automation :: Clone the details of the Parent task to its sub-tasks automatically

                                  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
                                • How to move recors from one custom module to another custom module

                                  Hi there, currently i have a module called sample/production where i have two different types of records inside this module, one sample and the other production. I want to be able to transfer all the sample records without losing any data to a new module.
                                • Creating a Workflow to add Meeting on Calendar

                                  I'm trying to create a very simple Workflow to create a Meeting on my calendar when a Deal is created. This seems like a very basic thing and it's not working. Here are a couple of screenshots...what am I missing?
                                • User Name in Zoho Cliq Not Updating Across Apps?

                                  We updated the name of a user in Zoho. (From Sue to Taylor) Her name has not been updated in Cliq on all apps. When in Zoho One, if I go to Cliq directly, it is correct, but if I am in another app, and the Cliq bar pops up on the bottom, it will be the
                                • Can Zoho do these tasks? (Long post!)

                                  Hello everyone, I run a business which helps customers access home energy efficiency upgrades. Our workflow involves generating leads through a Tally form and storing these in Airtable, but I’m finding Airtable’s limitations (such as constant horizontal
                                • Next Page