Zoho CRM Community Digest - June 2024

Zoho CRM Community Digest - June 2024


The month's Zoho CRM Digest is packed with exciting updates, insightful discussions, and valuable tips from the community. From streamlining workflows with bulk imports and dynamic filters to tackling duplicate leads and managing emails with ease, we've got you covered. Dive in to discover!

Product Updates:

Ready, Set, Bulk Import Call Data in CRM:
Zoho CRM's new data import feature for the Calls module is a time-saver, allowing users to create or update multiple call records at once. The import process mirrors that of other modules, making it easy to use. For more details on this enhancement, refer to the announcement post. 


Enhanced duplicate check for Leads in Zoho CRM:
Zoho CRM has improved its duplicate checking for Leads by automatically comparing them with existing Contact records, preventing duplicate lead creation. Previously, only converted leads were checked for duplicates. Now, CRM users have more control! Select "Contacts" in the Duplicate  Check menu for Leads and choose a unique field (like email) for comparison. This ensures all contact records, including those added directly as Contacts, are thoroughly checked for duplicates during lead creation. Check this announcement to learn more about this exciting enhancement.

Zoho CRM's Dynamic Lookup Filters Are Here!: 
Zoho CRM is introducing dynamic filters for lookup fields! This exciting enhancement automatically filters lookup options based on the information you've already entered in the current road. This ensures you are only shown relevant choices, reducing information overload and the risk of data entry errors. This features is being released in a phased manner. Check out the post for more information. 

Zoho CRM Makes Multi-Select Picklists a Breeze:
The enhanced filtering option in Zoho CRM now enables users to select multi-select picklist value directly from a drop-down menu. This update also introduces new operators that enable filtering records based on whether they contain all, any, or none of the selected values from the multi-select picklist. Currently rolling out, this enhancement will be accessible across CRM sections like Custom Views, Reports, and more. Take a look at the announcement for detailed information. 

Introducing Component Filters in Zoho CRM Analytics Dashboard: 
Previously, users couldn't filter data within shared dashboard components based on specific criteria. The new component filters features now allows individuals users to apply their own filters to shared dashboard components, letting them view data according to their specific needs without altering the overall component setup. Users can configure up to two filters per component. Additionally, the "recently deleted" feature allows recovery of accidentally, deleted dashboard components from the last 30 days. For more details, see the announcement. 

Introducing Canvas Record Form in Zoho CRM: 
Previously, record creation pages were limited to standard layouts, but this is set to change with the introduction of Canvas Record Forms. The Canvas design studio enables a drag-and-drop interface for extensive layout customization, allowing users to streamline data entry, highlight key information, and use vibrant colors and fonts. This visually engaging user interface enhances the user experience and ensures brand consistency. Forms can be tailored for specific processes or roles, with the ability to create multiple custom forms per module to meet different needs. Manage all customs record forms, import templates, and configure settings in the "Form view tab".  Additionally, specific fields on the form can be highlighted to improve visibility. Interested in learning more? Check out the post! 

Bulk Additions and Subforms Permissions in Zoho CRM: 
Zoho CRM is introducing two major enhancements for subforms: bulk additions and subforms permissions. Users can now add multiple entries to a subform at one via a lookup window, significantly saving time. Additionally, administrators can now apply granular access control to subform, setting view, create, edit, and delete permssions based on user roles. This improves control over subform access beyond the record level. Discover more details in this post. 

CRM Email Templates Are Now Available in the Gmail Add-On! 
You can now access and use your CRM email templated directly within the Gmail add-on. For more details, check out @Ishwarya's comment in this post. 

Zoho CRM Dashboard: New Updates!
Dashboard creators and admins can now lock shared dashboards, restricting editing privileges for specific users and ensuring they remain in view-only mode. Additionally, the introduction of abbreviated number formats (K for thousands, M for millions, B for billions, etc.) and customisable decimal places helps with better comprehension of large numbers in dashboard components. The KPI components now display underlying record counts alongside metrics, offering context on factors such as whether a revenue increase is due to more deals or higher average deal sizes. For a comprehensive understanding, check the announcement, complete with screenshots. 

Zoho CRM's Latest Updates for Top Email Security and Deliverability!
Zoho CRM has rolled out several email compliance enhancements, including leveraging email sending domain authentication from Zoho products to streamline the process, boosting DMARC and adding a one-click unsubscribe option to your emails. Review these updates to ensure compliance and optimize email deliverability. For more details, refer to the announcement post. 

New Customizable Kanban Views - Stay Updated!
Heads up: The current system-defined Kanban view for Meetings, Calls, Tasks and Appointments will be discontinued after July 30th. The new enhancement will allow you to customize boards by selecting a picklist field, offering more flexible board configuration tailored to your business needs. Be sure to check out the post to stay updated!

Early Access:

Zoho CRM Search Makeover: Early Access Features
Zoho CRM is giving your searches a makeover. We have added a bunch of features to help you find what you need quickly. You can now target searches by modules, name, or tags and even see key info and take actions (like emailing contacts) directly from the results. Advanced search got an upgrade too, allowing you to filter by criteria and sort results based on recent activity. Additionally, Zia, Zoho's AI assistant, is now built right into search to find calculated data, reports, and more! Check out the post to learn more. 

Useful Discussions:  


Budget tracker: the Fix for Negative Display Issues!
@Damien was having trouble with a formula in their budget tracker. The formula was not displaying negative values correctly, showing them as positive instead. @Subhash Kumar identified the isssue provided the solution. Check out the post to find the answer.

Solved! Importing Leads with Historical Creation Dates in Zoho CRM: 
@Raantjes wanted to import leads with their original creation date/time into Zoho CRM. The standard "Import Leads" function didn't allow setting a custom creation date for imported leads. @Prashant Sharma initially recommended Data Migration, with Bala Ganesh providing further details and screenshots. Dive into this post to learn more. 

Notes across Contacts, Accounts, and Deals in a single Report: A workaround
@Marshall wanted to create a report in Zoho CRM that displayed all notes and the associated contact/account/deal information in a single view. The current report editor in Zoho CRM didn't allow including parent module information (account, contact, deal) alongside notes in a single report. @Hugh Marshall stepped in and offered a workaround!
By setting "Notes" as the base table and adding relevant parent modules as secondary tables, users can now generate reports that show both note content and associated entity. Check this post for a detailed explanation, complete with screenshots. 

Update Existing Accounts with Account Numbers (Without Duplicates!)
@Jennifer encountered issues when attempting to add manually assigned account numbers from a spreadsheet to existing accounts in Zoho CRM. Importing the spreadsheet with the account numbers column resulted in duplicate accounts instead of updating the existing ones. it's unclear if Jennifer was working with an auto-number field, but @Hugh Marshall provided clarification and a potential solution for both scenarios. Note the auto-numbers fields cannot be imported or changed directly. Check out the post for the solution. 

Functions:

Automate Field Population with Functions: 
@Tyler Christie wanted a way to automatically populate a field in Zoho CRM's Leads module based on the entered zip code. @Bhoomi Joshi provided a helpful solution with a code snippet. Given the multiple possibilities based on different Zip codes, @Bhoomi Joshi recommended grouping similar Zip codes in a list, which @Tyler Christie confirmed worked perfectly. Check out this post for the code. 

Finding Past Deals in Zoho CRM: 
@Andrew Lovatt wanted to find a way to filter deals based on a closing date that has already passed, without having fetch and iterate through all deals. @Bhoomi Joshi shared the code with the required criteria parameter. Take a look at the post for the code. 

Fetching User ID by Email: 
@Aravind Krishnan needed help dynamically fetching a user ID in Zoho CRM to assign tasks. Aravind has the user's email address and wanted to find the corresponding user ID. @Bhoomi Joshi and @Haiku Technical Support have shared their solutions depending on Aravind's specific needs. Explore their solution in this post. 

Solutions for Adding Options to Multi-Select Fields: 
@Juan Berrio wanted to automatically add new options to multi-select fields in a subform. @Hugh Marshall came to the rescue! He explained how to use the Metadata API within a Deluge function to add new options programatically. Check out this post for the working code. 

Dev's Corner: 

This month's Dev's Corner features three detailed posts by community members, who went above and beyond to share comprehensive code, steps and screenshots. Thank you @Vigneshwaran, @Kevin Flynn and @Rodger Brehaut. 

Rich Text Notes in Zoho CRM: 
@Vigneshwaran, along with his team, has devised a clever workaround by developing a custom widget that serves as a Rich Text solution. This widget allows users to format text, embed images, and enhance their notes directly within the CRM platform. Take a look at this detailed post, which includes codes and screenshots. 

Script to Simplify Adding Product Bundles to Quotes: 
Kudos to Kevin Flynn for a detailed post featuring Client Script code that streamlines the process of adding product packages to quotes. Kevin created a custom module to list "Package Items", where users can define product bundles with details like included products, discounts, and start/end dates. These packages are then linked to the Quotes module through a lookup field. Read the post to learn more. 

Automate File Management with Deluge Script: 
@Rodger's script automates file attachement in CRM records when a new file is added to a designated Workdrive folder. Rodger provides detailed instructions and encourages users to experiment and adapt the script to their specific needs. Take a deep dive in to the post for a comprehensive overview, complete with code and screenshots. 

Kaizen: 

(Kaizen #139) Using Functions in Client Script and Handling Timeouts: 
This post addresses a common challenges faced by users working with Client Scripts" how to call functions within those scripts and handle potential timeouts that might prevent them from running as expected. Learn more from this post on how to tackle these issues effectively. 

(Kaizen #140) Integrating Blog feed scraping service into Zoho CRM Dashboard:
This post covers how to create a Zoho CRM dashboard widget that display the most recent blog posts from your favourite products or services. Take a look at the post to learn more.

(Kaizen #141) Zoho CRM's API Collection in Postman:  
This post introduces a valuable resource for anyone looking to interact with Zoho CRM's data using Postman. It provides an overview of Postman and its role in working with APIs, and guides developers on how to utilize a pre-built collection of API calls specific to Zoho CRM within Postman. Check out the post to learn more. 

(Kaizen #142) How to Navigate to Another Page in Zoho CRM using Client Script
This post discusses how client-side ZDKs can simplify navigation within a software application. It covers the limitations of traditional navigation methods, introduce ZDK functions such as "navigateTo()" and "navigation_data" for ZDK-based navigation, not provided a use case with a solution and summary. Read the post for more details. 

(Kaizen #143) Assigning values to different field types using Zoho CRM SDKs - Part I
This post is a part of a series on Zoho CRM discussing how to assign values to different types of data fields when using Zoho CRM's software development kits (SDKs) across various programming languages. By understanding how to handle different data types, you can effectively use the provided sample code and customize it for your specific needs within Zoho CRM. Check out the post to learn more.

(Kaizen 144) Assigning values to a different field types using Zoho CRM SDKs - Part II
This post builds on the previous one, which covered assigning values to a different field types using the Java SDK. This instalment focuses on achieving the same functionality with the PHP SDK, while emphasising the importance of reviewing the first part for a complete understanding. Dive in this post to learn more.

Thank you 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 next month's digest. Have a wonderful month ahead!

    Access your files securely from anywhere







                            Zoho Developer Community





                                                  Use cases

                                                  Make the most of Zoho Desk with the use cases.

                                                   
                                                    

                                                  eBooks

                                                  Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho Desk.

                                                   
                                                    

                                                  Videos

                                                  Watch comprehensive videos on features and other important topics that will help you master Zoho Desk.

                                                   
                                                    

                                                  Webinar

                                                  Sign up for our webinars and learn the Zoho Desk basics, from customization to automation and more

                                                   
                                                    
                                                  • Desk Community Learning Series


                                                  • Meetups


                                                  • Ask the Experts


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner






                                                            Manage your brands on social media



                                                                  Zoho TeamInbox Resources



                                                                      Zoho CRM Plus Resources

                                                                        Zoho Books Resources


                                                                          Zoho Subscriptions Resources

                                                                            Zoho Projects Resources


                                                                              Zoho Sprints Resources


                                                                                Qntrl Resources


                                                                                  Zoho Creator Resources



                                                                                      Zoho CRM Resources

                                                                                      • CRM Community Learning Series

                                                                                        CRM Community Learning Series


                                                                                      • Kaizen

                                                                                        Kaizen

                                                                                      • Functions

                                                                                        Functions

                                                                                      • Meetups

                                                                                        Meetups

                                                                                      • Kbase

                                                                                        Kbase

                                                                                      • Resources

                                                                                        Resources

                                                                                      • Digest

                                                                                        Digest

                                                                                      • CRM Marketplace

                                                                                        CRM Marketplace

                                                                                      • MVP Corner

                                                                                        MVP Corner







                                                                                          Design. Discuss. Deliver.

                                                                                          Create visually engaging stories with Zoho Show.

                                                                                          Get Started Now


                                                                                            Zoho Show Resources


                                                                                              Zoho Writer Writer

                                                                                              Get Started. Write Away!

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

                                                                                                Zoho CRM コンテンツ






                                                                                                  Nederlandse Hulpbronnen


                                                                                                      ご検討中の方




                                                                                                            • Recent Topics

                                                                                                            • Automatic Matching from Bank Statements / Feeds

                                                                                                              Is it possible to have transactions from a feed or bank statement automatically match when certain criteria are met? My use case, which is pretty broadly applicable, is e-commerce transactions for merchant services accounts (clearing accounts). In these
                                                                                                            • Has Anyone successfully integrated Zoho and Sage Intact?

                                                                                                              Hey all, We’re evaluating Zoho One + Sage Intacct and I’m trying to connect with anyone who has actually implemented the two together.Specifically, I’d love to know: -- Which functions you kept in Zoho vs. Intacct (e.g., Product Catalog, AR/AP, invoicing,
                                                                                                            • Store "Sign in with Google/Microsoft/GitHub etc." details

                                                                                                              Quite often now, users are using a sign-in provider like Google or Microsoft to sign into various apps and services. It would be great if Vault could remember which providers you use for each website and sign you in with that provider instead of a username
                                                                                                            • Placing a condition before converting the LEAD

                                                                                                              Hi,  I need some assistance with Lead conversion. I need to place certain conditions before allowing the user to convert the lead.  For example: up until the certain status's doesn't equal "green" don't allow to convert lead.  I tried creating this using
                                                                                                            • Subform edits don't appear in parent record timeline?

                                                                                                              Is it possible to have subform edits (like add row/delete row) appear in the Timeline for parent records? A user can edit a record, only edit the subform, and it doesn't appear in the timeline. Is there a workaround or way that we can show when a user
                                                                                                            • Unable to retrieve Contact_Name field contents using Web API in javascript function

                                                                                                              Hello, I've added a field in the Purchase Order form to select and associate a Sales Order (Orden_de_venta, lookup field). I've also created a client script to complete some fields from the Sales Order (and the Quote), when the user specifies the related
                                                                                                            • 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.
                                                                                                            • Adding image in HTML report page

                                                                                                              Hi, I want to know two things: 1. Can anyone advise how to add an image in HTML report. The tagged used is <img> but what path do I mention for the image to be added in the HTML report. 2. Also, I want to know if I am creating an application for the market
                                                                                                            • How to change view of HTML report based on device but always print in A4

                                                                                                              Hello everyone, I am aware that HTML report view can be configured to adjust according to the screen size like Laptop, Tablet and mobile using media queries. But my concern is no matter on which device the reports is opened when printed should always
                                                                                                            • Age Calculation

                                                                                                              I've attempted to calculate the age of someone based on their birthday input by using the formula field. It works but I don't want all those decimals on there. I then tried to use "set variable" after birthday input but I get a field type mismatch, long vs. floating. Any ideas would be wonderful.
                                                                                                            • Search on Custom Field

                                                                                                              We're working on an integration with the Zoho FSM API and are trying to retrieve companies based on a custom field we added to the Companies module. However, we can't find a way to filter or query records using custom fields through the API. We have a
                                                                                                            • in zoho creator Sales Returns form has sub form Line Items return quantity when i upate the or enter any values in the sub form that want to reflect in the Sales Order form item deail sub form field Q

                                                                                                              in zoho creator Sales Returns form has sub form Line Items return quantity when i upate the or enter any values in the sub form that want to reflect in the Sales Order form item deail sub form field Quantity Returned\ pls check the recording fetch_salesorder
                                                                                                            • Sendmail function / custom action?

                                                                                                              I've setup a function hoping to email various business departments the details of a record once all work in that record is complete so gone about setting up a custom action in such way that each record line on the report has a button to click. Question is how do I actually include data from that record in the email that is sent when the button is clicked? I had thought that since this were being sent per record the email would include the data which had been entered
                                                                                                            • API to post drafts for social media

                                                                                                              I we want to post draft posts to our zoho social account and then approve and schedule them within Zoho social. is this possible with for example: https://apis.zoho.com/social/v2/post TIA Jon
                                                                                                            • 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
                                                                                                            • Is there an API to "File a Ticket" in Desk

                                                                                                              Hi, Is there an API to "File a Ticket" in Desk to zoho projects?
                                                                                                            • Unarchive tickets

                                                                                                              How can I manually unarchive tickets?
                                                                                                            • Canvas View in Zoho Recruit

                                                                                                              Is it possible or would it be possible to have the new 'Canvas View' in Zoho Recruit?
                                                                                                            • What impactful sales coaching techniques have you used to boost your team's performance?

                                                                                                              I'm curious about the real-world impact of sales coaching on team performance. What specific techniques or strategies have you found most effective in driving consistent improvement and growth in your sales team? Any success stories or lessons learned
                                                                                                            • Adding Taxes to paid consultations in Zoho Bookings

                                                                                                              I created a 'paid' consultation under Zoho Booking and integrated it with payment gateways for online/instant payment before a booking is done. How can I add 'taxes' to the price of consultation? I can add taxes to other Zoho apps (liks Books, Checkout,
                                                                                                            • Zoho Finance Suite - Customer Custom Tabs - Dynamic Link

                                                                                                              Hi Finance Suite team, When creating a Custom Tab for a Client Portal, there is no option to add dynamic parameters. This would be very helpful for adding Zoho Analytics dashboards which can be dynamically filtered through the URL to only show information
                                                                                                            • Optimize your Knowledge Base for enhanced accessibility by adding alt tags for images

                                                                                                              Let's learn why alt tags are crucial for your articles. You can add alternative tags (alt tags) and alternative text (alt text) to the images you share on your community forums or when embedding them in articles. Alt tags refer to the HTML attribute,
                                                                                                            • Feature Request - Insert URL Links in Folders

                                                                                                              I would love to see the ability to create simple URL links with titles in WorkDrive. or perhaps a WorkDrive extension to allow it. Example use case: A team is working on a project and there is project folder in WordDrive. The team uses LucidChart to create
                                                                                                            • Formula field with IF statement based on picklist field and string output to copy/paste in multi-line field via function

                                                                                                              Hello there, I am working on a formula field based on a 3-item picklist field (i.e. *empty value*, 'Progress payment', 'Letter of credit'). Depending on the picked item, the formula field shall give a specific multi-line string (say 'XXX' in case of 'Progress
                                                                                                            • FSM trying again

                                                                                                              have not linked FSM yet to the rest of out Zoho suit. It certainly looks like the apointment and service part is more manageable for our staff. The question is that our engineers multi task examples 1. deliver products to customers not fitted 2. Service
                                                                                                            • Possible to bold or indent text in the description field?

                                                                                                              As part of one item, I often have a detailed description that would be much easier to read if there was the ability to have a bulleted list or bold text and the like. Is this possible? My last invoicing software allowed markup in the field so, for example, an asterisk meant a bullet. I haven't been able to find any documentation related to this.  Any information would be appreciated. Thank you.
                                                                                                            • How can I setup Zoho MCP with Chat GPT

                                                                                                              I can set up custom connections with Chat GPT but I cat an error when I try to set it up. The error is: "This MCP server can't be used by ChatGPT to search information because it doesn't implement our specification: search action not found" Thoughts?
                                                                                                            • Formatting of Balance Sheet and Profit & Loss Reports

                                                                                                              The default format of the Balance Sheet and P&L Reports are based on the Account Types and then the individual accounts within the Chart of Accounts. These are then ordered alphabetically under these sub-headings and one is unable to re-order these or
                                                                                                            • UK MTD reports concerning turnover and cerash accounting

                                                                                                              Hi I am a sole trader, and I have just started with Zoho Books in order to comply with the new HMRC requirements. I use 'cash basis' - which I understand to mean that income is when the cash comes in (not the invoice date) and expenses are when they are
                                                                                                            • Retainer Invoice.

                                                                                                              Why ZOHO not have facilities to deduct partially advance payment from an invoice.
                                                                                                            • Collaborate Feature doesn't work

                                                                                                              Hello Team. It seems that the collaborate section is broken? I can post something but it all appears in "Discussions". In there is no way how I would mark something as Draft, Approval, post or any of the other filter categories? Also if I draft a post
                                                                                                            • IMAP Server not responding.

                                                                                                              Trying to connect a phone via IMAP and getting "imap.zoho.com not responding." Is the server down, for maintenance or otherwise? I've tried this on two different devices and got the same error on both.
                                                                                                            • Vendor Signatures Needed for Purchase Orders

                                                                                                              Hello everyone, We have a unique requirement that necessitates that Vendors & Suppliers formally acknowledge our Purchase Orders upon receipt. I was hoping that there would be an option to do so in Zoho Books, but that does not appear to be the case.
                                                                                                            • Share saved filters between others

                                                                                                              Hi, I am in charge to setup all zoho system in our company. I am preparing saved filters for everybody, but the only one can see its me. How can others see it? Thanks
                                                                                                            • report showing assignment type

                                                                                                              Hi, We've created a number of workflows to allow us to auto assign tickets to agents based on keywords and other criteria. I'm struggling to create a report that would show me what is the percentage of tickets that are assigned automatically via workflows
                                                                                                            • GST Slabs Redefined: Stay Compliant Using Zoho Books!

                                                                                                              Hello Everyone! The Government of India is rolling out new GST rates, a major reform aimed at simplifying the current tax structure starting 22 September 2025. GST will move from four slabs (5%, 12%, 18%, 28%) to two main slabs (5% and 18%), plus a special
                                                                                                            • Kanban view on Zoho CRM mobile app!

                                                                                                              What is Kanban? The name doesn't sound English, right? Yes, Kanban is a Japanese word which means 'Card you can see'. As per the meaning, Kanban in CRM is a type of list view in which the records will be displayed in cards and categorized under the given
                                                                                                            • Presenting ABM for Zoho CRM: Expand and retain your customers with precision

                                                                                                              Picture this scenario: You're a growing SaaS company ready to launch a powerful business suite, and are looking to gain traction and momentum. But as a business with a tight budget, you know acquiring new customers is slow, expensive, and often delivers
                                                                                                            • No practical examples of how survey data is analyzed

                                                                                                              There are no examples of analysis with analytics of zoho survey data. Only survey meta data is analyzed, such as number of completes, not actual analysis of responses, such as the % in each gender, cross-tabulations of survey responses. One strange characteristic of Zoho analytics is that does not seem aware of how Zoho Survey codes 'multiple response' questions. These are questions where more than one option can be selected from a list. Zoho Survey stores this data as text, separated by commas within
                                                                                                            • Zoho Creator as LMS and Membership Solution

                                                                                                              My client is interested in using Zoho One apps to deploy their membership academy offer. Zoho Creator was an option that came up in my research: Here are the components of the program/offer: 1. Membership portal - individual login credentials for each
                                                                                                            • Next Page