
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!
Recent Topics
Formula field with IF statement based on picklist field and string output to copy/paste in multi-line field via function
Hello there, I am working on a formula field based on a 3-item picklist field (i.e. *empty value*, 'Progress payment', 'Letter of credit'). Depending on the picked item, the formula field shall give a specific multi-line string (say 'XXX' in case of 'Progress
Unified Directory : How to Access ?
I signed in to Zoho One this morning and was met with the pop up about the upgraded directory (yay!) I watched the video and pressed "Get Started" ... and it took me back to the standard interface. How do I actually access the new portal/directory ?
Zoho CRMの流入元について
Zoho CRMとZoho formsを連携し、 formsで作成したフォームをサイトに埋め込み運用中です。 UTMパラメータの取得をformsを行い、Zoho CRMの見込み客タブにカスタム項目で反映される状況になっています。 広告に関してはUTMパラメータで取得できているため問題ないのですが、オーガニック流入でフォーム送信の場合も計測したいです。メールやGoogle、Yahoo、directなどの流入元のチャネルが反映されるようにしたいのですが、どのように設定したら良いでしょうか。 また、
Error While Sign in on Zoho Work Drive
Dear Team, I hope this email finds you well. I have recently created a Zoho account and started using it. But while I am trying to log in to Zoho work drive it won't log me in its crashing every time I try it. I have tried it on android app, phone browser
Choosing a portal option and the "Unified customer portal"?
I am trialling Zoho to replace various existing systems, one of which is a customer portal. Our portal allows clients to add and edit bookings, complete forms, manage their subscriptions and edit some CRM info. I am trying to understand how I might best
Translation support expanded for Modules, Subforms and Related Lists
Hello Everyone! The translation feature enables organizations to translate certain values in their CRM interface into different languages. Previously, the only values that could be translated were picklist values and field names. However, we have extended
Unified task view
Possible to enable the unified task view in Trident, that is currently available in Mail?
Importing data into Assets
So we have a module in Zoho CRM called customers equipments. It links to customers modules, accounts (if needed) and products. I made a sample export and created extra fields in zoho fsm assets module. The import fails. Could not find a matching parent
Allow instruction field in Job Sheets
Hello, I would like to know if it is possible to have an instruction field (multi line text) in a job sheet or if there is a workaround to be able to do it. Currently we are pretty limited in terms of fields in job sheets which makes it a bit of a struggle
Streamlining Work Order Automation with Zoho Projects, Writer & WorkDrive
Hello Community, Here is the first post in 'Integration & Automation' Series. Use Case :: Create, Merge, Sign & Store Documents in Zoho WorkDrive. Scenario :: You have a standard Work Order template created in Zoho Writer. When a task status is chosen
The dimensions of multilingual power
Hola, saludos de Zoho Desk. Bonjour, salutations de Zoho Desk. Hallo, Grüße von Zoho Desk. Ciao, saluti da Zoho Desk. Olá, saudações da Zoho Desk. வணக்கம், Zoho Desk இலிருந்து வாழ்த்துகள். 你好,来自 Zoho Desk 的问候。 مرحباً، تحيات من Zoho Desk. नमस्ते, Zoho
Multi-line address lines
How can I enter and migrate the following 123 state street Suite 2 Into a contact address. For Salesforce imports, a CR between the information works. The ZOHO migration tool just ignores it. Plus, I can't seem to even enter it on the standard entry screen.
Accessing Zoho Forms
Hi all, We're having trouble giving me access to our company's Zoho Forms account. I can log in to a Forms account that I can see was set up a year ago, but can't see any shared forms. I can log into Zoho CRM and see our company information there without
Cost of good field
Is there a way we can have cost of good sold as a field added to the back end of the invoicing procedure and available in reports?
How to add image to items list in Invoice or Estimate?
Hello! I have just started using Zoho Invoice to create estimates and, possibly to switch from our current CRM/ERP Vendor to Zoho. I have a small company that is installing CCTV systems and Alarm systems. My question is, can I add images of my "items" to item list in Zoho Invoice and Estimates and their description? I would like to show my clients the image of items in our estimates so they can decide if they like these items. And I tell you, often they choose more expensive products just because
Issue with the Permission to Zoho Form
I am getting an error by signing in to zoho form as it is stated that i don't have permission to access this is admin account
CRM templates
Hello everyone, In my company we use Zoho campaigns where we set up all newsletters and we use Zoho CRM for transactional emails. I have created some templates in Zoho campaigns but from my understanding i cannot use those in Zoho CRM, right?
Pending Sales Order Reports
Pending sale order report is available for any single customer, Individual report is available after 3-4 clicks but consolidated list is needed to know the status each item. please help me.
Zoho Mail SMTP IP addresses
We are using Zoho Mail and needs to whitelist IP for some redirections from your service to another e-mails. You can provide IP address list for Zohomail SMTP servers?
Trying to Add Tasks to Other Users Is Utterly Baffling
As the title says, the process of trying to create a task for someone in my team is so unintuitive and illogical that I have given up trying to do it. This is a feature that I pay for but it is so poorly devised and implemented that my team has given
Zoho Campaigns - Why do contacts have owners?
When searching for contacts in Zoho Campaigns I am sometimes caught out when I don't select the filter option "Inactive users". So it appears that I have some contacts missing, until I realise that I need to select that option. Campaigns Support have
email forwarding not working
Your email forwarding service does not work. I received the confirmation email and completed the confirmation, after that nothing and nothing since no matter what I have tried. Shame as everything else was smooth. I spose it's harder to run one of these web based internet mail services than you guys thought!!! can you fix the email forwarding asap PLEASE!
Google Ads Conversions Not Being Tracked in Zoho CRM
We have 3 different conversions created in our Google Ads Account. Only one of the 3 conversion types is tracking in Zoho CRM. Our forms are Elementor Forms that are mapped into Zoho CRM. It apprears to me that all leads are showing up in Zoho CRM, but
Enable Locations for Expense
Hi, please enable Locations (ex Branches) for Zoho Expense so that there is consistency between this app and Zoho Books. Thanks in advance.
无法发送消息;原因:5545.1.8电子邮件传出被阻止。
求帮助,我的邮箱无法发送邮件,请尽快修复。 我们只是用来做正常的资料寄送,如果贵公司再无理封锁我们的邮箱,我们会改用其他公司的服务。 请尽快解封,ID: 815556404
in the Zoho Creator i have File Upload field get the file on submission of the form Get the File and upload to Zoho Books
in the Zoho Creator i have File Upload field get the file on submission of the form Get the File and upload to Zoho Books . how I get the file From zoho creator and upload to Zoho Books . using Api response = invokeUrl [ url: "https://www.zohoapis.com/creator/v2.1/data/hh/l130/report/All_Customer_Payments/"+input.ID
Generate a link for Zoho Sign we can copy and use in a separate email
Please consider adding functionality that would all a user to copy a reminder link so that we can include it in a personalized email instead of sending a Zoho reminder. Or, allow us to customize the reminder email. Use Case: We have clients we need to
Rate Limiting in Zoho Flow (OpenAI API)
Hi Everyone, We are facing some issues when using Zoho Flow as we have a deluge script running which is making external calls to OpenAI endpoint. Sometimes the response takes more than 30 seconds meaning the script will timeout. We want to implement a
Placing a condition before converting the LEAD
Hi, I need some assistance with Lead conversion. I need to place certain conditions before allowing the user to convert the lead. For example: up until the certain status's doesn't equal "green" don't allow to convert lead. I tried creating this using
it is possible to open a widget via deluge script function
I have one function that is workflow action I call my fucntion I need to call the internal widget it is possible to open or it have to please tell me the solution
Creator - Portal Custom Domain
I will pay $100 in crypto to anyone who can actually get my Creator Custom Domain to function (actually tell me how you got yours to). Domain verifies, Nothing. I've been fighting it a week, multiple chats to customer service. Clearly I'm doing something wrong. Some datapoints Domain name itself unimportant, can be a string of numbers. I need to know what registrars are working for you because GoDaddy does NOT. Do I need hosting? I've tried both ways and nothing works. I pushed through Cloudflare
steps and options to change Domain DNS/Nameservers settings
Please share the options or steps to change Domain DNS/Nameservers settings
Employees in Leave Policy exceptions
In the Leave Policies we should be able to add specific employees to the exception list So it will be like All Employees except A,B,C in the exception list, currently we can only add departments etc
How get stock name from other column ?
How get stock name from other column ? e.g. =STOCK(C12;"price") where C12 is the code of the stock
Adding a developer for editing the client application with a single user license
Hi, I want to know that I as a developer I developed one application and handed over to the customer who is using the application on a single user license. Now after6 months customer came back to me and needs some changes in the application. Can a customer
Download an email template in html code
Hello everyone, I have created an email template and I want to download it as html. How can i do that? I know you can do it via the campaigns-first create a campaign add the template and download it as html from there. But what if i don't want to create
Attachment is not included in e-mails sent through Wordpress
I have a Wordpress site with Zeptomail Wordpress plugin installed and configured. E-mails are sent ok through Zeptomail but without the included attachment (.pdf file) Zeptomail is used to send tickets to customers through Zeptomail. E-Mails are generated
Upcoming Changes to the Timesheet Module
The Timesheet module will undergo a significant change in the upcoming weeks. To start with, we will be renaming Timesheet module to Time Logs. This update will go live early next week. Significance of this change This change will facilitate our next
Cant update image field after uploading image to ZFS
Hello i recently made an application in zoho creator for customer service where customers could upload their complaints every field has been mapped from creator into crm and works fine except for the image upload field i have tried every method to make
Billing Management: #4 Negate Risk Free with Advances
In the last post, we explored how unbilled charges accumulate before being invoiced. But what happens when businesses need money before service begins? Picture this: A construction company takes on a $500,000 commercial building project expected to last
Next Page