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

                                                                                                          • Custom Bulk Select Button

                                                                                                            Zoho CRM offers the ability to select multiple records and invoke a Custom Button This functionality is missing from Recruit Currently we can only add buttons in the detail page and list But we cannot select Multiple Records and invoke a function with
                                                                                                          • Power of Automation :: Smart Ticket Management Between Zoho Desk and Projects

                                                                                                            Hello Everyone, A custom function is a software code that can be used to automate a process and this allows you to automate a notification, call a webhook, or perform logic immediately after a workflow rule is triggered. This feature helps to automate
                                                                                                          • BUG - Google Business Buttons - Add a button to GBP Post

                                                                                                            I am experiencing an issue with the "Add a button" feature when creating posts for my Google Business Profile (GBP) through Zoho Social. When I schedule or publish a GBP post and include a call-to-action button with a specific URL, the post itself publishes
                                                                                                          • Do you have software like Windows software?

                                                                                                            We want swadeshi software
                                                                                                          • Support for Custom Fonts in Zoho Recruit Career Site and Candidate Portal

                                                                                                            Dear Zoho Recruit Team, I hope you're doing well. We would like to request the ability to use custom fonts in the Zoho Recruit Career Site and Candidate Portal. Currently only the default fonts (Roboto, Lato, and Montserrat) are available. While these
                                                                                                          • Trying to export a report to Excel via a deluge script

                                                                                                            I have this code from other posts but it gives me an error of improper statement, due to missing ; at end of line or incomplete expression. Tried lots of variations to no avail. openUrl(https://creatorapp.zoho.com/<username>/<app name>/XLSX/#Report:<reportname>,"same
                                                                                                          • Need help to create a attach file api

                                                                                                            https://www.zoho.com/crm/developer/docs/api/v8/upload-attachment.html Please help me to create it... It's not working for while. Do you have some example?
                                                                                                          • Export view via deluge.

                                                                                                            Hi, Is it possible to export a view (as a spreadsheet) via deluge? I would like to be able to export a view as a spreadsheet when a user clicks a button. Thanks     
                                                                                                          • Zoho Inventory's latest shipping integration updates at a glance.

                                                                                                            Hello Users, We would like to share some important news about our latest improvements in the Shipping integration capabilities of Zoho Inventory that we achieved in 2024 with some of our major integration partners in key editions across APAC, North America,
                                                                                                          • Possible to generate/download Quote PDF using REST API?

                                                                                                            See title. Is there any way after a quote has been created to export to a PDF using a specified template and then download it? Seems like something that should be doable. Is this not supported in the API v2.0?
                                                                                                          • Creating an invoice to be paid in two installments?

                                                                                                            Hi there, I own a small Photographic Services business and have not been able to find a way to fit my billing system into Zoho, or any other Accounting software. The way my payments work is: 1. Customer pays 50% of total price of service to secure their
                                                                                                          • Bug in allowing the user to buy out of stock items

                                                                                                            Hi i want to allow the user to buy out of stock items, according to the commerce documentation if i disable Restrict "Out of stock" purchases it will, but it doesnt work, so i want to know if it had any relation with zoho inventory, and if theres any
                                                                                                          • Replace Lookup fields ID value with their actual name and adding inormation from subforms

                                                                                                            Hi everyone,  I wanted to see if someone smarter than me has managed to find any solutions to two problems we have. I will explain both below.  To start we are syncing data from Zoho CRM to Zoho Analytics and I will use the Sales Order module when giving
                                                                                                          • Can a Zoho Sites page be embedded into another website (outside Zoho)

                                                                                                            Hi All, We have a request from a client - they'd like to take one of our information pages created in Zoho Sites and embed it into their own website? I was told through an email with Zoho that this was possible >>Thank you for your patience regarding
                                                                                                          • Bug in allowing the user to buy out of stock items

                                                                                                            Hi i want to allow the user to buy out of stock items, according to the commerce documentation if i disable Restrict "Out of stock" purchases it will, but it doesnt work, so i want to know if it had any relation with zoho inventory, and if theres any
                                                                                                          • Transition Criteria Appearing on Blueprint Transitions

                                                                                                            On Monday, Sept. 8th, the Transition criteria started appearing on our Blueprints when users hover over a Transition button. See image. We contacted Zoho support because it's confusing our users (there's really no reason for them to see it), but we haven't
                                                                                                          • Zoho CRM Sales Targets for Individual Salespeople

                                                                                                            Our organistion has salespeople that are allocated to different regions and have different annual sales targets as a result. I am building an CRM analytics dashboard for the sales team, which will display a target meter for the logged in salesperson.
                                                                                                          • Transfer all Related Data to new Account Owner

                                                                                                            Currently when I change the account Owner I only see the option to change only the open deals But I want the new account owner to take over all the related modules and all the deal stages Is it not possible right now? Am I missing something? Do I really
                                                                                                          • How to Calculate MTTR (Mean Time to Resolve)

                                                                                                            We want to calculate MTTR (Mean Time to Resolve) in our Zoho Analytics report under Tickets. Currently, we are using the following fields: Ticket ID Ticket Created Time Ticket Closed Time Ticket On Hold Time We are planning to calculate MTTR (in days)
                                                                                                          • How to export project tasks, including the comments

                                                                                                            Hi, how can I export the project tasks, whereby I can also see the comments associated to a specific task? The use-case is that often we use comments to discuss or update a task related ideas. I would like to export the tasks, where we can also see the
                                                                                                          • Does Zoho Sheet Supports https://n8n.io ?

                                                                                                            Does Zoho Sheet Supports https://n8n.io ? If not, can we take this as an idea and deploy in future please? Thanks
                                                                                                          • Bigin Android app update: User management

                                                                                                            Hello everyone! In the most recent Bigin Android app update, we have brought in support for the 'Users and Controls' section. You can now manage the users in your organization within the mobile app. There are three tabs in the 'Users and Controls' section:
                                                                                                          • Share records with your customers and let them track their statuses in real time.

                                                                                                            Greetings, I hope everyone is doing well! We're excited to introduce the external sharing feature for pipeline records. This new enhancement enables you to share pipeline records with your customers via a shareable link and thereby track the status of
                                                                                                          • Live webinar: Discover Zoho Show: A complete walkthrough

                                                                                                            Hello everyone, We’re excited to invite you to our upcoming live webinar, Discover Zoho Show: A Complete Walkthrough. Whether you’re just getting started with Show or eager to explore advanced capabilities, this session will show you useful tips and features
                                                                                                          • Deal Stage component/widget/whatever it is... event

                                                                                                            Deal Stages I am trying to access the event and value of this component. I can do it by changing the Stage field but users can also change a Deal Stage via this component and I need to be able to capture both values. Clicking on 'Verbal' for instance,
                                                                                                          • Create advanced slideshows with hybrid reports using Zoho Projects Plus

                                                                                                            Are your quarterly meetings coming up? It’s time to pull up metrics, generate reports, and juggle between slides yet again. While this may be easier for smaller projects, large organizations that run multiple projects may experience the pressure when
                                                                                                          • Add an option to disable ZIA suggestions

                                                                                                            Currently, ZIA in Zoho Inventory automatically provides suggestions, such as sending order confirmation emails. However, there is no way to disable this feature. In our case, orders are automatically created by customers, and we’ve built a custom workflow
                                                                                                          • Formula field with IF statement based on picklist field and string output to copy/paste in multi-line field via function

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

                                                                                                            I signed in to Zoho One this morning and was met with the pop up about the upgraded directory (yay!) I watched the video and pressed "Get Started" ... and it took me back to the standard interface. How do I actually access the new portal/directory ?
                                                                                                          • Zoho CRMの流入元について

                                                                                                            Zoho CRMとZoho formsを連携し、 formsで作成したフォームをサイトに埋め込み運用中です。 UTMパラメータの取得をformsを行い、Zoho CRMの見込み客タブにカスタム項目で反映される状況になっています。 広告に関してはUTMパラメータで取得できているため問題ないのですが、オーガニック流入でフォーム送信の場合も計測したいです。メールやGoogle、Yahoo、directなどの流入元のチャネルが反映されるようにしたいのですが、どのように設定したら良いでしょうか。 また、
                                                                                                          • Error While Sign in on Zoho Work Drive

                                                                                                            Dear Team, I hope this email finds you well. I have recently created a Zoho account and started using it. But while I am trying to log in to Zoho work drive it won't log me in its crashing every time I try it. I have tried it on android app, phone browser
                                                                                                          • Choosing a portal option and the "Unified customer portal"?

                                                                                                            I am trialling Zoho to replace various existing systems, one of which is a customer portal. Our portal allows clients to add and edit bookings, complete forms, manage their subscriptions and edit some CRM info. I am trying to understand how I might best
                                                                                                          • Translation support expanded for Modules, Subforms and Related Lists

                                                                                                            Hello Everyone!   The translation feature enables organizations to translate certain values in their CRM interface into different languages. Previously, the only values that could be translated were picklist values and field names. However, we have extended
                                                                                                          • Unified task view

                                                                                                            Possible to enable the unified task view in Trident, that is currently available in Mail?
                                                                                                          • Bigin, more powerful than ever on iOS 26, iPadOS 26, macOS Tahoe, and watchOS 26.

                                                                                                            Hot on the heels of Apple’s latest OS updates, we’ve rolled out several enhancements and features designed to help you get the most from your Apple devices. Enjoy a refined user experience with smoother navigation and a more content-focused Liquid Glass
                                                                                                          • Importing data into Assets

                                                                                                            So we have a module in Zoho CRM called customers equipments. It links to customers modules, accounts (if needed) and products. I made a sample export and created extra fields in zoho fsm assets module. The import fails. Could not find a matching parent
                                                                                                          • Allow instruction field in Job Sheets

                                                                                                            Hello, I would like to know if it is possible to have an instruction field (multi line text) in a job sheet or if there is a workaround to be able to do it. Currently we are pretty limited in terms of fields in job sheets which makes it a bit of a struggle
                                                                                                          • Streamlining Work Order Automation with Zoho Projects, Writer & WorkDrive

                                                                                                            Hello Community, Here is the first post in 'Integration & Automation' Series. Use Case :: Create, Merge, Sign & Store Documents in Zoho WorkDrive. Scenario :: You have a standard Work Order template created in Zoho Writer. When a task status is chosen
                                                                                                          • The dimensions of multilingual power

                                                                                                            Hola, saludos de Zoho Desk. Bonjour, salutations de Zoho Desk. Hallo, Grüße von Zoho Desk. Ciao, saluti da Zoho Desk. Olá, saudações da Zoho Desk. வணக்கம், Zoho Desk இலிருந்து வாழ்த்துகள். 你好,来自 Zoho Desk 的问候。 مرحباً، تحيات من Zoho Desk. नमस्ते, Zoho
                                                                                                          • Multi-line address lines

                                                                                                            How can I enter and migrate the following 123 state street Suite 2 Into a contact address. For Salesforce imports, a CR between the information works. The ZOHO migration tool just ignores it. Plus, I can't seem to even enter it on the standard entry screen.
                                                                                                          • Next Page