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

                                                                                                          • Send mass messages through WhatsApp from the Tickets module

                                                                                                            Hi Everyone! Effective communication is key to delivering prompt and reliable customer support. Because WhatsApp is one of the most widely used and familiar messaging platforms, it's an effective channel for agents to reach customers who have submitted
                                                                                                          • Lead Owner Signature Merge Field

                                                                                                            I want to automatically insert a signature (i.e. contact info usually found at the bottom of an email) into an email template, depending on who the lead owner is. What is the merge code for the Signature from a Users profile? CRM > Settings > Customization > Templates There is a popup near the bottom of the edit screen which says: "You can insert a Signature, which is available as a merge field in the users section." It is also referenced on this page: https://help.zoho.com/portal/en/kb/crm/customize-crm-account/customizing-templates/articles/template-builder#Merge_Fields
                                                                                                          • How do I create a time field?

                                                                                                            I want a field that only records time. I can only see how to create a date-time field. If I do that and enter a time, without a date, nothing is recorded. If I create a number or decimal field, I cannot use it in time calculations. All I want is a field
                                                                                                          • Alternating columns - How to reverse order on mobile - Responsive template

                                                                                                            Can the order of alternating columns be reversed on mobile so that image comes before the text? Example: Desktop Row 1 column Left (image) , column right (text) Row 2 column Left (text) , column right (image) Mobile Currently Row 1 Image over text Row
                                                                                                          • InvokeURL butchering JSON for OpenAI API calls

                                                                                                            My organization works with mostly educational institutions. We have a custom module called "Schools", which is the user-entered school name they put when using our service (which they enter along with their state and zip code). We want to map this to
                                                                                                          • Custom order for Current Stage (Blueprint field)

                                                                                                            Hi! I suggest adding the option to set a custom order in reports for the Blueprint field ‘Current Stage’. Currently, these fields can only be sorted in ascending or descending order. Thanks!
                                                                                                          • CRM E-mail Sync from Outlook

                                                                                                            We are exploring Zoho as a possible new solution for our company. We are trying to understand further on how e-mail sync works. We use outlook. Our current CRM logs anytime we e-mail a customer so we can see in the CRM the message sent to the customer.
                                                                                                          • Run your help desk on your schedule

                                                                                                            In business, time is of the essence. This is especially true in a function like customer service, where KPIs such as response time and agent availability are the measures of success. Perhaps the most crucial consideration one needs to make about time is your hours of operation. These set expectations for your customer and for employees. To make communicating this information easier, we've revamped the way business hours and holiday lists work in Zoho Desk.   In order to accommodate teams that work
                                                                                                          • The Customer Happiness REST API is broken

                                                                                                            1. We are unable to extract the customerHappiness ( https://desk.zoho.com/DeskAPIDocument#CustomerHappiness#CustomerHappiness_ListallcustomerHappiness) object using the ticketNumber criteria. We keep getting HTTP 429 even when we limit to 60 calls per
                                                                                                          • Automatic Department and Employee Sync Between Zoho One and Zoho People

                                                                                                            Dear Zoho Support, I'm writing to propose a valuable feature request that would streamline data management and improve user experience within the Zoho ecosystem: automatic synchronization between departments and employees in Zoho One and Zoho People.
                                                                                                          • Zoho Expense and Chase Bank Visa credit cards - Direct Feed?

                                                                                                            Our company uses JP Morgan Chase Visa credit cards. We can't be the first to try and use a combination of Zoho Expense + Chase Bank + Visa Credit Cards --- anyone successful with this combination? 1. The direct feed automation isn't working. When I go
                                                                                                          • Impossibile inviare il messaggio;Motivo:554 5.1.8 Indirizzo del mittente bloccato

                                                                                                            " Impossibile inviare il messaggio;Motivo:554 5.1.8 Indirizzo del mittente bloccato" Hi need to send email, how can fix this? Thanks, Alice
                                                                                                          • Image inputed in Zoho Form were displayed to small in exported version

                                                                                                            Good evening, my name is athallah, i am a trainee in government office Right now, i use Zoho form to digitalize an airfield monitoring form. my problem is, the image were to small to displayed in exported version. it really bad for formal presentation
                                                                                                          • API. How do I get responses submitted to the form?

                                                                                                            Hi, I'm trying to retrieve a list of form responses via the API. I've created a Self Client application in API Console. What scoup should I enter? What are the endpoints? Is there documentation on this anywhere? I've wasted a lot of time searching. GPT
                                                                                                          • Question about Zoho CRM Professional plan users

                                                                                                            Hello! I have a question about the Zoho CRM Professional plan. Is the pricing charged per user or per organization? Are there any free users included in this plan, or do I need to pay for each additional user separately? Thank you!
                                                                                                          • Communicating with emojis

                                                                                                            On July 17, we celebrate World Emoji Day! We're a bit late 😐 sharing insights about this day. But we just couldn't let it pass without a mention 😊 because emojis have a meaningful connection with customer service 💬 🤝. We do not want to miss out on
                                                                                                          • Changing the Default Search Criteria for Finding Duplicates

                                                                                                            Hey everyone, is it possible to adjust the default search criteria for finding and merging duplicate records? Right now, CRM uses some (in my opinion nonsensical) fields as search criteria for duplicate records which do nothing except dilute the results.
                                                                                                          • Help integrating Aircall into Zoho CRM

                                                                                                            Hi all, We are need to get better AirCall integration into Zoho. We have configured in the Aircall dashboard but we have not done the Zoho side. We cannot see Zoho CRM information on incoming calls. And we calls and text's are not being logged. Specifically
                                                                                                          • Shopify Extension no longer working in CRM

                                                                                                            Zoho CRM and Extension are no longer working properly. We have used Shopify Basic for years. All of the sudden it stopped working, then started working again, and now no longer working again. There are several ways for Personal Information to sync from
                                                                                                          • How to keep track of bags, cans, drums of inventory?

                                                                                                            We buy and sell products that are packaged in bags 🛍️, cans🥫, drums🛢️, etc. with batch numbers. When we get a shipment of one of the products, how do we track we received (say) 10 cans each of 5L of a product and maybe we received 10 cans of another
                                                                                                          • Easy third party collaboration: Zoho Flow Integration

                                                                                                            Third-party integrations extend your project functionality with improved workflow, and data processing. With Zoho Flow integration you can include multiple third party actions into your project or task automation. Add Zoho Flow action in Workflow rules
                                                                                                          • Introducing Configure, Price, Quote (CPQ) in Zoho CRM | Public early access 2023

                                                                                                            Greetings Customers! We're excited to announce that the CPQ feature will soon be available in Zoho CRM and accessible to all accounts using the Professional, Enterprise, and Ultimate editions. We've opened this feature to select customers, and it'll be
                                                                                                          • how to edit the converted lead records?

                                                                                                            so I can fetch the converted leads records using API (COQL), using this endpoint https://www.zohoapis.com/crm/v5/coql and using COQL filter Converted__s=true for some reasons I need to change the value from a field in a converted lead record. When I try
                                                                                                          • Share Video Response Card ion Zobot

                                                                                                            I am using the zobot codeless bot builder in SalesIQ. I want to share a video but delay the next response card until after the video has finished playing or has been stopped. Is this possible?
                                                                                                          • Zoho Bookings <> CRM integration

                                                                                                            Hello Zoho community! We are enabling our Zoho Bookings <> CRM integration. What is the workflow if the integration detects that the contact already exists in the CRM? Does it create a duplicate record? Overwrite the record? Merge the record? (in this
                                                                                                          • Cannot reject empty expense report

                                                                                                            Hello, We are currently having issues with two empty expense reports where if we try to reject them, either manually or through the REST API, we get error 114016, which says some of the expenses have already been billed and must be removed. I'd appreciate
                                                                                                          • Use of Zia within Forms

                                                                                                            I have noticed that recently you have added Zia to help create forms from scratch. Would it be possible to add Zia functionality to free text fields for form submissions or if this is already on the roadmap an ETA for this please? We have a lot of field
                                                                                                          • Default in fields on Form B based on the user selection in Form A

                                                                                                            Hi Everyone, I have added an action button to a form report to bring up a new form based on user selection, see it indicated in red below: Then when the ne form loads, I want to default in some of the fields based on the record the user was selected on.
                                                                                                          • Auto-sync field of lookup value

                                                                                                            This feature has been requested many times in the discussion Field of Lookup Announcement and this post aims to track it separately. At the moment the value of a 'field of lookup' is a snapshot but once the parent lookup field is updated the values diverge.
                                                                                                          • Last activity time is acting like last modified time

                                                                                                            When i edit the description or any field in the potential, account, contact and lead, the Last Activity Time is being updated like the Modified Time. This is messing all workflows and reports and we are unable to track real last time of activities like
                                                                                                          • Enhancements to the formula field in Zoho CRM: Auto-refresh formulas with the "Now" function, stop formula executions based on criteria, and include formulas within formulas

                                                                                                            Dear Customers, We hope you're well! By their nature, modern businesses rely every day on computations, whether it's to calculate the price of a product, assess ROI, evaluate the lifetime value of a customer, or even determine the age of a record. With
                                                                                                          • HEX/RGB Color Input in Visual Editor

                                                                                                            Hello Zoho Pagesense Team, We hope you're doing well. We’d like to submit a feature request to improve the color selection options in the Pagesense popup editor. Current Limitation: Currently, to set text colors, users must move the color slider manually.
                                                                                                          • CRM and Campaigns- tags not integrating?

                                                                                                            Hi! I am setting up an automation in zoho campaigns and it says the crm is integrated...but when I want to use a trigger of a certain tag I created for people in the crm to denote those who purchased, it doesnt have that tag available as an option in
                                                                                                          • Maximum limit of rows exceeded

                                                                                                            I am trying to add a row to a spreadsheets that has fewer than 60 rows. I keep getting an error message that says I have exceeded the maximum limit of 65,536 rows. Any ideas out there?
                                                                                                          • Can't change form's original name in URL

                                                                                                            Hi all, I have been duplicating + editing forms for jobs regarding the same department to maintain formatting + styling. The issue I've not run into is because I've duplicated it from an existing form, the URL doesn't seem to want to update with the new
                                                                                                          • Tip #7: 5 formas de mantener tus listas de correo electrónico

                                                                                                            Tips and Tricks #7, adaptado de Susmit Sen ¡Hola, comunidad! Esta semana volvemos con nuestros Tips and Tricks para Zoho Campaigns. En esta ocasión, voy a darte algunos consejos para mantener limpias tus listas de correo electrónico, y empezar el 2021
                                                                                                          • Mail Merge related Lists

                                                                                                            When I try to merge an associated list the fields do not have a checkbox to choose them as it does in the tutorials. Am I missing something? Any ideas would be appreciated.
                                                                                                          • create-a-purchase-receive API issues

                                                                                                            Hello all, I'm trying to use the create a purchase receive inventory API documented here (https://www.zoho.com/inventory/api/v1/purchasereceives/#create-a-purchase-receive) however when I do am getting the following error {"code":9,"message":"The purchase
                                                                                                          • Zoho Pagesense really this slow??? 5s delay...

                                                                                                            I put the pagesense on my website (hosted by webflow and fast) and it caused a 5s delay to load. do other people face similar delays?
                                                                                                          • Heatmap: Missing Content Elements - Zoho Page Sense

                                                                                                            Hi there, I'm trying out Zoho Page Sense to generate heatmaps for my Wix pages. My problem: Some parts of my Wix pages don't show on my heatmap, the heatmap is just empty there. Maybe Wix default lazy loading setting causes this error? Is there a way
                                                                                                          • Next Page