Zoho CRM Digest - April 2024

Zoho CRM Digest - April 2024



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!


    • 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

    • 5名限定 課題解決型ワークショップイベント Zoho ワークアウト開催のお知らせ(8/21)

      ユーザーの皆さま、こんにちは。Zoho ユーザーコミュニティチームの藤澤です。 8月開催のZoho ワークアウトについてお知らせします。 今回はZoomにてオンライン開催します。 ▷▷参加登録はこちら:https://us02web.zoom.us/meeting/register/eVOEnBsSQ2uvX4WN5Z5DeQ ━━━━━━━━━━━━━━━━━━━━━━━━ Zoho ワークアウトとは? Zoho ユーザー同士で交流しながら、サービスに関する疑問や不明点の解消を目的とした「Zoho
    • New in Zoho Forms: Inline OTP Verification

      Hello form builders, We are excited to announce the launch of Inline OTP Verification in Zoho Forms, a smarter way to ensure the authenticity of the contact details you collect. Until now, OTP Verification in Zoho Forms worked as a pre-access step: respondents
    • Zoho Mail : Associate emails with Meeting records and allow multiple emails to be assocaited at once

      Is there a workaround that would allow either of these? I want to associate emails with Meeting records. I also would like to be able to select multiple emails at once for association with a record.
    • Create task from email

      Is there a way on mobile to create a task from an email? I use this feature a lot and when traveling now I read email on mobile. By the time I get to my office I forget about them since I didn't add it to a task. Is this feature missing on moble?
    • Zoho Socials - Unable to view Channels and SmartQ

      Hi, The channel Facebook has been added by the admin, however, it is not visible on the User level (employee). Other channels are visible. Also, we have the premium account, and SmartQ is not working. Can anyone help? Regards, Priyanka
    • Eliminating Manual Consolidation: Automating Currency Field Sync from Task to Project

      Hello Everyone, A Custom function is a user-written set of code to achieve a specific requirement. Set the required conditions needed as when to trigger using the Workflow rules (be it Tasks / Project) and associate the custom function to it. Requirement:
    • We want to set the "Converted from Lead" value in Deals using a Workflow or via a Deluge script. How?

      For use in Zoho Analytics, we need the field "Converted from Lead" filled in our deal records. This field is empty everywhere, because we do not create deals directly when converting a lead to a contact. We want to do that using the API or a workflow
    • Sales Orders: Quoted_Items + items in another subform -> into Ordered_Items ?

      hello, When creating Sales Orders, is it posible to inherit/fill the Ordered_Items with all the items from Quoted_Items + all the items from a customized subform with similar fields? Since you can create a sales order in different ways (convert, new -
    • How to cancel the GSTR1 pushed to GSTN

      How to cancel the GSTR1 Pushed to GSTN, some rectifications to be done in HSN & SAC code
    • Zoho Books API — Invalid Operation Type / Scope does not exist

      Hello Team, We are unable to use the Zoho Books API from our registered application. We’ve already: Created a client in Zoho API Console using (Admin in Books) Generated the OAuth code and token successfully Used the correct scopes: ZohoBooks.fullaccess,ZohoOauth.userinfo.READ
    • Minimum order quantity

      Is there a way to enforce a minimum order quantity - ie has to have a minimum of 250?
    • 【Zoho CRM】ポータル機能のアップデート:UIとポータルの作成フローの変更

      ユーザーの皆さま、こんにちは。コミュニティチームの藤澤です。 今回は「Zoho CRM アップデート情報」の中から、ポータル機能のアップデートをご紹介します。 目次 概要 ユーザーグループの作成フローの変更 ユーザーグループ詳細画面内のタブについて 「タブと権限」タブについて 「設定」タブについて 概要 UIとポータルの作成フローが変更されました。ポータルの新機能に先立ち、UIを一部変更しました。タブやオプションの配置を見直し、機能へよりアクセスしやすくなっています。 また、「ポータルユーザーの種類」は今後、「ユーザーグループ」と呼称され、ページ上のボタンも「ユーザーグループを作成する」に変更されます。
    • Tax on Imported goods charged by Shipping Company

      Hi Folks, I imported goods from outside Canada, for better understanding I will give an example data. imported goods value: 2000$ The shipping company sent me an invoice containing the following information: Custom duty on imported goods: 400$ Administration
    • Zoho Webinar via Social Media

      Hello, is it possible to stream a Zoho Webinar via Social Media like Linkedin or Facebook?
    • OAUTH2 isn't working with Power Automate and N8N (Zoho Desk)

      Hello, I am trying to set up an OAuth2 connection to the Zoho Desk API, but the authentication flow fails immediately. I am experiencing this issue in two separate platforms: Microsoft Power Automate (using a Custom Connector) and n8n. Instead of being
    • Kit Items Breaking Automations - "Provide mapped components for all kit items"

      This has been brought up in other threads, but I believe this issue warrants its own topic. Whenever a sales document (Estimate, Sales Order, Invoice) is created or manipulated programmatically, trying to include a Kit as an Item throws this error: "Provide
    • Show item Cost value on Item screen

      The Item screen shows Accounting Stock and Physical Stock. It would be very helpful if value information could be displayed here as well, for instance Cost Price. Currently, to find the Cost Price (as used for inventory valuations) from inside the item
    • Mark shipment as delivered via api

      Hellloooo again Zoho guys !! More help required if you would be so kind, pleeeezz..... var options =        {         'method' : 'post',         'contentType' : 'application/json',         'muteHttpExceptions' : true       }; var myPackNo  = encodeURIComponent('###################');
    • Setting Alternative units for an item.

      Hello Team, How to create alternate units for an item. We are placing orders for stocks in boxes. One box contain 24 items. At the time of selling we have two categories of buyers wholesalers and retailers. So the sales will be in PCS and in boxes also.
    • Zoho Inventory search when adding items to SO/PO, etc.

      I do not see that Zoho Inventory searches within the item name for an item lookup. We have many products with variants. So when I search for a product, say a lighting system, and it comes in different sizes and colors, I can only get those products where
    • Item Group Attributes

      Hello, I would like to see more attributes under grouped items. We sell car parts, there are several suppliers for the same part but under different brands. We want to group them together but the attributes under groups are lacking. For example, the products
    • Remove HTML Format - Deluge

      Hello @all if you want to delete the HTML format from the text please follow the script. Data = "Text"; info Data..replaceAll("<(.|\n)*?>" , "").replaceAll("&nbsp;" , " "); Apart from this if you require anything please let me know Thanks & Regards Piyush
    • Using multiple languages in template

      I wanted to add the company name in the template in arabic. I found a way through the header and footer option, except when i print the quotation the arabic disappears both in the top and bottom of the page. I have attached pictures of the before and
    • ADDING 5% VAT TO PURCHASE ORDERS GENERATED ON ZOHO BOOKS UAE

      Please guide on how to add 5% VAT to Purchase Orders generated on ZOHO Books UAE edition.
    • Import from /csv file, some items fail with the error "Specify Tax Or Tax Exemption".

      Hello! I am trying to import a csv file of all of my expenses for a complete financial year. I get errors for some items with the error message "Specifiy Tax or Tax Exemption". These errors only occur on lines where I have "Postage" as the expense account.
    • About maximum number of requests per minute

      Hi, Our company has integrated Zoho inventory and we're using the shipping order creation and update functions and so on. Currently we're receiving "For security reasons you have been blocked for some time as you have exceeded the maximum number of requests
    • Approval - Report/Views

      Hi, On Zoho Desk - Is there a way to report on pending approvals, or a view or similar?
    • "Zoho CRM Integration" option is missing in Zoho Social Settings

      I am trying to integrate my Zoho Social account with my Zoho CRM account. I am on the Professional Trial plan and my user role is "Brand Admin". However, I cannot find the "Zoho CRM Integration" or "Lead Generation" option anywhere in my Zoho Social settings.
    • Error 553

      Não estou conseguindo enviar ou receber e-mail, sempre dando o erro 553, sendo que há mais de um mês o domínio está pago e liberado. Preciso de um suporte urgente
    • Create PDFs with Text so that we can copy from a generated PDF

      Currently, any information that a user enters into a field cannot be highlighted and copied from the PDF that Zoho Sign renders. For example, if someone were to provide a phone number in a Zoho Sign text field, you would not be able to copy the phone
    • How To Insert Data into Zoho Table using Api

      Hi Community, I have created a table inside zoho tables. How do I insert data into table using API. Please tell the exact endpoint and payload , I just have to insert data into table columns. Also tell how to find tableid, viewid, baseid etc. which are
    • How do I delete a folder in Marketing Automation?

      Folders are used across contact lists and segments, and email templates. How do I delete a folder once it's been created?
    • Portal Approval Process

      Hi Zoho team and fellow users, I am seeking a method to establish a multi-step approval process between a Zoho user and a portal user (Custom Portal) to review and approve requests through the Custom Portal. For instance, within this setup, one of the
    • Narrative 8: Intelligent in-app support that's instantly available anytime and anywhere

      Behind the scenes of a successful ticketing system - BTS Series Narrative 8: Intelligent in-app support that's instantly available anytime and anywhere The App Support Across Platforms (ASAP) add-on for Zoho Desk is an independent application that integrates
    • Navigation issue — unable to return to Customer page after opening Receipt from Transactions

      Steps to reproduce: Open a Customer record. Go to Transactions tab and open a Receipt by clicking its receipt number. After viewing the receipt, clicking browser Back or closing the receipt does not reliably return me to the original Customer record (I
    • Thermal Printer Option Needed for Delivery Challan Templates

      Currently in Zoho Books, the Delivery Challan template only supports A4 and A5 page sizes. However, in many businesses (especially retail and hardware), we use thermal printers (like 3-inch or 4-inch rolls) to print delivery challans. It would be very
    • Separate Default Payment Modes for Receipts vs. Payments

      Right now, when I set a default Payment Mode via a customer invoice or Payments Received screen, that same mode shows up for vendor payments (Purchases → Payments Made). 🔹 Request: We need different default modes for: Customer receipts (e.g., default
    • Update/Change GSTIN in GST Settings of zohobooks

      We are trying to update our GSTIN under the GST settings section of our Zohobooks account Initially, we had entered a dummy GSTIN (123456789123456) to generate a sample invoice before obtaining our official GST registration. After receiving our actual
    • Link Payment Mode and Paid Through Accounts

      For most users, it's very difficult for them to understand that the Payment Mode is totally independent of the Paid Through account when paying bills. It seems (and is) redundant for them to have to select what is basically the same thing twice. The current
    • Lets enable business to choose the default payment mode

      Lets enable business to choose the default payment mode so that we do not have choose payment mode again and again for each and every transsctions
    • Next Page