Zoho CRM Community Digest - July 2024

Zoho CRM Community Digest - July 2024



This month, Zoho CRM introduced new features to streamline your workflow and boost productivity, among other improvements. Additionally, explore how other Zoho users addressed their challenges and shared valuable solutions in our community forum highlights. Take a look!

Product Updates:

Discover and manage duplicate images with Zia Vision:

Zia Vision's Duplicate Image Detection feature enhances data accuracy by identifying duplicate facial images within your module. This functionality enables users to review records with similar images, validate them, and upload a new image if needed. You can also mark incorrect detections, which helps refine Zia's model for improved accuracy. Explore this post to learn more.

Zoho CRM Blueprints: Now with Optional Fields!

Zoho CRM now offers enhanced flexibility in blueprints by allowing fields to be designated as optional. Previously, all configured fields within the blueprint were mandatory to advance to the next stage. With this update, admins can mark specific fields as optional, enabling users to progress through the blueprint even if certain information is unavailable. This flexibility gives your users greater control over your process flow. Learn more in this post.

Actions by Zoho Flow Now Available in Standard and Professional Editions:

"Actions by Zoho Flow," an automation feature previously available only in the Enterprise edition and above, is now supported in Standard and Professional editions. This feature allows you to configure and automate tasks across various apps directly within Zoho CRM. You can now streamline workflows, schedule appointments, update project boards, and more, all without leaving your CRM. Take a look at this post to learn more!

Smarter Record Assignments with Role-Based Rules:

Zoho CRM now offers automatic record assignment to specific users based on their roles within the organization. With the addition of two new criteria qualifiers – "belongs to Role" and "does not belong to Role" – you gain enhanced flexibility in role-based assignment. Explore this post for more details!

Zoho CRM Introduces Wizard Generator and Summary!

Zoho CRM has introduced a wizard generator to streamline the creation process and a summary feature to review data before saving. Previously, creating wizards was a multi-step process, and reviewing entered data was challenging. Now, you can quickly generate wizards by selecting sections and fields from a layout and reviewing all entered data in one place before saving. Check-out this post to learn more.

Test CPQ Changes Safely in Sandbox Before Going Live:

Zoho CRM now offers a sandbox environment for safely testing and refining CPQ configurations. Experiment with new rules, modify existing ones, and push changes to live systems only after thorough testing. This feature lets you work with product configurations, price rules, and guided selling without impacting live data, ensuring a smoother implementation. Learn more in this post.

Streamline collaboration: Zoho CRM integrates with MS Teams:

Zoho CRM now integrates with Microsoft Teams, streamlining collaboration between the two platforms. Share CRM records and dashboards, trigger Workflow notifications in Teams for CRM events, and access CRM data directly within Teams, eliminating the need to switch between platforms. Dive into this post to explore the possibilities!

Streamline Processes with Kiosk in Blueprints:

You can now incorporate Kiosks as a mandatory step in Blueprint transitions, leading to a more streamlined approach to process execution and data collection. Additionally, you can publish Kiosks in multiple places within CRM, add them to record detail views for easier access, and benefit from an increased limit on the number of Kiosks you can create. Check this post for the full details!

Customize Field Selection for Mass Lead Conversion:

Zoho CRM's Leads module now offers enhanced mass conversion functionality, allowing you to select and fill only the essential fields from any deal module layout. Previously, you were restricted to a fixed set of fields from the standard deal layout, often requiring additional updates to address missing fields or remove unnecessary ones. Now, you can update only the necessary fields during mass conversion, with any unselected fields being automatically based on lead conversion mapping. Check out this announcement post for more details.


Useful Discussions:

Track Deal Progress with Zoho CRM's Stage Duration Report:

@Jennifer Keirn needed to calculate the average stage duration in the Deals module. @Ishwarya suggested creating a report with 'Deals' as the primary module and 'Stage History' as a child module. This approach allows you to calculate the average stage duration and group by stage, helping you easily identify how long deals remain in each stage and assess the level of adherence to promised turnaround times. Check the post to learn more.

Use Formula to Calculate Unit Price with Margin in Zoho CRM:

@ hayley.pool was seeking a simple solution to calculate the unit price by adding a required margin percentage to the unit cost in Zoho CRM using a formula field. @Bhoomi Joshi confirmed the feasibility and provided the necessary formula. Check the post for the details.

Implementing a Date-Based Formula and Field Calculations and Notification Solutions in Zoho CRM:

@Jeff Davis needed to create a date-based formula field in Zoho CRM that automatically calculates a date 98 days after the start date. @Hugh Marshall suggested the necessary adjustments to the formula, which Jeff successfully implemented. Additionally, community members explored options for sending notifications based on the calculated date and discovered potential solutions using workflows. Check this post for details.

Dynamic Image Inclusion in Zoho CRM Email Templates:

@arnau.marti presented an interesting use case: when a patient books an appointment, a workflow should trigger an email that includes an image from the URL field in the Doctors module. The challenge was dynamically pulling the image based on the assigned doctor. With @Hugh's assistance, Arnau successfully used a merge tag to incorporate the image into the email template. Discover the solution in this post.

Calculating Days Between Two Dates Based on Checkbox Selection:

@raantjes needed to calculate the number of days between two dates in a record, with the formula varying depending on whether a checkbox field is selected or not. @Bhoomi Joshi provided the appropriate formula to address this requirement. Find the details in this post.

Functions:

Extracting Month and Day from Date Field:

Reviving an old topic, Zoho CRM users had previously discussed how to extract and display only the month from a date field. The original solution involved using a formula field with nested IF statements to convert the month number to its corresponding text format. @Mike Wood revisited this topic, seeking to include the day of the month as well. @Nik provided two solutions: one with adjustments to the existing formula and another using Functions. Explore the solutions in this post.

Automating Deal Record Updates with New Notes:

@sales blueraycargo needed to automatically update a specific field in a deal record whenever a new note was added to that deal. @Subhash Kumar suggested creating a workflow rule triggered by the addition of a new note and using a function code to retrieve and update the deal record. Check out the solution in this post.

Creating Multiple Sales Orders from a Single Quote:

@Shreyash Patel wanted to create multiple sales orders from a single quote in Zoho CRM. @Ishwarya SG provided a function code to achieve this. The function clones the quote record, removes unnecessary fields, and creates multiple sales order records based on the product details in the quote. Take a look at this post for the code and other details.

Dev's Corner:

Zoho CRM Bulk Export Challenge and Solution:

@Claire needed to export contacts associated with multiple campaigns in Zoho CRM for Power BI analysis. Existing solutions didn't link contacts to specific campaigns within the exported data. @Bala Ganesh suggested an API query that retrieves contact details along with the related campaign names. This allows Claire to map and identify which contacts belong to each campaign record. Learn more in this post.

Handle 'invalid error' in Refreshing Access Tokens:

@IT encountered an "invalid code" error while attempting to refresh an access token for Zoho CRM API interactions. This error could be due to an expired or invalid refresh token. Check @Maria Antony Betson M's solution in this post for potential causes and useful links for proper token management to avoid these issues.

Color-Coding Picklist Values:

@WM Yeo wanted to color-code picklist values based on ranges, similar to conditional formatting in spreadsheets. While built-in picklist colors are available, @Nik suggested using Client Scripts for a more dynamic approach. @Maadhari M provided a detailed solution with sample code in this post.

Kaizen:

(Kaizen #145) Assigning values to different field types using Zoho CRM SDKs - Part III:

The post guides you through assigning values to various standard and custom field types in Zoho CRM using the Python SDK. It includes code examples for assigning values to each field type, including handling null values and, provides detailed explanations and code samples.

(Kaizen #146) - Assigning values to different field types using Zoho CRM SDKs - Part IV

This post provides a comprehensive guide on assigning values to various standard and custom field types in Zoho CRM using different SDKs. It covers the syntax, includes code examples, and outlines the best practices for managing different field types effectively.

(Kaizen #147) - Frequently Asked Questions on Zoho CRM Widgets

This post addresses common developer questions about Zoho CRM Widgets. It covers where widgets can be used, how to create them, and details size and file limitations. It also explains various functionalities including parameters, JS SDK, Client Script, and data passing between widgets and Client Script. Additionally, it provides information on using widgets for telephony extensions and opening dial pads.

(Kaizen #148)- 'trigger' in Records APIs

This post discusses the "trigger" key within Zoho CRM's Insert, Update, and Upsert records APIs. It explains how to use this key to control which automation actions are triggered when a record is created, modified, or updated.

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

    Access your files securely from anywhere









                          Zoho Developer Community




                                                • Desk Community Learning Series


                                                • Digest


                                                • Functions


                                                • Meetups


                                                • Kbase


                                                • Resources


                                                • Glossary


                                                • Desk Marketplace


                                                • MVP Corner


                                                • Word of the Day


                                                • Ask the Experts





                                                          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

                                                                                            Get Started. Write Away!

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

                                                                                              Zoho CRM コンテンツ






                                                                                                Nederlandse Hulpbronnen


                                                                                                    ご検討中の方




                                                                                                          • Recent Topics

                                                                                                          • Zoho Invoice Now Supports VeriFactu for Businesses in Spain

                                                                                                            Starting from January 1, 2026, Spain requires real-time invoice reporting for all B2B transactions. From July 2026, this requirement will extend to B2C transactions as well. All reporting must be carried out through the VeriFactu to AEAT (Agencia Estatal
                                                                                                          • Will I Get a Refund If I Downgrade Zoho Mail?

                                                                                                            Hello, We upgraded an email account for our new employee. However, the employee left after one month, and now I've reduced the number of Zoho Mail users from 7 to 6. Can we get a refund for the remaining portion of our annual payment?
                                                                                                          • Zoho Billing Now Supports VeriFactu for Businesses in Spain

                                                                                                            Starting from January 1, 2026, Spain requires real-time invoice reporting for all B2B transactions. From July 2026, this requirement will extend to B2C transactions as well. All reporting must be carried out through the VeriFactu to AEAT (Agencia Estatal
                                                                                                          • how to add subform over sigma in the CRM

                                                                                                            my new module don't have any subform available any way to add this from sigma or from the crm
                                                                                                          • Introducing the revamped What's New page

                                                                                                            Hello everyone! We're happy to announce that Zoho Campaigns' What's New page has undergone a complete revamp. We've bid the old page adieu after a long time and have introduced a new, sleeker-looking page. Without further ado, let's dive into the main
                                                                                                          • Zoho Books - France

                                                                                                            L’équipe de Zoho France reçoit régulièrement des questions sur la conformité de ses applications de finances (Zoho Books/ Zoho Invoice) pour le marché français. Voici quelques points pour clarifier la question : Zoho Books est un logiciel de comptabilité
                                                                                                          • Name autocomplete

                                                                                                            Hi, During searching emails the web tool does not always propose the auto-completion of the saved emails. As a result I either have to go to contacts and look up the exact email, or the exact full name including the middle name and any dots, which is very annoying. For example I have a contact that I emailed in the past that has "First M. Last" <email@email.com> type of contact. When I start typing 'First' the email may or may not pop up in the autocomplete menu. Then if I start typing "first last"
                                                                                                          • Using a CRM Client Script Button to create a Books Invoice

                                                                                                            Hello, I need help handling error messages returned to my client script from a function. The scenario I have setup a client script button which is available from each Deal. This CS executes a crm function, which in turn creates an invoice based on the
                                                                                                          • Why Format section gets disabled when we create Merge Template over PDF

                                                                                                            I need some assistance I have a Client who is going to give certificates to users who passes his exam. So, I am using mail merge but in ZOHO writer after I upload the PDF and create merge Template over PDF the format Section gets disabled. My problem
                                                                                                          • Possible to connect Zoho CRM's Sandbox with Zoho Creator's Sandbox?

                                                                                                            We are making some big changes on our CRM so we are testing it out in CRM's Sandbox. We also have a Zoho Creator app that we need to test. Is it possible to connect Zoho CRM's Sandbox to Zoho Creator's Sandbox so that I can perform those tests?
                                                                                                          • How do i follow up my email campaign in-thread

                                                                                                            Is there a way to follow up the email campaign so that it is in-thread using zoho campaigns? eg customer gets original email with subject line "hello" then 5 days later follow up would be with subject line "RE: hello".
                                                                                                          • Announcing new features in Trident for Mac (1.29.0)

                                                                                                            Hello everyone! Trident for macOS (v1.29.0) is here with new features and enhancements to enhance your business communication. Let's take a quick look at them. Access shared mailboxes. You can now view and access shared mailboxes in Trident, which are
                                                                                                          • Books is extremely slow again today !

                                                                                                            Everything is running slowly even with 500mb connection speed
                                                                                                          • Cyclic dependencies in many-to-many relationships...

                                                                                                            I have an application which includes a form for companies, and a form for contacts. Each company can be assigned 1 technical and 1 administrative contact. I have this working okay so far, but I want to copy the scripts used so far to a new empty application. When I import the scripts it fails with a message that says: Problem encountered while creating the application Error in resolving form dependency:Cyclic dependency among the forms:[Company, Contact] What can I do to resolve this? After all,
                                                                                                          • Zoho Workdrive for Office, "vsto runtime not found"

                                                                                                            Hi all, I have been trying to get ZohoWorkdrive_MS-addin_1.4.exe installed, but I keep getting the error "VSTO Runtime Not Found!" - even though I have installed it ... Anyone else hear had problems with the MS addin?  FYI, I am using O365 on A Dell laptop running Win 10 Home - fully patched and up-to-date.  I have tried compatibility modes and running explicitly as Administrator - the usual steps. Any advice would be appreciated.
                                                                                                          • Zia’s AI Assist now helps you write clearer notes — in seconds

                                                                                                            After helping recruiters craft job descriptions, emails, and assessments, Zia’s AI Assist is now stepping in to make note-taking effortless too. Whether you’re recording feedback after an interview or sharing quick updates with your team, you can now
                                                                                                          • Zoho API to create ticket

                                                                                                            I'm developing an integration to create tickets via API, but, locally it works (send and recieve requests). In production it also works sending requests, but, my file don't recieve any response data. My URL is available in Zoho API Console and I have
                                                                                                          • Automate Timesheet Approvals with Multi-level Approval Rules

                                                                                                            Introducing Approval Rules for Timesheets in Zoho Projects. With this automation, teams can manage how timesheets are reviewed and approved by setting up rules with criteria and assigning approvers to handle submissions. Timesheet, when associated to
                                                                                                          • Building Toppings #1 - Serving your needs with Bigin Toppings

                                                                                                            Hey Biginners! We're excited to kick off our Developer Community series on building toppings for Bigin, and our goal is to provide an accessible, beginner-friendly, and relevant path for every developer. Imagine creating tiny pieces of software that unlock
                                                                                                          • Can we create Sprint with tasks from Multiple projects?

                                                                                                            Hi Team, We were using Zoho Sprints for quite sometime. Currently we have started the process of Sprint method. We couldnt create the active sprint board with the tasks from multiple projects. I would like to know whether this is possible or Any timeline
                                                                                                          • Tip of the Week #74– Create automated workflows in MS Power Automate

                                                                                                            Zoho TeamInbox now connects directly with Microsoft Power Automate, letting you streamline everyday routines tasks such as from sending emails to managing threads, with automated workflows. About the integration Zoho TeamInbox integrates with Microsoft
                                                                                                          • Account validation

                                                                                                            Hello everyone, I registered my account on ZeptoMail to use the system, but the problem is that the verification period on Zepto's end has already passed and I have limited functionality.
                                                                                                          • Paste issues in ZOHO crm notes

                                                                                                            Hi, since a week or so I have issues with the paste function in ZOHO CRM. I use "notes" to copy paste texts from Outlook emails and since a week or so, the pasting doesnt function as it should: some text just disappears and it gives a lot of empty lines/enters.....
                                                                                                          • Is it possible to add a gradient color to a newsletter im designing?

                                                                                                            From where i sit it looks like you can only choose a single color but not combine 2 colors?
                                                                                                          • New Feature: Audit Log in Zoho Bookings

                                                                                                            Greetings from the Zoho Bookings team! We’re excited to introduce Audit Log, a new feature designed to help you track all key actions related to your appointments. With Audit Log, you can maintain transparency, strengthen security, and ensure accountability.
                                                                                                          • Custom validation in CRM schema

                                                                                                            Validation rules in CRM layouts work nicely, good docs by @Kiran Karthik P https://help.zoho.com/portal/en/kb/crm/customize-crm-account/validation-rules/articles/create-validation-rules I'd prefer validating data input 'closer to the schema'
                                                                                                          • Customised Funnel

                                                                                                            We are running the standard plan for our ZOHO CRM. I have been asked if there is a way to combine data from the Calls module, Deals module and Contact Module into 1 funnel, similar to the view you can get when viewing Deals By Stages, you can see the
                                                                                                          • Good news! Calendar in Zoho CRM gets a face lift

                                                                                                            Dear Customers, We are delighted to unveil the revamped calendar UI in Zoho CRM. With a complete visual overhaul aligned with CRM for Everyone, the calendar now offers a more intuitive and flexible scheduling experience. What’s new? Distinguish activities
                                                                                                          • Account disabled

                                                                                                            I have an issue I need help with. Whilst trialing ZOHO CRM I created the following: Account1 (-------------) using m__ame@m__rg___s__i__.___.__ and 2 personal emails Account2 (-------------) using a personal email and 2 users _al__1@______________._o_.__
                                                                                                          • Blocked Email

                                                                                                            We are a Zoho One subscriber and use Yahoo as our MX provider. A few times each year, for the past four years, CRM blocks one or more of my Zoho One users from receiving internal email from CRM. This includes "@mentions" in all modules, and emails from
                                                                                                          • message var is empty in bot mention handler

                                                                                                            Hi, I'm encountering a problem: in my bot's mention handler, I want to retrieve the text the user typed when mentioning the bot. Example: On the #tests-cyril channel, I send this message: “@Donna hello how are you ?” I expect the system variable "message"
                                                                                                          • Remembrance Day to Remember – Recalling Values

                                                                                                            The phrase “at the eleventh hour” refers to the 11th hour of the 11th day of the 11th month in 1918, when the hostilities of World War I came to an end—but it still holds meaning today. Remembrance Day (Veterans Day in the US) is observed on November
                                                                                                          • Enhancing Zia's service with better contextual responses and article generation

                                                                                                            Hello everyone, We are enhancing Zia's Generative AI service to make your support experience smarter. Here's how: Increased accuracy with Qwen One of the key challenges in AI is delivering responses that are both contextually accurate and empathetic while
                                                                                                          • How to display two measures (sales and price) divided by categories on one line chart

                                                                                                            Hi everyone, I’m having trouble figuring out how to display two columns on a line chart with category breakdowns. What I need is a line chart where one line represents Sales and the other represents Price. However, the Price data is divided into around
                                                                                                          • Create custom rollup summary fields in Zoho CRM

                                                                                                            Hello everyone, In Zoho CRM, rollup summary fields have been essential tools for summarizing data across related records and enabling users to gain quick insights without having to jump across modules. Previously, only predefined summary functions were
                                                                                                          • Introducing the locking option for CRM records

                                                                                                            Last modified on 06/04/2023: Record locking option in CRM is now available for all Zoho CRM users in all DCs. Note that it was an early access feature available only upon request. Hello All, Hope you're doing well! We're thrilled to introduce our latest
                                                                                                          • Two new enhancements in Zoho CRM: Introducing new criteria for user fields and displaying group information in users page

                                                                                                            Announcement moderated on 14th June, 2023. Dear All, These enhancements are opened for all users in all DCs. ------------------------------------------------------------------------------------- Dear All, Hope you're well! We are here with two useful
                                                                                                          • Tip #49- Navigating the Remote Support Dashboard in Zoho Assist- 'Insider Insights'

                                                                                                            The Remote Support dashboard in Zoho Assist is designed to help technicians quickly access, manage, and monitor all their support sessions from a single, intuitive interface. Whether you’re starting a new session, managing ongoing connections, or reviewing
                                                                                                          • BMI formula

                                                                                                            I've been trying for hours to calculate BMI using height and weight as my only inputs. It's a simple calculation and I even went to ChatGPT to help me figure this out in Zoho Forms, but it led me down a path of "try this" and "try this". None of my attempts
                                                                                                          • SEO on blogs

                                                                                                            Hello, google is not able to find my blogs. Can you advice me if I need to change some settings or anything else to make it retrievable via SEO many thanks, hans
                                                                                                          • Next Page