Zoho CRM Digest - April 2024

Zoho CRM Digest - April 2024



Welcome to April, the season of blooming trees and blossoming flowers! As nature comes alive, so does our community. Dive into this month's digest to explore vibrant discussions and exciting announcements. 

Zoho CRM product updates:

Email-related enhancements in Accounts and Deals modules in CRM:

  • We're excited to unveil a highly anticipated feature in Zoho CRM: the ability to send emails directly from the accounts module. The email composer in Accounts module now offers quick suggestions for related contacts' email addresses, and makes it possible to access attachments and email templates specific to the Accounts module. Additionally, in the Deals module, email addresses of "contact roles" linked to the deal record will now be provided as quick suggestions. Explore the announcement for more details.

Resolve Conflicts during Deployment in Sandbox:

  • This announcement introduces notable upgrades to Zoho CRM's Sandbox, specifically targeting conflict resolution and some UI enhancements. Users can now swiftly access comprehensive conflict details right from the "Check Dependency page" and resolve issues directly from there. These updates aim to streamline the deployment of sandbox changes to production accounts, tackling common pain points such as missing associated items, duplicate name conflicts, and developer-user association conflicts. For more details, refer to the announcement post.

Introducing Zia Notes Summary: 

  • Introducing Zia Notes Summary, a new feature in Zoho CRM that offers users quick summaries of their CRM notes. This feature is particularly beneficial when navigating through numerous notes or requiring a concise overview of details captured in the notes section. This update provides two summaries: "Overall Summary" for a bird's-eye view of all notes on a record, and "Last Note Summary" for the most recent update. For a deeper dive into the new feature, check this announcement.

Multiple Kanban Views per Module: 

  • Previously, users were limited to one Kanban view per module, necessitating edits for different categorisations. Now, with the latest update, multiple Kanban views are supported, enabling effortless switching between views. The ability to expand and collapse stages in the card view enhances its compactness. Deal stages can be updated swiftly via drag-and-drop functionality, and stage-specific records can be created directly from the Kanban view. Moreover, access permissions can be set to control viewing and editing privileges for each Kanban view. Additionally, pipeline selection will be persisted until the user changes it, an option that was requested by many community members previously[Ref]. Check out this announcement for full details.

Add Tasks to Zoho CRM Calendar: 

  • We're excited to announce that the option to add tasks to the CRM calendar, a much-awaited feature requested by the community, has now been implemented. With this, you get daily and weekly views of CRM tasks in the Calendar, allowing you to easily keep track of your tasks right alongside your meetings and calls. Additionally, you can switch between single and multi-user views to manage tasks effectively and, create tasks directly from the calendar. For more details and resources related to this release, check out this Idea post.

Useful Discussions: 

  • @Felipe Salomão de Sousa Vale wanted to auto-format the phone numbers by removing special characters and spaces, including the country code if not present, and prefixing phone numbers with only 11 digits with the  "+" symbol. @Bhoomi Joshi and @Rodger Brehau provided the required suggestions for formatting the phone numbers using Functions. Check the post to learn more. 

Sales duo performance tracking:

  • @Bas van den Berk brought up an interesting sales report requirement. Every prospect is assigned to a pair of consultants. They wanted to add a matrix-like component to their dashboard to track the performance of sales duos based on the number of clients they have successfully closed, and to visualize the data to quickly identify the most successful duos. @Anonymous User suggested using a "Heat map" chart as it makes it easy to identify the top performing sales-duos at a glance. Discover the details in this post.

Multi-product purchase tracking at the Account level: 

  • @Ashley was reviewing an old post on tracking multiple product purchases by the same Account. While a Subform based solution was already suggested, @Max Tyack proposed an alternative approach using a custom module and lookup fields, which Ashley welcomed. Max also confirmed that Ashely's additional requirement for auto-updating prices across records can be achieved with either approaches using Workflows and Functions. Check out @Max Tyack's response in this post for further details.

Functions:

  • @Alejandro wanted to automatically capitalize the first letter of each word in a contact's information for all fields, regardless of how users enter it. @Rodger Brehaut shared the Deluge code to be associated with a workflow, which runs when the record is edited. Check this post for the code.

Execute Function only for select deal stages:

  • @Chris wanted to run a Function based on a deal's stage and needed to know how to best exclude select deals stages. @Hugh Marshall and @Bhoomi Joshi came up with different approaches to solve the same need, each, creating a list of stages to avoid and validating if the active deal is is not on that stage list. Check the code they shared in this post.

Automating Quote Management: 

  • @Coen | Heative mentioned that their sales process involves sending multiple quotes to customers, with only one being accepted. Once a quote is marked as "Won", they would like the other related quotes for the contact record to be automatically updated to "Lost". Check the solution proposed by @Ishwarya in this post, which includes a code snippet to be associated with a workflow to meet this requirement.

UpdateRecord Success

  • @David Shaw uses an updateRecord call in a Function, triggered by a clicking a button, and wanted to check whether the response indicates a success or failure. They provided a simple code for this requirement, with @Bhoomi Joshi and @Anonymous User making the necessary tweaks to get it to work. Check this post for the working code.

Auto-updation of deal stage:

  • @Benjamin wanted to update the deal stage to "Scheduled" automatically whenever a new meeting is added to a deal record in Zoho CRM. @Anonymous User shared theFunction code to achieve this. Check this post for the code.

Optimize CRM storage by automatically moving or deleting attachments:

  • @Anthony observed that their users were adding multiple attachments to a custom module, which significantly increased the CRM storage usage. They were looking for a way to automatically delete attachments or move them to Zoho WorkDrive when a field's status is set to certain criteria. Check out the solution posted by @Hugh Marshall, complete with code, in this post to achieve this.

Calling Functions linked to a Workflow: 

  • @David wanted to know if there's an efficient way to call a Function running within a Workflow from another similar Function without exposing the first Function via API. @Nicolas Donoso provided the solution: call the first Function using the automation namespace in the code. Check this post for the solution and sample code.

Dev's Corner:

  • @Felipe wanted to show an alert during the deal creation stage if a specific field is duplicated, without blocking the deal creation process. @Hugh Marshall suggested using Client Script, and @Anonymous User provided a detailed explanation including sample Client Script code, to prompt users about duplicates while allowing them to proceed and save if needed. Check this post for the solution. 

Real-time Dropdown popup for CRM field update during deal Creation: 

  • @Javier Molina wanted to open a popup with a dropdown list for users to select an option and pass it to a CRM field in real-time during deal creation. Check this post for Subash Kumar's Client Script code that fulfils this requirement.

Best practices for handling large record sets:

  • @David sought best practices for handling large record sets, especially when iterating over more than 200 records at once. Multiple community members shared their solutions, with @Kiruthiga recommending the use of the COQL API to determine the total record count. Additionally, she provided helpful tips and sample code for effectively handling large data sets. Jump into the post for detailed answers. 

Filtering recent calls by date and time: 

  • @Paul de Geode encountered difficulties retrieving calls made in the last week, particularly in filtering records by date and time using the V2 API. @Christoph Wenzel and others offered workarounds, recommending either the use of V6 API or COQL to address the issue. For more details, check out this post.

Naming variables in Deluge scripting:

  • Big shout out to @Rodger Brehaut for sharing invaluable insights on naming conventions for variables in Deluge scripting based on their type! Rodger suggests opting for descriptive names over generic ones like "response," making future code easier to understand and work with. Read this post to learn more. 

Kaizen: 

  • This post discusses self-client and server-based clients in Zoho CRM. Check out this post for videos and detailed explanations, along with suggestions for further reading to see how they're applied using Java SDKs.

Kaizen #134 - Manipulating Rich Text Field (RTF) using Zoho CRM APIs: 

  • Want to understand the ins and outs of working with Rich Text Field (RTF) and how to manipulate RTF using Zoho CRM APIs? Look no further than this post.


Thanks 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 included in the upcoming month's digest. Have a wonderful month ahead!


    • Sticky Posts

    • How to reach the official Zoho Support channels and avoid fake ones.

      Dear Customers, Thanks a lot for choosing Zoho! Our applications are built to help achieve your day-to-day business goals. We are committed to engaging with you, to understand and develop solutions that enhance your productivity.  We are happy and ready to help you use our services effectively. Understanding and avoiding fake support Just like using popular bank names and financial applications for phishing purposes, using Zoho and claiming to be providing Zoho Support or services with false numbers
    • Function #35: Close all tasks associated with a lead and create a new task.

      Welcome back everyone! Last week, we learnt how to close all tasks of a deal depending upon the deal stage. This week, let's look at a custom function that lets you close all of the tasks associated with a lead while simultaneously creating a new task, like when you need to halt all progress towards a lead while the lead is not available at the moment but create a reminder task. Business scenario: The success of a company, in one way or another, is determined by the leads it gets. Each lead is just
    • Zoho CRM Webinar - Redesigning Daily User Experiences with Canvas

      <br> Your users across roles use the CRM for day-to-day tasks that are necessary. Whether they perform their tasks on time, the right way, or at all depends on a lot of factors, including User Experience. Many businesses struggle with rigid layouts,
    • Join us at the Canada ZUG Meetup: What’s New in Zoho CRM

      Hello Zoho Community! Start your year with fresh insights into Zoho CRM’s latest updates and tools. Whether you're a CRM beginner or a experienced user, this meetup is crafted to help you optimise your processes and leverage new features. Explore practical
    • CRM Hack #2: Automate sending of birthday greetings to your customers.

        Hello everyone! What sets you apart as a sales person is your ability to add that personal touch to your business relationship with your customers. Sending a gift on a special day, or leaving a note wishing them on their birthdays, are small, yet significant actions that show your customers that you care. And these are actions done without any expectations :) You must be engaging with a lot of customers and it is highly unlikely that they all are your friends on Facebook or some social channel,
    • Recent Topics

    • ZoHo Flow Custom Function not Processing JSON

      JSON is being escaped and converting all the quotes in the JSON to '"' Here's the Code: void InsertRowInE123EligibitySheet(map input) { rawData = get("data",""); decodedData = rawData.htmlDecode(); data = decodedData.toMap(); sheet_id = "ID GOES
    • Managing functions

      Can someone let me know if there are any plans to improve the features for managing functions in CRM? I have lots of functions and finding them is hard. The search only works on the function name and the filter only works on function type. I have created
    • Zoho FSM - Service Appointment Trouble Adding Field Agent

      Hello, I just started using Zoho FSM and I'm currently adding older work orders from prior Field Service application I use. The work order that im trying to add is from an earlier date, and when I try to add a field agent to a service appointment it does
    • 年内最後のユーザー向けイベント:5名限定! 課題解決型ワークショップイベント Zoho ワークアウト開催のお知らせ (12/18)

      ユーザーの皆さま、こんにちは。コミュニティチームの中野です。 12月開催のZoho ワークアウトについてお知らせします。 今回はZoomにて、オンライン開催します。 参加登録はこちら(無料) https://us02web.zoom.us/meeting/register/QHn6kJAcRs-znJ1l5jk0ww ━━━━━━━━━━━━━━━━━━━━━━━━ Zoho ワークアウトとは? Zoho ユーザー同士で交流しながら、サービスに関する疑問や不明点の解消を目的とした「Zoho ワークアウト」を開催します。
    • How do I get my account id?

      Hello, I followed the instructions to get a list of accounts of the currently authenticated user (which is me, and I am logged in). But when I follow the below instructions I get the following error: ERROR: {"data":{"errorCode":"INVALID_TICKET","moreInfo":"Invalid ticket"},"status":{"code":400,"description":"Invalid Input"}} Instructions that I am following: GET - User account details Purpose The API retrieves the list of accounts of the currently authenticated user.  Request URL  http://mail.zoho.com/api/accounts
    • This domain is not allowed to add. Please contact support-as@zohocorp.com for further details

      I am trying to setup the free version of Zoho Mail. When I tried to add my domain, theselfreunion.com I got the error message that is the subject of this Topic. I've read your other community forum topics, and this is NOT a free domain. So what is the
    • Zoho Quartz Screen Recording

      Hello, can we get access to Quartz, please, as a standalone solution? It would be great for creating training videos for current and future staff on how to use Zoho software according to our company requirements. Thank you
    • auto close automated alert tickets which are similar

      Hello ZOHO Community, we are using ZOHO Desk to process automated monitoring alerts. Scenario: Our monitoring system creates a ticket when a threshold is exceeded, e.g. Subject: Computer 1 – CPU usage 100% – Error A few minutes later, once the issue resolves
    • Maintain knowledge base integrity by moderating article comments

      Hello everyone, A knowledge base provides a self-service platform where customers can refer to articles, user manuals, and other resources to learn about the company's products or services and troubleshoot problems. Often, readers leave a comment on the
    • Making another calendar your default calendar

      I am trying to make another calendar my default calendar when I add events to it. It keep going to a single calendar, I need it to go to my google calendar by default, as this is linked to other services / websites. I cannot find an option to make it
    • Option to Delete Chats in IM

      Currently, there is no option to delete any chats in IM, regardless of their source.
    • Referencing a cell from another sheet

      My workbook has multiple sheets. Each sheet has some calcluated totals in certain cells. The front master sheet has a list of everything that is detailed on the other sheets, with the totals. These could change at any time, so the totals need to be references to the other cell's value, not a fixed number. So on the master sheet, I put in =, then go the other sheet and choose the cell and hit Enter. In regular Excel, this works. But in the Zoho sheet, it doesn't work. I have to edit the result by
    • Group mail for external email addresses

      Hello, I was just wondering if the Group mail feature works with external email addresses - e.g. gmail.com or a completely different domain? it seems only internal addresses (hosted with Zoho) receive the mail. Thanks, Oliver
    • The email address you have entered belongs to a different deployment/region.

      Hi, I am trying to create the user - mprust@crombiecomputers.co.uk but keep getting the message below -  The email address you have entered belongs to a different deployment/region. Please contact support@zohoaccounts.com for assistance. Look forward
    • Use Zoho Flow Credits for CRM ‘Actions by Zoho Flow’

      Hello Team, We would like to submit a feature request regarding credit usage for “Actions by Zoho Flow” in Zoho CRM. Use Case: We are Zoho One users and actively use Zoho Flow, where our organization has 52,000 Flow tasks per month. In Zoho CRM, we use
    • Unusual activity detected from this IP. Please try again after some time.

      Hello Zoho admin and IT team We are a registered website in Eloctronic services and we been trying to add our users to the zoho system but this issue faced us ,, hope you unlocked us please.
    • Alert if a field is ticked.

      Hi There, We have two modules named Opportunities (Deals) and End Users (CustomModule1), as per the image below. Within Opportunities, we have a lookup field that looks up from the End Users Module. We are looking to get an alert either via email or another
    • Zoho CRM Analytics - Allow To Reorder Dashboards

      I would like to suggest that you add the ability to reorder dashboards in the Analytics Module. I can see that this has been requested some time ago, the latest 9 years ago. I am not sure if this is a big or small endeavor, but such a small fix can go
    • Sending a Template to Sign

      hi, trying to send a template to be signed using this as a test: $accessToken = "1000.xxx" $templateId = "1234" $uri = "https://sign.zoho.eu/api/v1/templates/$templateId/createdocument" $payload = @{ templates = @( @{ template_id = $templateId request_name
    • Adding Choices in a Sub-Form Dropdown

      Hi, Has anybody tried Adding Choices to a Dropdown in a Zoho Creator Sub-Form programmatically? My Deluge code adds rows to a subform with 2 fields A and B. A - text field. B - dropdown. My Deluge script adds the row and displays A successfully. For the
    • Zoho CRM Email Templates 100% Width No Background How?

      Hi, On the Zoho CRM Email Templates in setup > customization > templates > new templates > I choose blank template, but still it puts in a gray background and a max width for the email. I just want to make an email that looks like an email I would send from gmail that has no background or max width. How do you do this? 
    • Checking client unsubscribe details

      Hi team, Can you please let me know where we can check if a client has unsubscribed, along with the date and time it was done? If this information is not available at our end, please help confirm the unsubscribe date for the below email ID from the backend:
    • Optimum CRM setup for new B2B business

      Can some advise the most common way to setup Zoho CRM to handle sales for a B2B company? Specifically in how to handle inbound/outbound emails. I have spent hours researching online and can't seem to find an accepted approach, or even a tutorial. I have
    • Scan and Fill CRM Lookup Field

      Not sure if there is a reason why this isn't possible or if I'm just missing it. But I would like to be able to use the scan and fill feature on the mobile app to prefill the CRM lookup field and fetch the rest of the data in the form.
    • Customer Management: #2 Organize Customers to Enhance Efficiency

      When Ankit started his digital services firm, things felt simple. A client would call, ask for a website or a one-time consultation, Ankit would send an invoice, get paid, and move on. "Just one client, one invoice. Easy.", he thought. Fast forward a
    • Zoho Mail and Zoho Flow integration to automatically create ToDo tasks from outbound emails

      How do i setup Zoho Mail and Zoho Flow integration to automatically create ToDo tasks from outbound emails
    • Attachments between Zoho and Clickup, using Flow.

      Olá suporte Flow, tudo bem ? Estamos usando o flow para integrar Zoho Desk com o clickup. Não localizamos a opção de integrar anexos entre do zoho Desk para o clickup. Gostaríamos de saber se migrando para o plano pago, teremos suporte para fazer a integração
    • Adding an Account on Zoho Mail Trigger in Zoho Flow

      I'm trying to create a flow using the zoho mail trigger "Email Receive". My problem is that when I select this trigger, it only shows one account from the account dropdown. I'm planning to assign it on a different email. How can I add other email ad
    • Linnworks

      Unless I am missing something, the Linnworks integration is very basic and limited. I have reached out to support but the first response was completely useless and trying to get a reply in a timely manner is very difficult. Surely I should be able to
    • Test data won't load

      I am using a Flow to receive orders from WooCommerce and add them to a Zoho Creator app. I recently received an order which failed, and when attempting to test the order I found that it just shows a loading animation and shows up in the history as "queued."
    • AddHour resets the time to 00:00:00 before adding the hour.

      Based on the documentation here: https://www.zoho.com/deluge/help/functions/datetime/addhour.html Here's my custom function: string ConvertDateFormat(string inputDate) { // Extract only the date-time part (before the timezone) dateTimePart = inputDate.subString(0,19);
    • WhatsApp Link is not integrating

      Hello, I am using zoho flow. when new row added in google sheet it sends email to respected person. In email body I have a text "Share via WhatsApp". behind this text I putted a link. But when the recipient receives email and wants to share my given info
    • Zoho flow - Webhook

      If I choose an app as a trigger in Zoho Flow, is it still possible to add a webhook later in the same flow?
    • Zoho Flow + Bigin + Shopify

      We are testing Zoho Flow for the first time and want to create a flow based in first purchases. When a client makes his first order, we're going to add the "primeiracompra" (first order) tag to his account in Shopify (it's not efficient, but that's the
    • Is it The Flow? Or is it me?

      I want to do some basic level stuff, take two fields from a webhook, create a zsheet from a template using one field with date appended, create a folder using both fields as the name, and put the zsheet into that folder. I was going to elaborate - but
    • Having problem with data transferring from Google sheet to ZMA

      When connecting Google sheet with Zoho marketing automation it is having the email as a mandatory field. Can I change it as non-mandatory field or is there any other way to trasnfer data from google sheet to ZMA. I have leads which we get from whatsapp,
    • Dropbox to Workdrive synchronisation

      I want to get all the files and folders from Dropbox to Workdrive and each time a new file or folder is added in dropbox i want it to be available in Workdrive and wise versa. Sync Updates to Files Trigger: "File updated" (Dropbox). Action: "Upload file"
    • Microsoft Planner Task to Service Desk Plus Request - error n4001

      Hi there. I'm trying to create a flow that will create a new request in ServiceDesk Plus when a new task is created in Microsoft Planner. I have succesfully connected both Planner and ServiceDesk Plus, and have configured the 'create request' section
    • Trailing Space in "Date and time scheduled "

      I am trying to use the Zoho Projects - Create event action in a flow. It is failing with the output error as: "Action did not execute successfully due to an unknown error. Contact support for more details." The input is: { "Duration - Minutes": 30, "Project":
    • Project name by deal name; project creation via flow

      Hello, I want to create a project in zoho projects using flow by a trigger at the crm. My trigger is the update of a deal (stage). The project name should be the account name/ deal name. But I dont find the solution to it. Can you please give me the answer
    • Next Page