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

                                                                                                          • All new Address Field in Zoho CRM: maintain structured and accurate address inputs

                                                                                                            The address field will be available exclusively for IN DC users. We'll keep you updated on the DC-specific rollout soon. It's currently available for all new sign-ups and for existing Zoho CRM orgs which are in the Professional edition. Latest update
                                                                                                          • Send email template "permission denied to access the api"

                                                                                                            Hello, Per the title, I'm trying to send a Zoho CRM Email template based on the advice given here: https://help.zoho.com/portal/en/community/topic/specify-an-email-template-when-sending-emails-in-custom-functions (I'd prefer to send right from Deluge
                                                                                                          • Zoho Inventory 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
                                                                                                          • Connection to other user

                                                                                                            Zoho Cliq handles sharing of Custom OAuth Connections that require individual user logins.
                                                                                                          • Issue in Annual Leave

                                                                                                            We created a policy to credit 21 days at the Start of the Year An employee has taken 16 days of leaves thought the year, so we expect to see 5 Leaves remaining right? But Zoho People is Showing 12 Days of Leave Balance Available If we check the Leave
                                                                                                          • Missing information data Zoho inventory

                                                                                                            there some missing data in Zoho inventory connection. pick list stock counts bin location we have requested it via mail and the support team doesn’t gove feedback. has anyone achieve to get these info or to ask other ya les
                                                                                                          • In arattai received message can't be deleted

                                                                                                            The issue has been noticed in following: arattai app (Android) arattai app (Window) arattai web While the message posted by me may be deleted, the ones received from others can't be. The item <Delete> change to <Report> when the message is a received
                                                                                                          • Enhance productivity with the revamped Zoho Sheet View

                                                                                                            Hello folks, For some time now, you've been able to use the Zoho Sheet View to quickly edit multiple records or to insert a batch of new records. Its tabular interface allows users to engage in these tasks productively. Despite this, the existing Sheet
                                                                                                          • Analytics Portal

                                                                                                            I have the "standard plan" and want to explore the portal option; I activated the 15-day trial but do not see the pricing for the add-on. How can I get the price under "Upgrade add-ons." Thanks Rudy
                                                                                                          • Can I filter a Lookup field to only show related records from another Lookup in Zoho CRM?

                                                                                                            In our Leads module, we have two Lookup fields: Recruitment Agency – the agency that the lead came from Recruiter – the individual contact from that agency who sent us the lead Both fields link correctly to their respective records in CRM. However, our
                                                                                                          • Zoho Books API invoice email bouncing with 'relaying-issues' error

                                                                                                            I have waited over 30 days for zoho books uk to assist with the following and i have had no replies or tickets erronously closed. The service has been terrible - very unlike zoho! So i am raising this here hoping that a community member can assist: Hello,
                                                                                                          • How do I filter contacts by account parameters?

                                                                                                            Need to filter a contact view according to account parameter, eg account type. Without this filter users are overwhelmed with irrelevant contacts. Workaround is to create a custom 'Contact Type' field but this unbearable duplicity as the information already
                                                                                                          • Zoho Writer to Zoho Sign Template Misalignment – Request for Community

                                                                                                            We are currently facing a critical issue impacting our live business operations due to a misalignment problem between Zoho Writer templates and Zoho Sign output. Issue Summary: We have an automated workflow in Zoho CRM using Deluge scripts that generates
                                                                                                          • Account blocked

                                                                                                            Yesterday I got my Zeptomail account blocked due to too many hard bounces. My account is used exclusively for sending transactional emails (eg. your order has been shipped, a form has been filled, etc) and the sudden blocking impacted hundreds of websites
                                                                                                          • IF Formula

                                                                                                            Hi, I'm having trouble setting up a custom formula in a field. Can you help me with it? The formula should do the following: If the created date is less or equal to 30 days the field should display a string New in pieline or Exisitng pipeline if above
                                                                                                          • View comprehensive logs of all actions in Custom Module History

                                                                                                            Hello everyone, We are happy to announce our new feature, Detail View in Custom Module History, which enhances visibility, control and accountability over your records. Users can now access a detailed timeline of every action that has been performed on
                                                                                                          • Track ZohoForm Conversion using Postmessage event

                                                                                                            Hi, I’ve been using a third-party lead tracking tool to capture leads from my website along with their source. Earlier, with the HubSpot form, the third-party script was able to detect the postMessage event that iframe forms typically send back to the
                                                                                                          • Email task creator when task is updated/marked complete

                                                                                                            I am looking for a way to notify the creator of a task in zoho todo when - Task is updated Task is closed Comments entered 1 and 2 are critical, and I cannot find a zoho flow to do this. There is no way that as a manager I will know when someone has completed
                                                                                                          • Email Recall Feature In Zoho Mail Which Should Also Work For Outside Organisation Members

                                                                                                            Add a feature to recall or undo sending an email within a configurable short time window (e.g., 30 seconds to 2 minutes) after hitting send, similar to Gmail’s undo send. Currently the sent email can not be recall If the recipient is not from within your
                                                                                                          • How to implement calculating average value of averaged values?

                                                                                                            Hi, I'm trying to implement a formula in my layout for a module that calculates the average of 2 averaged values, but I can't do so using the formula custom field. To calculate the 2 averaged values, I could use the formula custom field, but in the custom
                                                                                                          • How to restrict user/portal user change canvas view

                                                                                                            Hi , I would like to restrict user / portal user change their canvas view because I hide some sensitive field for them. I dont want my user switch the canvas view that do not belong to them But seems Zoho do not provide this setting?
                                                                                                          • Zoho Recruit update published job boards

                                                                                                            If we have a job thats already posted on several different job boards and we edit this job in zoho recruit (e.g. the description of the job), does this then automatically update this new information to all the published job boards?  If not, how does the
                                                                                                          • Narrative 14: The magic bazaar of Desk

                                                                                                            Behind the scenes of a successful ticketing system: BTS Series Narrative 14: The magic bazaar of Desk Marketplace is a centralized platform where users can discover Zoho and third-party applications that can be integrated with their Desk account to facilitate
                                                                                                          • Collections Management: #2 Late Payment Automation

                                                                                                            "Sir, I'll process the payment by evening, please don't apply any late payment charges", the customer said while arranging papers on his desk. Sanjay stood there with a tired smile. He had already visited twice that week. Payment collection was one thing.
                                                                                                          • Create a table in the layout section of modules

                                                                                                            Dear Sirs, I would like to know whether is possible to create a table under new fields in layouts section of modules. In fact in this section there are single line, multi line, pick list, multi-select, date, formula etc. but I am unable to add a table
                                                                                                          • Kiosk can't merge picklist or multiselect

                                                                                                            There is no ability to load a multiselect or picklikst field into a kiosk with the values that have been previously selected. So, I essentially have 3 unacceptable options: 1.)Load the value into a text string and include instructions like this: "Picklist
                                                                                                          • Nimble enhancements to WhatsApp for Business integration in Zoho CRM: Enjoy context and clarity in business messaging

                                                                                                            Dear Customers, We hope you're well! WhatsApp for business is a renowned business messaging platform that takes your business closer to your customers; it gives your business the power of personalized outreach. Using the WhatsApp for Business integration
                                                                                                          • Power of Automation :: Automatic Task Status Handling for Users

                                                                                                            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
                                                                                                          • Question - why no way to input a 'tool description' and 'tree of 'tools'

                                                                                                            Every business is different, with different business processes. To be truly useful Zoho MCP needs to have user editable tool descriptions (or ruleset) and a 'tool tree' so that the LLM is context aware when being used. For example, the tool description
                                                                                                          • Develop Zoho Meeting as a Full Native Application (Not a Browser Wrapper)

                                                                                                            Hello Zoho Meeting Team, Hope you are doing well. We would like to suggest an important improvement regarding the Zoho Meeting desktop application. At the moment, the Zoho Meeting app feels more like a mini browser window or an iframe that loads the web
                                                                                                          • Error AS101 when adding new email alias

                                                                                                            Hi, I am trying to add apple@(mydomain).com The error AS101 is shown while I try to add the alias.
                                                                                                          • Suggestion to improve zoho writer

                                                                                                            I am using your product, I believe it is very useful, however, i was writing a note and I needed to draw an arrow in different angles to explain a point and I couldn't. it would be helpful, to add draw functions to the zoho writer. thanks
                                                                                                          • Two factor authentication for helpdesk users

                                                                                                            The company i work for wants use the helpdesk site in Zoho desk, as a place for their distribution partners to ask question and look for information about our product. The things there is suppose to go up there is somewhat confidential between my company
                                                                                                          • I Need Help Verifying Ownership of My Zoho Help Desk on Google Search Console

                                                                                                            I added my Zoho desk portal to Google Search Console, but since i do not have access to the html code of my theme, i could not verify ownership of my portal on Google search console. I want you to help me place the html code given to me from Google search
                                                                                                          • Can I create a custom function for chart of accounts?

                                                                                                            I'm trying to add a custom function that should run whenever a record in the Chart of Accounts module is edited, but on the form for creating a new function, the module dropdown does not include the chart of accounts as an option.
                                                                                                          • billing

                                                                                                            hi, I am being billed $12/year, and I can't remember why. My User ID is 691273115 Thanks for your help, --Kitty Pearl
                                                                                                          • Automatic Matching from Bank Statements / Feeds

                                                                                                            Is it possible to have transactions from a feed or bank statement automatically match when certain criteria are met? My use case, which is pretty broadly applicable, is e-commerce transactions for merchant services accounts (clearing accounts). In these
                                                                                                          • Unable to confirm Super Admin assignment — confirmation button not working

                                                                                                            I’m trying to change the roles within my organization. I am currently a super admin and would like to add another user as a super admin. When I attempt to confirm the action, a screen appears asking for my password to verify my identity. However, when
                                                                                                          • Inactive Items - Make Less Prominent by Default

                                                                                                            Currently, when one marks an Item as "Inactive", it really doesn't do much of anything to hide it or get it out of the way. Search and reporting within Finance should, by default, hide inactive Items from standard reports, searches, etc. If one specifically
                                                                                                          • How to unlink a SAML user from the existing Zoho Desk user (domain change case)

                                                                                                            Hi everyone, I’m trying to understand how to handle a situation where a customer changes their company domain. In our setup, users authenticate via SAML, so when the domain changes, the SAML system treats them as a new user. However, in Zoho Desk, I’d
                                                                                                          • Next Page