Zoho CRM Community Digest

Zoho CRM Community Digest





We're thrilled to bring you the February digest, packed with exciting product updates and engaging discussions from the Zoho CRM Community. Keep reading to stay in the loop!


Product Updates:  

Zia Enhancements


Be it Tasks, Calls, or Meetings, Zia's activity extraction from emails now supports capturing multiple activity instances contextually. Previously, only one activity–typically the first cited instance–could be captured from an email, despite containing multiple activity-related contexts in the email content. Start leveraging this feature to enhance your CRM record-keeping and streamline follow-up processes. 

This is just one of the many enhancements that got released as a part of this update. Check-out this announcement post for more.

Enhancements in Webforms


Our recent updates to the webform feature eliminate the need for dedicated landing pages to host your webforms. This makes it easy to share forms through multiple avenues and collect submissions with ease.  Additionally, you can now create QR codes and short URLs for the webforms, making them more accessible. Furthermore, we've introduced customizable options upon form submission, allowing to either redirect to a custom URL, display a splash message, or take them to a Thank you page. Want to learn more? Check out this announcement post for all the details! 

Custom Fiscal Year


You can now customize your CRM's fiscal year to follow the 4-5-4 calendar and other popular 52-week formats. This change allows businesses to align their fiscal year with specific needs, such as seasonal sales patterns or auditing requirements. Learn more about these custom fiscal year formats and how to implement them in this post.


Bottom-up model in Forecasts

Now in Zoho CRM, you can choose between two forecasting models: top-down and bottom-up. While the top-down model was the only option before, the new bottom-up model allows users to submit targets based on their unique insights, which can then be iterated if needed and approved by the managers. To learn more and access detailed instructions, check out this post.


(VoC) Feature Now Open to All

Voice of the Customer (VoC), a feature that offers deep insights into customer feedback from various sources like emails, surveys, social media, and more, is now available to all users. New enhancements include custom dashboards for tailored insights, filtering out spam email IDs for better analysis, including data from notes and social media channels, and using VoC for automation. Learn more about these updates from our announcement post.

Useful Discussions: 

  • @Ludovic M was looking to create a custom email template with individual components, each of which bundles multiple sub-components. Explore the solution shared by @Ishwarya, complete with a GIF, in this post. 

  • @Toni's business process involves installation, and they wanted to create a ticket in Zoho Desk whenever a lead is converted. This ticket is created to send installation instructions and provide guidance on how to seek further assistance when needed. Learn how to achieve this requirement using 'Actions by Zoho Flow' in this post. 

  • @Paul Ferrall wanted to create a report capturing the total value of deals closing per quarter, extending to the upcoming 4 quarters. Check @Ishwarya's suggestion on creating a report with Deals as the primary module, grouped by calendar or fiscal quarter, in this insightful post. 

  • @Pratik sought to import meeting records, and as promised, we've `rolled out support for .CSVand .XLSX file imports. Explore this post for details.

  • @Soeren wanted to measure conversion ratios between different lead stages in their business process. Explore @Linga Siva P's detailed suggestion on creating two funnel charts with underlying reports, capturing conversion ratios for the current and preceding weeks, in this post.

  • Is your organization utilizing Microsoft SharePoint for document management? With Microsoft SharePoint handling your document organization and Zoho CRM managing your business operations, there is a need to access data from both platforms in one centralized location. Try out the SharePoint for Zoho CRM extension from Zoho Marketplace. To learn more about this integration, check out this post.


Functions:

  • @Soeren wanted to create a Deluge function that reads the status of an Account's Related List items. The function should add a tag to the Account's pre-existing tags based on those statuses and remove all the tags for a specific status. Two working solutions, following different approaches, have been provided by @Haiku and @Andrés, respectively. Explore this post for the code and related insights. 
  • @Rich Purseglove's use-case revolves around property enquiries, where they've created a Blueprint to streamline their team's validation process for scheduling viewings, and sending appointment confirmation emails. This Blueprint must also facilitate the creation of Meeting records, accommodating both physical and virtual appointments based on client preferences. However, encountering technical limitations in setting up virtual meetings via Blueprints, @Nik proposed a solution involving Functions, sharing code and guiding through iterative improvements.Check this post to for the code and insightful conversations. 

  • @think sought assistance in creating a function to retrieve the created and modified times from a lead ID, calculate the time gap, and update a custom field accordingly. However, the initial version of the script was not working as expected. With support from @Haiku Technical Support and @Sunderjan Siddharth, they iterated and refined the Function to find the solution. Check this post for the final corrected code. 


Dev's Corner:

  • @Kurt found the COQL APIs extremely useful. While revisiting an older post where @Praveen Sankar recommended using COQL APIs to fetch the user IDs based on roles, @Kurt shared additional insights on COQL APIs for those who may not be familiar with them. Check @Kurt's insightful comment in this post.
  • Let's extend our heartfelt thanks to @Vigneshwaran K for complementing the Kaizen post on updating related records upon parent record deletion by sharing a lengthy script that automates the process of updating multiple related lists when editing a single record. Check @Vigneshwaran K's comment in this post for the code. 
  • Check the comments by @Piyush Goyal in this post to find out how he used an SQL query through the Zoho CRM API to overcome the limitations of having to rename fields with parentheses while using searchRecords API.
  • @Kava Li inquired about updating an image upload field via API in a CRM module. @Sunderjan Siddharth shared a sample code, along with advice on replacing field names and connection links to achieve it. Check out this post for more details.
  • @Mehrdad Naserdoust wanted to create a global function in client script usable across different client script events and modules. @Kevin Flynn recommended using static resources, where functions can be written and stored for easy access and use, and shared a reference video from the Zoho Developer Hangout. Check out this post for more details. 

Kaizen: 

  • (Kaizen #123) - In this post, we'll learn how to synchronize data from a third-party app to Zoho CRM. We'll explore the APIs available in Zoho CRM to insert, update, or upsert records, as well as the Bulk Write API for larger operations. If you want to learn more about these APIs and how they perform in different scenarios, check out our detailed post here. 
  • (Kiazen #124) - In this post, we'll explore using Zoho CRM APIs to manipulate Subform data. For a detailed guide on using Subforms in Zoho CRM, including API methods and data retrieval techniques, check out our full post here.
  • (Kiazen #125) - In this Kaizen post, we'll explore manipulating multi-select lookup fields using Zoho CRM APIs. You'll learn how to establish many-to-many relationships with modules, like associating multiple skills with an employee. Check out the full details and API examples here. 


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!


    • Recent Topics

    • Getting error "invalid warehouse_id" when trying to update any transaction in Zoho books

      I got a message from Zoho saying that the Warehouse and Branch has been merged into one category "Locations" Once I migrated to this setup I was no longer able to edit any invoice / create creadit notes - got an error saying "invalid warehouse_id" I never

    • Access invoice custom modules data from API

      Hi, I am using $url = "https://www.zohoapis.eu/invoice/v3/invoices"; $opts = ["http" => [method" => "GET",header" => [ "Authorization: Zoho-oauthtoken $accessToken", "X-com-zoho-invoice-organizationid: $orgId" ] ] ]; From my app to retrieve the invoices,

    • It would be very helpful to be able to use variables in the formula columns

      Currently, variables can be used only in aggregated formulas. It would be great to be able to use them in regular formulas as well

    • Bulk Update API

      I’m reaching out to see if anyone has updates on the bulk records feature release. We’re eager to leverage this functionality for our operations, but until it becomes available, our current API call limits are proving to be a bottleneck—even after upgrading

    • Proper syntax for filtering Added_Time in the URL using functionality-based URLs

      I haver intermediate knowledge of functionality-based URLs. I say that because when I use them, it is never straight forward with me. Sometimes it works first try, and sometimes I spend hours exploring to find the proper syntax. link to operators: https://help.zoho.com/portal/en/kb/creator/developer-guide/others/url-patterns/articles/functionality-based-urls#List_of_operators_and_their_constants

    • AI that checks text content quality and for plagiarism

      Hello, A client has a requirement where the users will be typing in content consisting of multiple paragraphs in Creator. The text box will be checked for plagiarism and also for its quality. What would be the best approach for that?

    • 404 Error When Using record_cursor in ZOHO.CREATOR.DATA.getRecords (js api)

      Iam working on fetching all records from a Zoho Creator report using the Get Records API (V2.1) with the following recursive function: js CopyEdit // Recursive function to fetch records using record_cursor from the response function fetchAllRecords(recordCursor

    • Reusable Variables

      I’d like to know if there’s a way to store variables in Zoho Analytics that I can use in metrics or calculations. For example, I have a Currencies table that stores the value of different currencies over time. I’d like to use the value of the US dollar

    • Linking Purchase Orders to Task budgets

      Hi, We are a construction company within the mining industry. Our projects usually have fixed budgets (Cost budgets per task). Is it possible to link Purchase Orders to task budgets? I know you can link the Purchase order to a project, but this is not

    • Introducing prompt builder in Zoho CRM

      We’ve introduced a new way to put Zia’s generative AI to work—right where your teams need it most. With the all new prompt builder for custom buttons, you can create your own AI instructions to generate tailored content, suggestions, or summaries across

    • Create Tasklist with Tasklist Template using API v3

      In the old API, we could mention the parameter 'task_template_id' when creating a tasklist via API to apply a tasklist template: https://www.zoho.com/projects/help/rest-api/tasklists-api.html#create-tasklist In API v3 there does not seem to be a way to

    • Facing issue in getting data through api calls

      I have send data of users and want to get the data oof users but facing issue with one field for that I want help

    • invokeURL to change custom field

      I have a deluge script that currently runs as a Schedule. It works exactly as intended, however I've recently been informed by Zoho that there's some mechanism in place to block changes made by a script when it runs on a schedule from being detected by

    • How to stop workflow running twice on a record

      Hi I have a workflow as below Trigger: Lead record is created/edited - Repeat this workflow whenever a lead is edited is NOT TICKED Condition: When Lead Stage is MQL Action: Reassign Lead, Create Task If the Lead goes into stage MQL, and then it changes

    • Customize the ticket ID for enhanced ticket tracking

      Hello everyone, Ticket IDs in Zoho Desk are the unique reference numbers that are assigned to tickets when they're created. Agents generally use the ticket ID to locate a particular ticket and to reference a ticket in conversations and feeds. When customers

    • FSM Function not executing

      Good Afternoon, all I am working on a workflow function in FSM and yesterday it was working fine. Now today when I select "Save & Execute" it does nothing. I even tested it with just a info statement and it is not executing. Any help would be greatly

    • DKIM cannot be enabled for the domain as no verified default selector present

      Can't get the DKIM working. May you please check my account (nksy.us) to see what's wrong?

    • Boost collaboration in your sales process with Team Selling and Deal revenue's Split—empowering your Zoho CRM for smarter teamwork!

      This feature is currently available for the AU and SA DCs. It is being rolled out in a phased manner and will be available to all users shortly. Hello everyone, As you may all know, closing a deal is rarely a one-person effort. It often involves multiple

    • Create modules using natural language prompts

      Hello all, We’ve introduced a new enhancement to Zia that allows you to create custom and team modules in Zoho CRM using plain language prompts. Why this enhancement? Creating a custom module traditionally involves multiple steps—choosing field types,

    • Suggesting enhance for criteria based data-sharing rules

      I suggest that, for user fields, the logged-user system variable could be used. This would allow the user, for example, to access records in which he/she is mentioned in a specific field, other than the owner. Thanks! Eduardo

    • How to sync read mails to GMail?

      Hello I am testing Zoho TeamInbox but I have an issue with my connected GMail account. Whenever I read a mail in TeamInbox or even reply to it, the email stays as "unread" in GMail. Is this normal behaviour? I thought that with the 2-way sync of IMAP

    • Look up field and show or hide section based upon selection

      Hi there, I am looking to show or hide a section within the opportunities module based on the value of the selection in the look-up field. This feature does not seem to be there Is there a workaround, and is this option coming in a future release? Thanks

    • eway Bill - Import (Good / Material)

      As we Importer of goods , for That first we Generate PO then , Payment, then after We create Bill of Entry  After Bill of Entry Anywhere (99%) cases material that arrived to port that comes to warehouse / factory for that Eway bill , we have to create

    • Import of Bank Statement DO NOT work - Date Mapping issue - Basic Feature Issue Becoming Serious Pain

      Hello, Yes, This is True. Importing Bank Statement feature is Not working as Intended. Facing few issues. Specially regarding the Mapping of Date field format. No matter how many times, we create a Case with Support team, they are NOT supporting in proper

    • Approval Workflow for Purchase Orders Abrir

      The requirement is , that all purchase orders greater than or equal to 5000 go through an approval process from certain people, but within books I only see that the approvers can be by levels or any approver but we cannot enter a rule like these. Can

    • How to see and amend Primary Clients easily

      Hi, i'm trying to make some reports on the clients we do projects for. However, i'm seeing a lot of "unknown" clients in the Zoho Analytics report. I suspect that these projects have not been assigned well and this needs to be corrected. Where can i easily

    • ZOHO NEEDS TO CREATE AN OPTION TO PASS CREDIT NOTE AGAINST SALES RECEIPT

      Zoho needs to find a way to pass credit note on sales receiptS. Creating a dummy invoice is causing major issues in tallying our sales figures and compliance with tax authorities.My system is tied to tax agencies and trying these options causes major

    • INTERGRATION OF ZOHO BOOKS PREMIUM PLAN AND ZOHO INVENTORY STANDARD PLAN

      Hello. I was using Zoho Books premium plan with 3 branches and has been working well until I purchased Zoho Inventory Standard plan. Now my 3rd branch location has been deactivate din Zoho Premium. how can I solve this please since I use all the locations

    • Exporting Templates

      I have just spent 2 hours creating a project template for a Netsuite configuration, and want to share it with other Zoho Projects users - who have a different account. Is there any way to do this?

    • It's time to say goodbye to Zoho Recruit for me.

      Hello, I have been a Zoho Recruit user since 2013. The tool has evolved, with a better UI, new features and so on. The pricing is still a great asset too. BUT, that being said, important features are not coming fast enough. I tried to share my point of

    • Automation#34: Schedule Guided Conversations (GC) Based on Business Hours

      Hello Everyone, Welcome to this episode on configuring your Guided Conversations (GC) based on your business hours. In our previous episode on Guided Conversations, we covered how to set up GC to enable offline support. This time, we'll guide you through

    • Download PDF from File Field with the name in another single line field

      Hi I am storing a PDF file in a File Field of a Form using Zapier automatically. now i need to download that file and set its file name as per the value stored in a single line field in that form. ANy turnout for that Thanks

    • Custom Module missing SDK function fetchRelatedRecords(...) in a Client Script

      Good day, We have added a new module with a Multi-Lookup relation to Contacts.  When we tried to use the fetchRelatedRecords(id, related_list_api_name) function to get Related Records it is missing for our new custom module. https://js.zohocdn.com/crm/5124797/documentation/DotSDK/Modules.html

    • TeamInbox and Desk Integration is Broken

      I use the TI -> Desk integration a lot. Today, it broke, again. When I go to create a Ticket from TI, an error message on a red background is shown "oops something went wrong". Checking the developers console on my browser, there are many 500 errors relating

    • Couldn't connect to host, port: wordpress2224249.home.pl, 143; timeout 10000

      Hey, i get a error up "Couldn't connect to host, port: wordpress2224249.home.pl, 143; timeout 10000" But i tried same passwords and info. to make imap on hotmail. and it works flawlessly. Has to be something with zoho....

    • Reply-To Match condition for Inbound Mail Messages

      I've trying to setup a rule to match the "reply-to" header but can't find any condition that would match this in Zoho TeamInbox rules. The business case is that I've setup my team inbox to be a member of a google group. The result of that is that emails

    • No Emails Flowing To Zoho TeamInbox

      From today, any emails we send to our TeamInbox addresses fail to be delivered. Our TeamInbox is connected via IMAP to 2 x Zoho Mail accounts. If I log in to those accounts directly via Zoho Mail, I can see all the emails landing in the inbox. The emails

    • How to download Renamed File that already updated to Zoho Creator.

      Hi members, I construct a button with report workflow. link = "https://creatorexport.zoho.com" + zoho.appuri + "report_link_name/File_upload/image-download/" + input.File_upload; openUrl(link,"new window"); This script able to download the file. But I

    • Merge Join PDFs Zoho Creator

      Hi all, I have a field where users upload PDF, is it possible to join those pdfs into one with a function or something? Regards.

    • Project Statuses

      Hi All, We have projects that sometimes may not make it through to completion. As such, they were being marked as "Cancelled". I noticed that these projects still show as "Active" though which seems counter intuitive. In fact, the only way I can get them

    • Next Page