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




                                    Zoho Desk Resources

                                    • Desk Community Learning Series


                                    • Digest


                                    • Functions


                                    • Meetups


                                    • Kbase


                                    • Resources


                                    • Glossary


                                    • Desk Marketplace


                                    • MVP Corner


                                    • Word of the Day



                                        Zoho Marketing Automation


                                                Manage your brands on social media



                                                      Zoho TeamInbox Resources

                                                        Zoho DataPrep Resources



                                                          Zoho CRM Plus Resources

                                                            Zoho Books Resources


                                                              Zoho Subscriptions Resources

                                                                Zoho Projects Resources


                                                                  Zoho Sprints Resources


                                                                    Qntrl Resources


                                                                      Zoho Creator Resources



                                                                          Zoho Campaigns 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

                                                                                                  • CLIENT PORTAL (If clients can place orders directly on the portal)

                                                                                                    Zoho client portal is excellent. Everything is there except one thing. Client should be able to place orders directly on the portal. This would enhance the portal and end users will be extremely happy. This suggestion infact came from one of our client.
                                                                                                  • Portal Default View

                                                                                                    Hello! My company is about roll out portals for some users, but we were wondering if it was possible to set the Record Detail Page View to default to a custom view that we made. That way the information they need would be streamlined and easier to see.
                                                                                                  • Macro Email to be determined by a ticket field

                                                                                                    Hi, we are a commercial energy brokerage and are implementing Desk as our helpdesk tool to replace manual emails, personal whataspp and telephone. We have setup a macro rule when we can trigger an email, update ticket status and trigger a task.... but
                                                                                                  • Welcome Link Expired

                                                                                                    Hi The links sent to the users didn't get clicked on in time and now all the links have expired. Is there a way to send a new link without deleting them and re-adding them>
                                                                                                  • Zoho expense linked with Campaign instead of customers

                                                                                                    Hi, Is there a development planned for linked an expense or a report to a zoho campaign? Indeed, suppose I created a campain in which I add different clients (for example a trip to a foreign country where I meet 3 different clients), I would like this campaign to be linked to the expenses I have. Say I have a plane ticket, taxis and 1 hotel night, I would like those expenses to be linked to the 3 clients. With Zoho expense, it is not possible at the time (or maybe it is but I do not know how!). thanks
                                                                                                  • 🎄 Jingle, Mingle, and Automate: Spread Christmas Cheer with Zoho Desk Auto-Replies! 🎄

                                                                                                    Hello Everyone! Welcome to this week's episode of the Community Learning Series. Christmas is in the air, and I’m sure we can all feel the jingle and the mingle of the season! The folks at Zylker Techfix are no exception—they’re busy with holiday plans
                                                                                                  • Adjusting Physical Inventory

                                                                                                    Not getting very far with support on this one, they say they are going to fix it but nothings happened since November. Please give this a thumbs up if you would like to see this feature or comment if you have some insight. Use Case: Inventory set to be
                                                                                                  • Print PO receipt

                                                                                                    Hi I would like to print the PO receipt. There does not seem to be any way to do this. I track batch numbers and printing the PO does not show this. Only the receipt would show the details of the receipt. Currently I print the screen which does not have
                                                                                                  • Create a purchase order in vendor's currency

                                                                                                    I am having a problem working this out and would appreciate some suggestions. We have Books and Inventory working in tandem. We are in Australia, our product is sold in Australia in $A and obviously all our invoices, accounts and reports need to be in
                                                                                                  • Work Orders / Bundle Requests

                                                                                                    Zoho Inventory needs a work order / bundle request system. This record would be analogous to a purchase order in the purchasing workflow or a sales order in the sales cycle. It would be non-journaling, but it would reserve the appropriate inventory of
                                                                                                  • Getting error during inserting a record in form of zoho people using zoho api

                                                                                                    import requests import json # Set your access token and Zoho People API base URL access_token = '1000.XXXXXXXXXXXXXXX.XXXXXXXXXXXXXXXXXXXXX' api_base_url = 'https://people.zoho.in/people/api/' # Set the form name and data to be inserted form_link_name
                                                                                                  • This domain is not allowed to add. Please contact support-as@zohocorp.com for further details

                                                                                                    I am trying to setup the free version of Zoho Mail. When I tried to add my domain, theselfreunion.com I got the error message that is the subject of this Topic. I've read your other community forum topics, and this is NOT a free domain. So what is the
                                                                                                  • Change script to add fields

                                                                                                    Hi, I have a custom function (writen by a different implementation company in the beginning) which I would like to edit to add a different field as well. Can't get it to work on my own though. - The script now adds the address fields to a new quote (needs
                                                                                                  • 1 API to all channel

                                                                                                    hi zoho team: I am the product manager of anywheel, we are planning to integrate zoho, we want to integrate multiple channels through 1 API, please can you send me the integration document and guideline?
                                                                                                  • Revamped Print in Zoho Sheet—customized for paper

                                                                                                    The latest enhancements to Zoho Sheet's Print settings allows you to print a worksheet or a selected range, with customizations that make the data comprehensible, even on paper.   Customize header and footer Make your spreadsheets meaningful with a relevant header and footer. You can now choose to display the file name, sheet name, current page number, total pages, date, and time as the header and footer in your print view. Besides the predefined elements, you can also give a custom text for header/footer.
                                                                                                  • Adding Bluesky channel

                                                                                                    Hello, Is Bluesky (AT protocol) soon added on Social ? Bluesky is being developped and is now open to anyone (no more invitation) Thank you
                                                                                                  • How Can i put a form in Zobot

                                                                                                    Hi,how can i integrate a form which has a multiple options to choose from.the form should be opened or displayed by zobot after it meets a requirement in the conversation. Thanks in advance !
                                                                                                  • Unified customer portal login

                                                                                                    As I'm a Zoho One subscriber I can provide my customers with portal access to many of the Zoho apps. However, the customer must have a separate login for each app, which may be difficult for them to manage and frustrating as all they understand is that
                                                                                                  • message on click of button

                                                                                                    Hi, i added insert task on 'Quick view' below  'Action'  of report just below 'Delete' button,  so i am trying to add a message on click of button that, "This item is now added into Pending Request" like this .... So, how can i achieve this ; because
                                                                                                  • Is it possible to disable Chat Waiting Time, or to make it indefinite?

                                                                                                    We have used many online chat services over the years. However, Zoho's SalesIQ appears to be the only one we've tried that has a mandatory time limit where we must respond to new customer queries. We are a small business so we have no dedicated staff
                                                                                                  • Is Drawing feature supported in zoho Sheets?

                                                                                                    Is there any option to draw arrows and some basic shapes such as circle , rectangle etc in zoho sheets? if so, can someone help me find it 
                                                                                                  • Access CRM Variables from Formula field

                                                                                                    Is it possible to use a CRM variable (defined in Developer Space -> CRM Variables) in a formula field for calculations ?
                                                                                                  • Client Script: $Client.refresh({ triggerOnLoad: true }); not triggering onLoad Client Scripts

                                                                                                    Hey friends! I'm trying to store a temporary var, refresh the page for the user, then check that temporary var and do some actions. Theoretically using the title's code: $Client.refresh({ triggerOnLoad: true }); should refresh the page and trigger on
                                                                                                  • Super Admin login to delete certain folders and passwords and clearing the trash folder, they are still appearing on my dashboard

                                                                                                    Hi Zoho Team, I need help with an issue I've encountered. Despite using the Super Admin login to delete certain folders and passwords and clearing the trash folder, they are still appearing on my dashboard. I would like to understand why this is happening
                                                                                                  • Pulling Specific Products from Sales Orders in Books to a CRM Record

                                                                                                    We currently process orders directly through our website (woocommerce) as well as through manual sales orders in zoho books. When an order comes through the website, all of the individual products from that order show up in the CRM record of that customer.
                                                                                                  • Automatically add a retainer to every estimate

                                                                                                    Hi all, I've been trying to find a way to automatically add a retainer at a set % to every estimate we create and send. So far I haven't been successful, does anyone know of a way to do this? Thanks,
                                                                                                  • Clear String field based on the value of other field

                                                                                                    Hello everyone, We would like to be able to clear a string field (delete whatever has been written and make it empty) when another field (picklist) is changed to a specific value. While I can empty other types of fields, I noticed that I can't do this
                                                                                                  • Custom Deal Name in Lead Conversion Mapping

                                                                                                    I know there are ways to change the name of a Deal after conversion using a custom function, so no need to repost that information. I would like to see the CRM Improved with Deal Name Customisation and I think the Lead Conversion Mapping page would be
                                                                                                  • Within the Basic KPI component in Analytics, it is impossible to set "next" day range as a filter

                                                                                                    Hi there, I am currently setting up a deal dashboard for the Sales team. While it is possible to filter deal records to show records that were created LAST X days only, it looks like a NEXT X days Closing date filter is not available. Would it be possible
                                                                                                  • Invoice status on write-off is "Paid" - how do I change this to "Written off"

                                                                                                    HI guys, I want to write off a couple of outstanding invoices, but when I do this, the status of the invoices shows as "Paid". Clearly this is not the case and I need to be able to see that they are written off in the customer's history. Is there a way
                                                                                                  • For each loop with available time slots

                                                                                                    I am very new to Deluge, and this question was unable to be answered by Zoho Creator tech support upon request. Task at hand: I have a Form with 4 fields: - Date Start - Date End - Dropdown: Time Start: contains time slots (12:00PM, 12:15PM, etc) - Dropdown:
                                                                                                  • Can we have Backorder Management ?

                                                                                                    Can we have Backorder Management ?
                                                                                                  • Converting Amazon Sales Order to Invoice

                                                                                                    Hi there, We need  advice on the Amazon integration with Zoho Inventory. Now, we want to convert all the Sales orders synced from Amazon to Invoices. We want also to include and record the Amazon fees associated with the sales (Amazon fees, FBA fees, Cost of Advertising etc.) However, Sales order only captures the sales proceeds (Gross Sales) in Zoho Inventory. Does anyone currently work with Amazon and can suggest how to correctly process the sales and Amazon payments through Zoho Inventory and
                                                                                                  • Zoho Inventory | Can't uncheck/turn off Advance Tracking

                                                                                                    Hi, I wanted to know if there's a way to turn off Advanced Tracking (such as Serial Number or Batch Tracking) for an item in Zoho Inventory. I’ve read that you might need to delete associated transactions and clear the opening stock to disable these features.
                                                                                                  • Landed Cost application to Vendor Bills from dropship Purchase Orders

                                                                                                    When trying to apply a Landed Cost to a Vendor Bill generated from a dropship Purchase Order, the Landed Cost pop-up window generates a message that "Landed Cost cannot be applied to Bills from dropship Purchase Orders" when trying to save the landed
                                                                                                  • Condition-based data sharing rules are now available in CRM

                                                                                                    Dear All,   We are excited to introduce a much awaited feature: condition-based data sharing rules. We'd love to explain more about this enhancement.   Specify record conditions in data sharing rules Data sharing rules enable you to share all the CRM
                                                                                                  • 2 serial numbers for 1 item (Mac address and Serial number)

                                                                                                    There is a way to track 2 serial number type for 1 Item. Ex: Some electronic devices have a MAC address and a serial number. I need to track those 2 numbers
                                                                                                  • Zoho Projects Roadshow, USA - 2024

                                                                                                    Dear Users, We are happy to announce the Zoho Projects Roadshows 2024 in USA. This is an excellent opportunity to learn more about Zoho Projects and gain in-depth knowledge of the advanced features. Our team will also discuss industry specific solutions
                                                                                                  • [Zoho Writer Webinar] Tips on collaboration control in Writer

                                                                                                    Hi Zoho Writer users, We're excited to announce the Zoho Writer webinar for the month of October 2023: Tips on collaboration control in Writer. This webinar will help you understand the various features available in Writer to control collaboration. We'll
                                                                                                  • [Zoho Writer Webinar] Working with tables in Zoho Writer

                                                                                                    Hi Zoho Writer users, We're excited to announce the Zoho Writer webinar for the month of September 2023: Working with tables. This webinar will help you understand the various ways you can use tables to meet your specific needs. The webinar will take
                                                                                                  • Next Page