
Welcome to April, the season of blooming trees and blossoming flowers! As nature comes alive, so does our community. Dive into this month's digest to explore vibrant discussions and exciting announcements.
Zoho CRM product updates:
Email-related enhancements in Accounts and Deals modules in CRM:
- We're excited to unveil a highly anticipated feature in Zoho CRM: the ability to send emails directly from the accounts module. The email composer in Accounts module now offers quick suggestions for related contacts' email addresses, and makes it possible to access attachments and email templates specific to the Accounts module. Additionally, in the Deals module, email addresses of "contact roles" linked to the deal record will now be provided as quick suggestions. Explore the announcement for more details.
Resolve Conflicts during Deployment in Sandbox:
- This announcement introduces notable upgrades to Zoho CRM's Sandbox, specifically targeting conflict resolution and some UI enhancements. Users can now swiftly access comprehensive conflict details right from the "Check Dependency page" and resolve issues directly from there. These updates aim to streamline the deployment of sandbox changes to production accounts, tackling common pain points such as missing associated items, duplicate name conflicts, and developer-user association conflicts. For more details, refer to the announcement post.
Introducing Zia Notes Summary:
- Introducing Zia Notes Summary, a new feature in Zoho CRM that offers users quick summaries of their CRM notes. This feature is particularly beneficial when navigating through numerous notes or requiring a concise overview of details captured in the notes section. This update provides two summaries: "Overall Summary" for a bird's-eye view of all notes on a record, and "Last Note Summary" for the most recent update. For a deeper dive into the new feature, check this announcement.
Multiple Kanban Views per Module:
- Previously, users were limited to one Kanban view per module, necessitating edits for different categorisations. Now, with the latest update, multiple Kanban views are supported, enabling effortless switching between views. The ability to expand and collapse stages in the card view enhances its compactness. Deal stages can be updated swiftly via drag-and-drop functionality, and stage-specific records can be created directly from the Kanban view. Moreover, access permissions can be set to control viewing and editing privileges for each Kanban view. Additionally, pipeline selection will be persisted until the user changes it, an option that was requested by many community members previously[Ref]. Check out this announcement for full details.
Add Tasks to Zoho CRM Calendar:
- We're excited to announce that the option to add tasks to the CRM calendar, a much-awaited feature requested by the community, has now been implemented. With this, you get daily and weekly views of CRM tasks in the Calendar, allowing you to easily keep track of your tasks right alongside your meetings and calls. Additionally, you can switch between single and multi-user views to manage tasks effectively and, create tasks directly from the calendar. For more details and resources related to this release, check out this Idea post.
Useful Discussions:
- @Felipe Salomão de Sousa Vale wanted to auto-format the phone numbers by removing special characters and spaces, including the country code if not present, and prefixing phone numbers with only 11 digits with the "+" symbol. @Bhoomi Joshi and @Rodger Brehau provided the required suggestions for formatting the phone numbers using Functions. Check the post to learn more.
Sales duo performance tracking:
- @Bas van den Berk brought up an interesting sales report requirement. Every prospect is assigned to a pair of consultants. They wanted to add a matrix-like component to their dashboard to track the performance of sales duos based on the number of clients they have successfully closed, and to visualize the data to quickly identify the most successful duos. @Anonymous User suggested using a "Heat map" chart as it makes it easy to identify the top performing sales-duos at a glance. Discover the details in this post.
Multi-product purchase tracking at the Account level:
- @Ashley was reviewing an old post on tracking multiple product purchases by the same Account. While a Subform based solution was already suggested, @Max Tyack proposed an alternative approach using a custom module and lookup fields, which Ashley welcomed. Max also confirmed that Ashely's additional requirement for auto-updating prices across records can be achieved with either approaches using Workflows and Functions. Check out @Max Tyack's response in this post for further details.
Functions:
- @Alejandro wanted to automatically capitalize the first letter of each word in a contact's information for all fields, regardless of how users enter it. @Rodger Brehaut shared the Deluge code to be associated with a workflow, which runs when the record is edited. Check this post for the code.
Execute Function only for select deal stages:
- @Chris wanted to run a Function based on a deal's stage and needed to know how to best exclude select deals stages. @Hugh Marshall and @Bhoomi Joshi came up with different approaches to solve the same need, each, creating a list of stages to avoid and validating if the active deal is is not on that stage list. Check the code they shared in this post.
Automating Quote Management:
- @Coen | Heative mentioned that their sales process involves sending multiple quotes to customers, with only one being accepted. Once a quote is marked as "Won", they would like the other related quotes for the contact record to be automatically updated to "Lost". Check the solution proposed by @Ishwarya in this post, which includes a code snippet to be associated with a workflow to meet this requirement.
UpdateRecord Success:
- @David Shaw uses an updateRecord call in a Function, triggered by a clicking a button, and wanted to check whether the response indicates a success or failure. They provided a simple code for this requirement, with @Bhoomi Joshi and @Anonymous User making the necessary tweaks to get it to work. Check this post for the working code.
Auto-updation of deal stage:
- @Benjamin wanted to update the deal stage to "Scheduled" automatically whenever a new meeting is added to a deal record in Zoho CRM. @Anonymous User shared theFunction code to achieve this. Check this post for the code.
Optimize CRM storage by automatically moving or deleting attachments:
- @Anthony observed that their users were adding multiple attachments to a custom module, which significantly increased the CRM storage usage. They were looking for a way to automatically delete attachments or move them to Zoho WorkDrive when a field's status is set to certain criteria. Check out the solution posted by @Hugh Marshall, complete with code, in this post to achieve this.
Calling Functions linked to a Workflow:
- @David wanted to know if there's an efficient way to call a Function running within a Workflow from another similar Function without exposing the first Function via API. @Nicolas Donoso provided the solution: call the first Function using the automation namespace in the code. Check this post for the solution and sample code.
Dev's Corner:
- @Felipe wanted to show an alert during the deal creation stage if a specific field is duplicated, without blocking the deal creation process. @Hugh Marshall suggested using Client Script, and @Anonymous User provided a detailed explanation including sample Client Script code, to prompt users about duplicates while allowing them to proceed and save if needed. Check this post for the solution.
Real-time Dropdown popup for CRM field update during deal Creation:
- @Javier Molina wanted to open a popup with a dropdown list for users to select an option and pass it to a CRM field in real-time during deal creation. Check this post for Subash Kumar's Client Script code that fulfils this requirement.
Best practices for handling large record sets:
- @David sought best practices for handling large record sets, especially when iterating over more than 200 records at once. Multiple community members shared their solutions, with @Kiruthiga recommending the use of the COQL API to determine the total record count. Additionally, she provided helpful tips and sample code for effectively handling large data sets. Jump into the post for detailed answers.
Filtering recent calls by date and time:
- @Paul de Geode encountered difficulties retrieving calls made in the last week, particularly in filtering records by date and time using the V2 API. @Christoph Wenzel and others offered workarounds, recommending either the use of V6 API or COQL to address the issue. For more details, check out this post.
Naming variables in Deluge scripting:
- Big shout out to @Rodger Brehaut for sharing invaluable insights on naming conventions for variables in Deluge scripting based on their type! Rodger suggests opting for descriptive names over generic ones like "response," making future code easier to understand and work with. Read this post to learn more.
Kaizen:
- This post discusses self-client and server-based clients in Zoho CRM. Check out this post for videos and detailed explanations, along with suggestions for further reading to see how they're applied using Java SDKs.
Kaizen #134 - Manipulating Rich Text Field (RTF) using Zoho CRM APIs:
- Want to understand the ins and outs of working with Rich Text Field (RTF) and how to manipulate RTF using Zoho CRM APIs? Look no further than this post.
Thanks for taking the time to read this month's round-up. Keep tabs on the digest every month for the latest ideas and discussions. Stay tuned and engage in the Forums to be included in the upcoming month's digest. Have a wonderful month ahead!
Recent Topics
Nodemailer not working with Zoho
Hi All, I'm having issues with Zoho working with Nodemailer. It works as expected when using gmail as the service. Below is the code I get when using zoho. Error sending email: Error: connect ECONNREFUSED 127.0.0.1:587 at TCPConnectWrap.afterConnect [as
desktop app for TODO
Is there a desktop app for Zoho TODO?
Show/ hide specific field based on user
Can someone please help me with a client script to achieve the following? I've already tried a couple of different scripts I've found on here (updating to match my details etc...) but none of them seem to work. No errors flagged in the codes, it just
Where are Kanban swimlanes
So i've been playing with Zoho Projects Kanban view a bit more. It appears that task lists are being used as the Kanban columns, which makes sense from the implementation point of view but not the logical one. Kanban columns are statuses that a task can flow through, while a task list has been a logical way to organize related tasks and relate them to a mislestone. In other words a task in a particular task can go through several stages while remaining in the same task list. After doing some research
Tip 19: How to display images in Pages using ZML snippets
Hi folks, We're back with another tip on how to use Zoho Markup Language (ZML) to create interactive pages in Zoho Creator. You can use ZML snippets to add various kinds of components to your pages and structure them in meaningful ways. That's not all, though—using ZML you can ensure your application is automatically compatible with all kinds of devices without any inconsistencies. We often get questions from users about how to invoke Deluge scripts within ZML code. Here's a simple use case for adding
Can zoho swign format block text spacing automatically when prefilled from zoho crm?
I'm sending zoho sign template from zoho crm, so that zoho crm pre-populates most fields. I have existing pdf documents that i am having signed. I have no ability to change the pdf documents, they are standardized government forms. The problem I am facing
Reference lookup field values in Client script
hello all, I'm using a "ZDK.Apps.CRM.Products.searchByCriteria" function call, which is returning the matching records correctly; however, one of the fields is a lookup field which I need the associated data. I believe there is a way to get this data
Every time an event is updated, all participants receive an update email. How can I deactivate this?
Every time an event is updated in Zoho CRM (e.g. change description, link to Lead) every participant of this meeting gets an update email. Another customer noticed this problem years ago in the Japanese community: https://help.zoho.com/portal/ja/community/topic/any-time-an-event-is-updated-on-zohocrm-calendar-it-sends-multiple-invites-to-the-participants-how-do-i-stop-that-from-happening
How can I filter a field integration?
Hi, I have a field integration from CRM "Products" in a form, and I have three product Categories in CRM. I only need to see Products of a category. Thanks for you answers.
Zoho CRM - Portal Users Edit Their Own Account Information
Hi Community, I'm working on a client portal and it seems like the only I can make the Account record editable to the Contact, is if I add another lookup on the Account to the Contact record. Am I missing something as the account already has a list of
Connecting Zoho Mail with Apollo.io
Hi, I am trying to connect my Zoho Mail account with my Apollo.io account to start sending cold email for prospecting purposes. I have activated the IMAP setting but I am still unable to connect to the Apollo account. I am using my email credentials but
Where does this report come from in the Zoho One ecosystems?
Is this directly from MA, Analytics or ??? ???
Contact's title in "Contact Role Mapping"
When I'm creating a deal, I'd like to see the contacts title in the listing. Right now, I only see this: How can I get the contact's title in there?
Zoho CRM - Client Portal - Hide Notes Related List
Hi Community, I'm building a customer portal and I can't find a way to hide the notes related list. I don't want the client to see the notes I have about them. Is there a way to do this as it is no bin/trash icon when I hover over.
"Pivot Table" Conditional Formatting
Team, I there a way to use conditional formatting a "Pivot Table" report? Thanks, Arron Blue Pumpkin Hosting | Solutions Made Simple
How many clients can be added to Zoho Practice?
How many clients can be added to Zoho Practice without having their zoho app?
Stage History
when viewing a ticket , and you look at stage history tab (kanban view) and look at the stage duration column in days, it shows the current stage of the ticket as " current stage ". Should it not rather show the amount of days it has been in that current
Automating Ticket Responses Using Zoho Desk's AI Features
We’re looking to set up an automation within Zoho Desk that can analyze incoming emails or tickets and automatically respond with relevant knowledge base articles based on the content of the request. Could you please guide us on how to configure this
Service locations are tied to contacts?
Trying the system out. And what I discovered is that it seems that the whole logic of the app is, I'd say, backwards. There is a Customer - a company. The company has contact persons and service locations can be associated with different contact persons.
Enhancements to Zoho Map integration tasks
Hello everyone, We're excited to announce enhancements to the Zoho Map integration tasks in Deluge, which will boost its performance. This post will walk you through the upcoming changes, explain why we're making them, and detail the steps you need to
Bug in Total Hour Calculation in Regularization for past dates
There is a bug in Zoho People Regularization For example today is the date is 10 if I choose a previous Date like 9 and add the Check in and Check out time The total hours aren't calculated properly, in the example the check in time is 10:40 AM check
Narrative 12: Sandbox - Testing without the risk
Behind the scenes of a successful ticketing system: BTS Series Narrative 12: Sandbox - Testing without the risk What is a sandbox environment? A sandbox environment is a virtual playground that allows you to test freely and experiment with various elements
Announcing new features in Trident for Mac (1.27.0)
Hello everyone! Trident for macOS (v1.27.0) is here with new features and enhancements to improve scheduling and managing your calendar events. Let's take a quick look at them. Stay aligned across time zones. Both the scheduled and original time zones
Slow uploads of large files
I'm wanting to use Workdrive for transferring large images and video (we're talking things from 100MB-5GB). I'm running solo on a 500MBit/sec fiber connection. I'm getting upload speeds to Workdrive of no more than about 1-3Mbytes/sec when going through
Migrate Your Notes from OneNote to Zoho Notebook Today
Greetings Notebook Users, We’re excited to introduce a powerful new feature that lets you migrate your notes from Microsoft OneNote to Zoho Notebook—making your transition faster and more seamless than ever. ✨ What’s New One-click migration: Easily import
need to upload from airtable to google drive
I have a zapier zap that automates between airtable and google drive. When a customer uploads a new file into airtable via a client portal interface, zapier uploads that file into a folder linked to that customer's project record. I need to replicate
Can't delete functions that are associated with deleted workflow rules
We have a handful of functions that were once associated with a workflow rule, but the rule has been deleted. The function still thinks it is associated so I can't assign it to a new rule. It is starting to get really messy because we have a list of functions
Default Sorting on Related Lists
Is it possible to set the default sorting options on the related lists. For example on the Contact Details view I have related lists for activities, emails, products cases, notes etc... currently: Activities 'created date' newest first Emails - 'created
Credit Management: #1 Credit You Owe vs Credits Owed to the Business
Think about the last time you ordered food online. You might have paid in advance through your card, but you received a $20 refund because your order got delayed or cancelled. In most apps, refunds don't go into the bank account directly; instead, they're
Tip #46- Turn Every Session into an Insight with Zoho Assist survey report- 'Insider Insights'
Delivering exceptional remote support isn’t just about resolving issues, it’s about understanding how both customers and technicians experience each session. That’s where Survey Report in Zoho Assist come in. You can configure and customize survey questions
CRM/Bookings integration edits Contact names
Hi there, I've installed the extension that connects Zoho CRM and Zoho Bookings. When we get a new appointment from Bookings from an existing Contact, that Contact's record shows this: First Name was updated from asd to blank value Last Name was updated
Domain Change
“Please update my Email-in domain from @biginmail.biginmail.in to @biginmail.zoho.com. Messages to the .in domain are bouncing.”
Webhooks Limit Exceeded
Today, I received an error message saying, 'Total number of Webhook call exceeded', but when I look at Manage > Billing, it doesn't look like any of my invokeURL calls are being logged. Following the advice from this thread: https://help.zoho.com/portal/en/community/topic/webhooks-daily-limits-in-zoho-creator
Auto select option in CRM after Zoho Form merge
Hi, I have a dropdown field in Zoho CRM that is filled with a Zoho Form. The data is filled but not automatically shown. After selecting the right value in the dropdown the information a second field is shown. So the question is; how can I make the dropdown
Bring your CRM data straight into your presentations in Zoho Show
Let's say you are working on a presentation about your team's sales pipeline for an upcoming strategy meeting. All the information you need about clients and leads is in Zoho CRM, but you end up copying details from the CRM into your slides, adjusting
Zoho People 2.0 Help Manual
Hello All, Zoho People Help Documentation is now available at this link. Please go through and get in touch with us at support@zohopeople.com in case of any questions. Regards, Hemalatha Chandrasekaran | Zoho People
Introducing New APIs in Zoho Contracts
We are excited to announce the release of new APIs in Zoho Contracts to help you automate and manage every stage of your contract lifecycle more efficiently. Here’s a quick overview of what’s new: 1. Complete Contract Draft You can use this API to complete
Vimeo
For me Vimeo is the most important video social channel for media and filmmakers. Would others agree and like it added to Zoho Social.
Delete a department or category
How do I delete a Department? Also, how do I delete a Category? This is pretty basic stuff here and it's impossible to find.
Organization Emails in Email History
How can I make received Org Emails to show up here?
Next Page