Zoho CRM Community Digest - August 2025 | Part 2

Hello Everyone! Here's a quick round-up of handy tips, clever workarounds, and product updates from late August.

Product Updates:

Meeting Enhancements in Zoho CRM! 

Track whether a meeting is online, in-office, or at the client’s location using the new Meeting Venue option. This enhancement lets you categorize meetings for easier organization, filtering, and reporting. You can also mark meetings as all-day, set them to repeat, or remove venue options from the picklist that doesn’t fit your business needs. For admins, a new Preferences Tab enables managing online meeting providers directly from CRM without needing to visit the Marketplace. This full post has screenshots and key notes worth checking out.

Quick Wins:

Portals: Account-Level Access Challenge

Your customers, linked as Contact records, can access their information via the CRM portal. @Ivan Staykov brought up an interesting use case where individual Contacts should only access records linked to their emails, while the CEO of their company should access all Contact records linked to their Account. As CRM portals are tied to Contacts, not Accounts, this setup isn’t straightforward. @Max explored options, and @Amy shared a workaround that sparked Ivan’s interest. If you’ve run into the same limitation, this thread is a must-read for practical insights.

Understanding how custom view un-enrollment works in Cadences?

@Matt Warner asked if leads enrolled to a Cadence through a custom view gets automatically un-enrolled when they no longer meet the view criteria. @Sunderjan Siddharth clarified that leads will remain in the Cadence and continue their scheduled steps unless an unenrolled property is specifically linked to the custom view condition. Once that property is set, the system will automatically remove leads that drop out of the criteria. Check out the full post for more on how Cadence un-enrollment works and how to fine-tune your setup!

Tip for targeted marketing campaigns for Contacts with closed Deals!

@Dalton wanted to run a marketing campaign targeting Contact records with closed Deals but faced a challenge: some contacts have multiple deals, with a mix of open and closed statuses. Simply filtering for closed deals would still include contacts who have open deals, which wasn’t desired.@Sunderjan Siddharth suggested using roll-up summary fields in the Contacts module to count total deals as well as open and closed deals per contact. This lets you build reports that accurately excludes contacts with any open deals. Check out the full post for detailed steps, screenshots, and where to set this up!

Developer's Corner: 

Can you fetch 200+ records from a Custom View at once?

@Sam wanted to pull all records from a Custom View exceeding  the 200-record limit without using pagination. @Sunderjan Siddharth clarified that COQL can fetch up to 2,000 records in a single query, and suggested using a loop to retrieve up to 100K records efficiently.Check-out the post for the full solution on  handling large datasets effectively in Zoho CRM.

Make attachments mandatory before closing Deals:

@Jhonata wanted to make it mandatory to add attachments before marking a deal as Closed-Won. @Rakesh Kumar suggested triggering a Client Scripts on the Stage field update across touchpoints like the Details, Edit, and Canvas pages to check for attachments, cancel submission if none exist, and display an alert. @Pheranda Nongpiur followed-up with step-by-step guidance and shared the sample Client Script to check attachments on save. Check the full post for the scripts and detailed setup instructions!

How Marta leveraged AI and assistance from the community to automate Quote stage updates:

@Marta wanted all quotes with stage "Next Year" to automatically update to "Draft" on a specific date. @Bhoomi Joshi suggested creating a scheduled function to fetch quotes from a custom view and update the stage, recommending that Marta test with a few records first before connecting it to a Schedule. Despite being a non-coder, Marta used AI to generate the required code and then collaborated with the Community to refine and get it working.Check this post for the step-by-step setup, code tips, and insights on how Marta made it happen!

Kaizen:

Answering Your Questions!

(Kaizen #204) - Perform Field Updates before Blueprint transition via Client Script

Learn how to enhance your lead follow-up Blueprint by prompting users for input during Blueprint transitions and updating description field with detailed comments in Zoho CRM. Kaizen #204 demonstrates how to use beforeTransition scripts to capture comments, validate input, and maintain a running comment history. In this setup, a popup prompts users to enter a comment before each transition. If the comment is fewer than 25 characters, the transition is stopped; otherwise, the system appends the comment along with the transition name and user’s name to the Description field. This is a practical way to improve transparency and traceability in your Blueprint process. Check the post for the full code and setup!


(Kaizen #205) - Managing Picklists and Enabling History Tracking via Zoho CRM APIs

Kaizen #205 breaks down the difference between Picklist and Multi-select Picklist, shows you how to set up global picklists across modules, and explains how to enable history tracking in Zoho CRM using APIs. It's super detailed and walks you through creating and updating picklist fields, removing options, assigning and updating values in records, and turning on history tracking with step-by-step API examples. The inclusion of sample code and responses for each part makes it easy to follow. Give this post a read if you want to get these features set up smoothly!

And that’s a wrap for this fortnight’s Zoho CRM Community Digest. Caught something cool we missed? Or have a favorite from this edition?

Drop it in the comments! We’d love to hear from you. We’ll be back in two weeks with more updates and community gems.

Until then, stay tuned!

• Topic Participants

• Swetha S

  

• Sticky Posts

• How to reach the official Zoho Support channels and avoid fake ones.

  Dear Customers, Thanks a lot for choosing Zoho! Our applications are built to help achieve your day-to-day business goals. We are committed to engaging with you, to understand and develop solutions that enhance your productivity.  We are happy and ready to help you use our services effectively. Understanding and avoiding fake support Just like using popular bank names and financial applications for phishing purposes, using Zoho and claiming to be providing Zoho Support or services with false numbers

• Function #35: Close all tasks associated with a lead and create a new task.

  Welcome back everyone! Last week, we learnt how to close all tasks of a deal depending upon the deal stage. This week, let's look at a custom function that lets you close all of the tasks associated with a lead while simultaneously creating a new task, like when you need to halt all progress towards a lead while the lead is not available at the moment but create a reminder task. Business scenario: The success of a company, in one way or another, is determined by the leads it gets. Each lead is just

• Zoho CRM Webinar - Redesigning Daily User Experiences with Canvas

  <br> Your users across roles use the CRM for day-to-day tasks that are necessary. Whether they perform their tasks on time, the right way, or at all depends on a lot of factors, including User Experience. Many businesses struggle with rigid layouts,

• Join us at the Canada ZUG Meetup: What’s New in Zoho CRM

  Hello Zoho Community! Start your year with fresh insights into Zoho CRM’s latest updates and tools. Whether you're a CRM beginner or a experienced user, this meetup is crafted to help you optimise your processes and leverage new features. Explore practical

• CRM Hack #2: Automate sending of birthday greetings to your customers.

    Hello everyone! What sets you apart as a sales person is your ability to add that personal touch to your business relationship with your customers. Sending a gift on a special day, or leaving a note wishing them on their birthdays, are small, yet significant actions that show your customers that you care. And these are actions done without any expectations :) You must be engaging with a lot of customers and it is highly unlikely that they all are your friends on Facebook or some social channel,

• Recent Topics

• Customization hacks in Zoho Writer - Part 2

  Hey community, We're back with some more tricks to personalize your documents, save time, and get in the zone when you work in Writer. Check out part 1 of this post if you haven't already. Let's dive right in! Document ruler units Imagine you're creating

• Simplify your tax calculations with Zoho Writer

  Hello Zoho Writer Community! Tax season can be stressful, but with Zoho Writer, managing your income tax calculations becomes straightforward and efficient. Here’s an example of how you can use the tables and formulae of Zoho Writer to calculate income

• Enhance document navigation with headings and TOC

  Hey Zoho Writer Community! We're back with some useful features in Zoho Writer that can simplify your document creation and navigation process. Let's dive right in! Check out our video on how to make the most of Zoho Writer's heading and table of contents

• Use and download in PDF format of Zoho wirter Merge template using deluge

  Hello Zoho Developers. Here is some information about Zoho Writer. Writer is not just another online word processor, it's a powerful tool for editing, collaboration, and publishing. Even with its wide range of features, Writer's pared-down user interface

• Customization hacks in Zoho Writer - Part 3

  Hello everyone, Welcome back to Part 3 of our customization tips in Zoho Writer! In this third installment, we'll be diving into some essential customization settings that can enhance your document creation experience. Sender email address in mail merge

• Daytime saving timezones messing up writer pdf

  Hi, I need help for something I can't figure out. I created a Form to collect data and it is set up with my current Daylight Saving Time (GMT-3). This form is used to generate a contract (pdf Writer) with dates from an event that is being held in 4 months

• Issue with locked content in Writer

  Hi, I have seen the documentation which outlines how to lock specific content within a Writer document so that it can't be modified by collaborators, but I have come across an issue. When the editor locks a paragraph for example, then a collaborator can't

• Deprecation of certain URL patterns for published Zoho Writer documents

  Hi Zoho Writer users! We'd like to let you know that we have deprecated certain URL patterns for published and embedded documents in Zoho Writer due to security reasons. If the published or embedded documents are in any of these URL patterns, then their

• [Announcement] Enhanced Merge APIs of Zoho Writer for automating document generation using Zoho Apps data

  Hi users, With the record_id parameter in Zoho Writer's Merge APIs, fields related to the given record id is automatically fetched from the Zoho app. You don't have to spend time manually mapping the records and fields in the Deluge code. Here is a sample

• [Important announcement] Removal of Zoho Writer's DocuFiller Add-on

  Hi users, Effective 21st Feb. 2025, we will be removing the DocuFiller add-on for Zoho Writer's Fillable Templates. From that point on, the add-on's functionalities, such as sharing or publishing fillable forms for data collection and receiving submissions

• Using Mail Merge Template to Print Documents with One Subform Record's Fields per Document

  Hello, We have a Mail Merge template created in Zoho Writer which is not able to perform the functionality which is currently required to automate the documentation task portion of our process. The CRM module we are primarily using is based on a "Loans"

• Zoho Writer - Option to Export as .zdoc format

  I've noticed that it's not possible to export a Zoho Writer Document in the .zdoc format. Isn't zdoc, Zoho Writer's own format? My use case is that I sometimes need to create quite complex documents with floating elements, which sometimes need to become

• Problem with Writer and Workdrive

  Hi team, I’m the super admin for our Zoho One org. WorkDrive is active, and Zoho Docs is deprecated for our org. However, Zoho Writer cannot connect to WorkDrive at all — we’ve cleared cache, tried incognito, and restarted several times. I was able to

• Set to Review for all

  We are testing the use of Writer as part of an internal review process for statement of work documents and have found that when the document is changed from Compose to Review by one person, that is not reflected for all others who view the document. Is

• I’ve noticed that Zoho Sheet currently doesn’t have a feature similar to the QUERY formula in Google Sheets or Power Query in Microsoft Excel.

  These tools are extremely helpful for: Filtering and extracting data using simple SQL-like queries Combining or transforming data from multiple sheets or tables Creating dynamic reports without using complex formulas Having a Query-like function in Zoho

• Shortcut to fill a range of cells

  Good evening: I'm writing because I haven't been able to find a feature that allows you to select a range of cells, type in one of them, and then use a key combination to type in all of them. In Excel, the keyboard shortcut is Ctrl+Enter. I haven't found

• stock

  bom/bse : stock details or price =STOCK(C14;"price") not showing issue is #N/A! kindly resolve this problem

• SOME FEATURES ARE NOT IN THE ZOHO SHEET IN COMPARISION TO ZOHO SHEET

  TO ZOHO sir/maam with due to respect i want to say that i am using ZOHO tool which is spreadsheet i want to say that some features are not there in zoho sheet as comparison to MS EXCEL like advance filter and other Features which should be there in ZOHO

• Zoho sheet for desktop

  Hi is zoho sheets available for desktop version for windows

• Slicers are now available in Zoho Sheet—filter your data interactively

  At Zoho Sheet, we diligently track user requests and feedback. In line with this, based on extensive user requests, we've integrated Slicers to pivot tables and are delighted to announce its release. Slicers are interactive visual filters that have add,

• Tip #18: 6 Trendlines and when to use them in your spreadsheet data?

  Charts are a great tool for visualizing and interpreting large chunks of data in spreadsheets. Zoho Sheet offers you 35+ chart options, along with AI-powered chart recommendations based on the data set you select. There are various chart elements that

• Feature enhancement: Highlight rows based on a cell value

  Hello Sheet users, We're excited to announce a new feature enhacement, shaped directly by your valuable feedback! As you might know, conditional formatting is a great tool for anyone dealing with large data sets. Previously, if you’ve ever wanted to draw

• Perform customized calculations with the new LAMBDA functions!

  We released the LAMBDA function in Zoho Sheet in 2021, enabling customized calculations inside predefined functions. Now, we're extending LAMBDA's capabilities with six new functions. Each of these functions applies LAMBDA to the given input, performs

• No chat option

  Chat option is not supported.

• Tip #17: Easily share spreadsheets with non-Zoho account users

  With efficient, collaboration-friendly options, Zoho Sheet is a popular choice among users. Sheet's external share links help you collaborate more effectively by sharing your spreadsheets with anyone outside your organization, including users who do not

• Work seamlessly with Sheet's shortcuts without affecting the browser

  Navigating your worksheets and performing specific actions should be a quick and easy process. That's where keyboard shortcuts come in. Shortcut keys help you accomplish tasks more efficiently, eliminating the need to move away from the keyboard. What

• Zoho Sheet for iPad: Improved UI, external keyboard support, and more!

  The portability and capabilities of the iPad have made it an essential device in the business world. With this in mind, we had launched an exclusive Zoho Sheet app for iPad, with device-specific improvements and enhanced usability. Now, we're improving

• Updated font library: New font styles and custom font options in Zoho Sheet

  Zoho Sheet's font library now supports 500+ font styles in 60+ languages! The updated font library is stacked with new font styles, and some of the previously available font styles have been replaced with equivalent options. There are two ways you can

• The new Zoho Sheet for Android: Seamless UI and advanced features

  At Zoho Sheet, we know mobile apps have become the go-to platforms for creating, sharing, and storing information. And we understand the importance of an efficient and seamless app experience. We've been working hard on improving the overall user experience

• Zia in Zoho Sheet now makes suggestions on conditional formats, picklists, and checkboxes

  Zia, Zoho's popular AI assistant, has been helping users succeed across Zoho applications since inception. In Zoho Sheet, Zia helps users efficiently build reports and analyze data with recommendations about data cleaning, charts, and pivot table. Also,

• Introducing Data Bars: Graphically represent changes in data within the cells

  Conditional formatting has helped millions of spreadsheet users analyze and highlight their data more efficiently. In addition to the classic rules, color scales, and icon sets available in Zoho Sheet, you can now apply Data Bars, a convenient method

• VBA attached to button no longer works on external shared sheet

  Hi - we have a Sheet that our clients use, which requires them to press a button once they've entered data. The button then triggers a flow via a webhook. The button works fine when editing within Zoho Sheet - however when shared externally it no longer

• can I use zoho sheet for survey?

  Hi I wanna use zoho sheet for my ARY to know consumer better so i wanna have permission to do so

• How to Avoid Impacting Other Users When Hiding Columns in Zoho Sheet

  Hi Team, We’re experiencing a challenge with the column-hiding feature on Zoho Sheet during collaborative sessions. When one user hides a column, it becomes hidden for all users working on the file, which disrupts others' workflows. In comparison, Excel

• Tip #19 - Create checkbox tracker in your spreadsheet

  Hello Sheet users! We are here with yet another tip to help you get the most out of Zoho Sheet. Spreadsheets can be used to handle a variety of tasks, but ever tried using checkboxes to track the progress of your action items dynamically? Here's a sample

• New features released: Data from Picture for Web, Pattern Fill, and Translation in Zoho Sheet!

  Hello Sheet users, In 2024, the Zoho Sheet team focused on research and development to bring new features that add to functionalities like productivity, data management, collaboration, and more. This year, we're all set to roll them out incrementally

• What are the benefits of procurement software in a growing business setup?

  I’ve been exploring tools that can help automate purchasing and vendor-related tasks. I keep hearing about the benefits of procurement software, especially for businesses that are scaling. I want to understand how it helps in streamlining operations,

• Tip #20 - Three things you probably didn't know you can do with picklists

  Hello Zoho Sheet users! We’re back with another quick tip to help you make your spreadsheets smarter. Picklists are a great tool to maintain consistency in your spreadsheet. Manually entering data is time-consuming and often leaves typos and irregular

• Object required error

  Hi, I am getting an 'Object required' error on the line Call HideColumnsOutsideRange(ws, startOfWeek, endOfWeek) when I run the ShowCurrentWeek macro but not when I run the ShowCurrentMonth macro. Any ideas? Regards, GW Option Explicit Sub HideColumnsOutsideRange(ws

• CUSTOM FUNCTION GIVE ERROR #EVAL!

  CUSTEM FUNCTION CREATE KYA ZOHOSHEET ME US FUNCTION KO USE KIYA LEKIN DATA TO SAHI HAI LAKIN DATA SHEET ME NAHI LAG LAHA HAI KRUPYA SOLVE KARE MY CODE IS float ADDTWO_TWO(float NO1, float NO2) { ADD = NO1 + NO2; return ADD; }

• Next Page