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

                                                                                                  • Editor limitations to define screen types

                                                                                                    Guys I have noticed that even in version 2.0 of the editor (which is this new one we use) we still have a lot to improve... When I compare to some more global solutions like Wix, Zyro, Go Daddy, Squarespace and Weebly feel that we have some limitations
                                                                                                  • Dúvidas do Zoho Creator

                                                                                                    Pessoal, Estou colocando um tópico para dúvidas do Zoho Creator. Um abraço, Leandro
                                                                                                  • Tropicalize Books

                                                                                                    Books is an incredibly powerful tool that works well in many countries. But I feel that it is a product that is not yet "tropicalized" for Brazil as we speak (this would be like adapting the local reality). We have many strong competitors who do more
                                                                                                  • Automatic Sitemap Generation

                                                                                                    Guys are all right? Doesn't make sense for me to have to generate a map site and upload it... because it's not automatically generated just as it is done in WIX? where the customer doesn’t have to worry about this.
                                                                                                  • SEO improvements with ZIA

                                                                                                    Are you okay? I would like to bring an idea that would be amazing to improve the product that is the possibility of being able to improve the SEO of the pages (this of each page or each article on the blog) through ZIA so that it could create page Summary
                                                                                                  • Automatically updating field(s) of lookup module

                                                                                                    I have a lookup field, which also pulls through the Status field from the linked record. When the lookup is first done, the Status is pulled through - this works perfectly. If that Status is later updated, the lookup field does not update as well. As
                                                                                                  • Initiating a SalesIQ Zobot from a custom button on Zoho Sites

                                                                                                    I have created a Zobot set to initiate on a custom action called "Fast_Answers". On Zoho Sites, I created a code snippet button and set it to on-click run the event called "Fast_Answers". I installed the SalesIQ integration code into the Zoho Sites Page
                                                                                                  • Zoho Desk -> Zoho Analytics : Where is the field for "Layout" ?

                                                                                                    I have many different layouts on my helpdesks and I want to be able to identify the stats for each one, however I can not file the field in the raw data from the Zoho Desk datasource. I thought it might be under "Tickets" but there is nothing. There is
                                                                                                  • Set resolution mandatory field

                                                                                                    Hi,  i have 2 questions:) : - i want to set the resolution field mandatory before close the ticket. Because for now, i can close the ticket without writing how i solve it - how can i setup zoho desk to receive ticket by email(e.g. clients sent email to support@mydomain.com) and it create a ticket in zoho desk
                                                                                                  • Zoho Assist "Agree and Download" Button "Greyed Out" ("Light Blued" Out)

                                                                                                    Anyone else having issue where support clients are unable to click "Agree and Download" to access the client so that we can provide remote support? This is for "on demand" support via accessing the support page and entering the support key and name. This
                                                                                                  • Project Billing with the Staff Hours Method in Zoho Projects

                                                                                                    The Staff Hours Billing Method in Zoho Projects allows you to bill your clients based on the actual time spent by each team member on a project, at the rate set for each user. This is useful for projects where different skill sets are needed and service
                                                                                                  • Creator Subform to CRM Subform

                                                                                                    Hello all, Has anyone successfully written data from a Creator Subform into CRM subform? I have a Creator form that once submitted creates a new Location in the CRM. Inside a Location there is a subform for hours of operation. I collect those hours in
                                                                                                  • custom fields not populating from deluge script into invoice

                                                                                                    Hello, I've created some Deluge script that is meant to take a few inputted invoice custom fields and calculate a few others. I can see when I execute the function that my inputted custom fields are being passed, yet im still ending up with all "null"
                                                                                                  • tax summation function - getting error

                                                                                                    Hello, I'm trying to create a function that adds all of individual tax rates from a few jurisdictions. I'm getting an error on line 9 - Value is empty and 'get' function cannot be applied. I've checked that I have data in each of the required fields,
                                                                                                  • Backstage / Zoho Books integration

                                                                                                    Hello. We have Zoho One and have slowly started using Backstage. Loving it. Problem is, we have ZERO accounting control over what is sold through this product. When will we be able to connect it to our existing Zoho Books tenant? Thank you very much!
                                                                                                  • Getting list of calendar events over api for zoho mail calendar

                                                                                                    Hi, I am using just Zoho mail without using Zoho CRM. I wanted to get all events booked in my zoho mail calendar through an api at regular intervals. I could find such API support for Zoho CRM calendar but not for zoho mail calendar. Can you kindly let
                                                                                                  • Allocate emails to user in a shared mailbox

                                                                                                    Hi, This might be obvious, but I cannot find the answer. I have 3 shared mailboxes so any team member can see the emails. Is there a way of allocating a specific email to a user so that it is their responsibility to deal with it? Thanks in advance.
                                                                                                  • Introducing Zoho Campaigns' own gateway for SMS campaigns

                                                                                                    We are excited to announce the launch of our SMS Gateway to send SMS through Zoho Campaigns. We have also made a few other changes in our current SMS Campaign model to improve your over all user experience. These updates are planned with an aim to expand
                                                                                                  • Update a lookup field in CRM from Creator using deluge

                                                                                                    I have a Creator form that creates a new account. When it creates the new account in the Accounts Module, I need it to also populate the Parent Account, which is a lookup field coming from the Module Parent Accounts, field Parent Account Name. I have
                                                                                                  • SMS Keyword Tracking in Zoho CRM From Zoho Campaigns

                                                                                                    Is there a way to track SMS leads in campaigns by associating them with specific keywords or codes? Additionally, can these leads be pushed to the CRM while retaining the keyword for tracking and reporting purposes?
                                                                                                  • Projects Multiselect API

                                                                                                    Having troubles setting a mutli select field via API. updateMap = map(); updateMap.put("UDF_MULTI1","picklist_id1,picklist_id2"); updateProjectRes = invokeurl [ url :"https://projects.zoho.com/restapi/portal/XXXX/projects/" + projectID + "/" type :POST
                                                                                                  • Bill quantity received / PO quantity

                                                                                                    PO's are raised & often the quantity received is greater than the PO quantity, so when we receive the bill & adjust the quantity on the bill we get.... Quantity recorded cannot be more than quantity ordered. This necessitates the adjustment of the PO
                                                                                                  • ZOHO BOOKS - RECEIVING MORE ITEMS THAN ORDERED

                                                                                                    Hello, When trying to enter a vendor's bill that contains items with bigger quantity than ordered in the PO (it happens quite often) - The system would not let us save the bill and show this error: "Quantity recorded cannot be more than quantity ordered." 
                                                                                                  • Unused items should not count into the available number of custom fields

                                                                                                    Hey, I realized that unused Items reduce the number of available custom fields. I can't see a case where that makes sense. Especially in our case where we have two different layouts in Deals with a lot of different fields, this causes problems.
                                                                                                  • Introducing Bot Filtering for Accurate Email Campaign Analytics

                                                                                                    Dear Marketers, We're excited to announce a new feature designed to enhance the accuracy of your email campaign analytics: bot filtering. This feature helps you filter out bot-generated opens and clicks, ensuring your campaign reports reflect genuine
                                                                                                  • Tip 37: Time Log Restriction in Zoho Projects

                                                                                                    Timesheet in Zoho Projects helps you big time in entering log hours for the tasks and issues and approving them. Now, with the new Time Log Restriction option, you can set daily and weekly log hour limits. You can restrict users from entering extra log hours than the permissible limit. The limits are restricted to 24 hours per day and 168 hours per week by default based on business hours. To customize, navigate to Task & Timesheet settings under Portal Configuration in Zoho Projects setup and enable
                                                                                                  • Chart showing schedule

                                                                                                    I want to be able to create a chart for everyday to check and which of which driver is available on the timeframe. Here's my table Name City Day Start Time End Time Driver1 Medicine Hat Monday 11:45 AM 4:45 PM Driver 2 Medicine Hat Tuesday 11:00 AM 7:00
                                                                                                  • Multiple Vendor SKUs

                                                                                                    One of the big concerns we have with ZOHO Inventory is lack of Vendor Skus like many other inventory software packages offer. Being able to have multiple vendor skus for the same product would be HUGE! It would populate the appropriate vendor Sku for
                                                                                                  • Zoho Payroll in France

                                                                                                    When will Zoho Payroll be available in France ?
                                                                                                  • Blueprint - 'On hold' state with an automatic transition?

                                                                                                    I think I'm missing something here so I'm hoping if I explain what I'm trying to achieve someone might be able to give me a way around it. We sometimes get request far in advance but we don't want to action them unless it is 7 days from when they are
                                                                                                  • HOW TO VIEW INDIVIDUAL COST OF NEWLY PURCHASED GOODS AFTER ALLOCATING LANDED COSTS

                                                                                                    Hello, I have been able to allocate landed costs to the purchase cost of the new products. however, what i need to see now is the actual cost price (original cost plus landed cost), of only my newly purchased products to enable me set a selling price
                                                                                                  • Calculate months and years between 2 dates on subform

                                                                                                    I am looking for a function syntax for an employment candidate to calculate the number of years and months (decimal format. eg 1.2 years) they are employed. I have their start date entered, but if the end date is blank, that tells me they are still employed
                                                                                                  • Combine related grouping values into categories in CRM analytical components

                                                                                                    Hello everyone, Analyzing large datasets can be challenging when dealing with numerous individual data points. It's often difficult to extract meaningful insights when information is scattered and ungrouped. To address this, we're adding options to create
                                                                                                  • How Kiosk Studio can simplify sales for bank employees | Kiosk Studio Session #4

                                                                                                    Hello everyone, Banks can boost revenue by cross-selling to their current customers. For example, they can sell credit cards, personal loans, and more to existing account holders. To do this, bank employees move all around the CRM, open and close records,
                                                                                                  • Tip #19 - Create checkbox tracker in your spreadsheet

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

                                                                                                                         Please let me know if its possible to Integrate Oracle with ZOHO CRM. If yes then help me in doing it. 
                                                                                                  • UUIDs

                                                                                                    Has anyone coded a Universal Unique Identifier (UUID) generator in Deluge?
                                                                                                  • Introducing signer groups: Streamline signature collection and make it even faster

                                                                                                    Hello everyone, We're excited to introduce signer groups, a feature designed to make your signing process quicker, more efficient, and collaborative. With signer groups, you can send an envelope to a group of people, and any member of the group can open
                                                                                                  • Calendar - Recurring Event - End of Month and Last Weekday of Month

                                                                                                    How do I set a calendar event to recur on the last day of every month? How do I set a calendar event to recur on the last weekday of the month?
                                                                                                  • Duplicate Zoho Invoices and Sales Receipts

                                                                                                    We have been running into an issue where upon saving an invoice or a sales receipt, we get a duplicate: same information saved twice but with a different invoice id/number and sales receipt id/number. I have logged a ticket but so far no response. It
                                                                                                  • Next Page