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 Writer

                                                                                          Get Started. Write Away!

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

                                                                                            Zoho CRM コンテンツ










                                                                                              Nederlandse Hulpbronnen


                                                                                                  ご検討中の方




                                                                                                        • Recent Topics

                                                                                                        • Disable fields in multiple subform rows

                                                                                                          Hello everybody! I have an odd one here. I have a subform that collects hours of operation. It contains these fields: Days, Type, Open, and Closed. On load of the form I add 7 rows with Mon - Sun in the Days field. I then disable that field and the add/delete
                                                                                                        • Introducing Assemblies and Kits in Zoho Inventory

                                                                                                          Hello customers, We’re excited to share a major revamp to Zoho Inventory that brings both clarity and flexibility to your inventory management experience! Presenting Assemblies and Kits We’re thrilled to introduce Assemblies and Kits, which replaces the
                                                                                                        • Associating Multiple Work Orders with a Single Invoice in Zoho FSM

                                                                                                          Hello Everyone, Is it possible to associate multiple Work Orders with a single Invoice in Zoho FSM? Best Regards, Subhash Kumar
                                                                                                        • Client Script Quality of Life Improvements #1

                                                                                                          Since I'm doing quite a bit of client scripting, I wanted to advise the Zoho Dev teams about some items I have found in client script that could be improved upon. A lot of these are minor, but I feel are important none-the-less. Show Error on Subform
                                                                                                        • [Webinar] Evolving BI & Analytics in the Age of AI

                                                                                                          Artificial intelligence is redefining how data is collected, analyzed, and leveraged across industries. As businesses strive to become more agile and insight-driven, traditional BI and analytics must transform to meet new demands. AI-first organizations
                                                                                                        • 請求書に添付されているファイルをAPI経由で取得する際の問題について

                                                                                                          Books APIリファレンス 現在、Books APIを利用して請求書内の添付ファイルを取得するメソッドを構築しています。以下のコードを参考にしているのですが、添付ファイルが複数アップロードされている場合、responseにおいて2つ目のファイルの情報しか取得できない現象が発生しています。 headers_data = Map(); headers_data.put("Authorization", "Zoho-oauthtoken 1000.41d9xxxxxxxxxxxxxxxxxxxxxxxxc2d1.8fccxxxxxxxxxxxxxxxxxxxxxxxx125f");
                                                                                                        • Zoho CRM and Books Integration

                                                                                                          Evening, I have started the integration with FSM from CRM and having difficulties with the mapping. In CRM we use "Unit Price" as our cost price and mark this up on a subform to create a "Sell Price" this markup can be different on each quote depending
                                                                                                        • CREATE REPORT USING TWO FORMS

                                                                                                          ONE FORM CONTAINS LIST OF ALL CLIENTS WHOSE RETURN IS FILED AND OTHER FORM CONTAINS LIST OF RETURNS FILED YEARWISE. NOW I REQUIRED A REPORT OF ALL CLIENTS WHOSE RETURN ARE PENDING FOR A PARTICULAR YEAR
                                                                                                        • Leadchain into a custom module

                                                                                                          Hello ZOHO Community ! is it possible to put the leads collected by leadchain into a custom module instaed of leads module ? Best wishes Niels
                                                                                                        • Zoho Flow to Azure Devops

                                                                                                          hi, i'm getting this when trying reauthorize the connection from Zoho Flow to Devops but when i look in Devops there is no service connection related to Zoho So i do not know where i have to renew the mentioned client secret..
                                                                                                        • 533 Relaying disallowed

                                                                                                          When I try to send an email from my Zoho account, it gives me that error 533: relaying disallowed. What should I do? Please help.
                                                                                                        • Formula Module how to convert to percentage

                                                                                                          Hello There, I have create a formula field and i want the outcome to be in percentage how do i do that This is my formula ${Deals.Forecast Revenue Per Year}/${Deals.Annual Processing Volume} I have try ${Deals.Forecast Revenue Per Year}/${Deals.Annual
                                                                                                        • Sandbox - Your Secure Testing Space in Zoho Projects

                                                                                                          Managing projects often involves fine-tuning processes, setting up new automations, or making configuration changes. Making those changes directly in a live environment leaves no room for trial and error. Sandbox in Zoho Projects is a dedicated testing
                                                                                                        • Zoho CRM Functions 53: Automatically name your Deals during lead conversion.

                                                                                                          Welcome back everyone! Last week's function was about automatically updating the recent Event date in the Accounts module. This week, it's going to be about automatically giving a custom Deal name whenever a lead is converted. Business scenario Deals are the most important records in CRM. After successful prospecting, the sales cycle is followed by deal creation, follow-up, and its subsequent closure. Being a critical function of your sales cycle, it's good to follow certain best practices. One such
                                                                                                        • Third party apps for my mail

                                                                                                          Hello im new here and i have a very important issue. A third party company uses one of my emails to send invoices to our customers. My problem is that cannot connect to zoho mail server. my imap settings are corrent imappro.zoho.eu 993 smtppto.zoho.eu
                                                                                                        • 553 relaying disallowed invalid domain

                                                                                                          Hi, I have read the previous article but i am still facing issue , I have added all these in my domain manager under dns settings. type : cname host: zb14521202 value / points to : validate.zoho.com Can you please tell me why i am still facing same issue
                                                                                                        • Announcing new features in Trident for macOS (v.1.18.0)

                                                                                                          Hello everyone! Trident for macOS is here with interesting features and enhancements to elevate your workplace communication and productivity. Let's take a quick look at them. Retract sent emails. Whether you've missed adding an important attachment or
                                                                                                        • How do I add more space to a note in ‘draw’?

                                                                                                          I’m taking handwritten notes using the draw note, but I don’t seem to be able to scroll down to get more room on the page. How do I make more room to take notes?
                                                                                                        • Este domínio já está associado a esta conta

                                                                                                          Fui fazer meu cadastro na zoho e quando digitei meu domínio recebi essa mensagem que meu domínio estava associado a uma conta que eu nem faço idéia de quem seja. Como que faço pra resolver isso? Atenciosamente, Anderson Souza.
                                                                                                        • USA Military addresses

                                                                                                          When we have a client with a US military address adding them to the CRM, or having them fill in a form is a problem. Zoho Forms and CRM doesn't seem accommodate them correctly. It doesn't make sense for me to have to create a secondary data model for
                                                                                                        • Canvas View Change History

                                                                                                          We are trying to setup Canvas Views and it is really not a pleasant experience. It bugs a lot, some pages are just not accessible anymore and it shows that a view is just not editable because it shows a blank page, although when we open an actual record,
                                                                                                        • Office 365 is marking us as "bulk"

                                                                                                          All of a sudden (like a couple of days ago) all of our customers who are on Office 365 are getting our mails in their junk email. This is not the case with Gmail or other random mail servers, nor between us. We got a 10/10 score on mail-tester.com. Also,
                                                                                                        • Zoho CRM's V8 APIs are here!

                                                                                                          Hello everyone!!! We hope you are all doing well. Announcing Zoho CRM's V8 APIs! Packed with powerful new features to supercharge your developer experience. Let us take a look at what's new in V8 APIs: Get Related Records Count of a Record API: Ever wondered
                                                                                                        • Leadchain BUG

                                                                                                          Hello i have a problem with Facebook Leadchain. All of the information is populated correctly in the CRM, except the campaign. I want to add new leads to an existing campaign, but the lead is not added to the campaign even tough i have selected the campaign
                                                                                                        • What is the use of the stage environment ?

                                                                                                          Salut, I am woundering what is the use of the stage environment. Usually, I do all the testing in developpement, and then go straight to production. The only thing I cannot test in developpement, is the result for portal users. Could the stage environment
                                                                                                        • Workflow Automation Instant Action

                                                                                                          Hello All I need help to resolve this. I have created a few workflow 1. When Deal Stage is Submitted to Onboarding, it will create a record in my Onboarding Module 2. When Deal Stage is Live, It will copy $Deal.GOliveDate to $Onboarding.GoLiveDate For
                                                                                                        • Live webinar: Transitioning from MS PowerPoint to Zoho Show

                                                                                                          What’s the first word that comes to mind when you think of presentations? For many, it’s PowerPoint. This has been the default for so many years that “PPT” has become a stand-in for “presentation.” But presentation needs are changing. And if you’re looking
                                                                                                        • Short Custom Order

                                                                                                          Hi Everyone, I have question, i create some report use custom short order like below. But this is just show in development mode.... when i publish to production, it is not showing. And this is just showing in full admin mode. Can setting to show roles
                                                                                                        • Introducing Keyboard Shortcuts for Zoho CRM

                                                                                                          Dear Customers, We're happy to introduce keyboard shortcuts for Zoho CRM features! Until now, you might have been navigating to modules manually using the mouse, and at times, it could be tedious, especially when you had to search for specific modules
                                                                                                        • Assistance with Bulk Contact Import in Zoho Email Campaign

                                                                                                          I’m currently in the process of importing the Supermarkets customer list from Zoho Accounts into Zoho Email Campaigns. During the import, I’m being prompted to complete the "field mapping" section, but I’m unsure how to properly configure it to ensure
                                                                                                        • Introducing Zoho CRM for Everyone: A reimagined UI, next-gen Ask Zia, timeline view, and more

                                                                                                          Hello Everyone, Your customers may not directly observe your processes or tools, but they can perceive the gaps, missed hand-offs, and frustration that negatively impact their experience. While it is possible to achieve a great customer experience by
                                                                                                        • Variables in Zoho Mail Signatures defined by Administrator

                                                                                                          Good afternoon, I'm looking at the Admin component of Zoho Mail, and I see we have the capability to define signatures for end users. We also have the ability to associate with multiple email addresses. Are we able to use any variables such as [FirstName}
                                                                                                        • Custom view placeholders

                                                                                                          Hi all, On some occasions it would be great to have placeholders setting up a custom view. Example in our case we have a field for a year. We would like to have a placeholder like $.{CurrentYear} that will insert the current year 2025 e.g. Now we have
                                                                                                        • Article Numbers for KB articles

                                                                                                          Hello, I was wondering if it's possible to turn on article numbers/ part numbering for KB articles. If this is not already a feature, we'd like to request it. Frequently a solution will require multiple articles so tracking which articles are referenced
                                                                                                        • Add Subform Field based on Record Field

                                                                                                          Hi All, I am struggling with finding a solution that can populate a subform field based on an existing field on the record. Use case is I have added Current Exchange Rate on a quote as a custom field, I then have a subform with Quoted items that include
                                                                                                        • Sales Order automatic Convert to Invoice using boolean True or false

                                                                                                          It is possible to convert the Sales order to an invoice using a boolean field, true or false Example: I create a field in my Sales Order, I name it QBO Invoice, and the field type is Boolean, true or false. Let's say the default is false, so when I change
                                                                                                        • IMPORTRANGE Spreadsheets

                                                                                                          I am trying to importrange a spreadsheet into another, but an error keep appearing saying NOT LINKED. Noting that I've linked it. I've tried to publish both sheets and re-apply the formula many times but nothing is working. I don't know what can I do
                                                                                                        • Should I save dead quotes

                                                                                                          I work in vehicle transport, specializing in transporting vehicles for dealerships. My role involves collaborating with individuals at each dealership to facilitate the transport of their vehicles to customers and from auctions. My question is whether
                                                                                                        • MULTI-SELECT LOOKUP - MAIL TEMPLATE

                                                                                                          Dear all how are you? We need to insert data from MULTI-SELECT LOOKUP in a email template, but I can't do that, when I'm creating the template I can't find the field to insert it. is there any solution? PVU
                                                                                                        • Canvas translation

                                                                                                          We want to offer our CRM system to our users in English and Dutch. However, it seems that text in our deal Canvas isn't available for translation through the translation file. The same applies to the field tooltips. They don't appear in the translation
                                                                                                        • Next Page