
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
Client Script - Updating Field Value in Detail Page of a Lead
Hello, I'm trying to use Client Script To enrich some data of the Lead when one of my User fill the "City" field in the detail page of the Lead. This is my Script: log (value); var response = ZDK.Apps.CRM.Functions.execute("getInfoCitta", { "nomeCitta":
Auto shapes in Zoho sheet.
Does Zoho sheet supports inserting auto shapes (rectangle, circle...). I did not see any option to do so. If its not supported currently, is there any plans on bring in this features. Any timelines ?
I Can't Clone Webinar that I Co-Organize
How do i get our account admin to give me permission to clone our webinars? I am a co-organizer
How to get the call recording external ID via desk API
I have enabled phonbridge integration with Zoom Call. I am trying to access the call recording in Zoom by calling Zoom API. I have built a Desk workflow to trigger on a new call, to call a custom function. when calling the API, the response doesn't contain
Can't View Project Names in Mobile App
I can't view project names on PO's in the app, nor can I add that as a viewable PDF field in inventory on the computer. I've attached screenshots showing that in the mobile version whether you are on the PO, editing the PO, or viewing the PO line items,
How do you print a refund check to customer?
Maybe this is a dumb question, but how does anyone print a refund check to a customer? We cant find anywhere to either just print a check and pick a customer, or where to do so from a credit note.
Notebook
I have purchased the monthly pro subscription of Notebook. But it does not support my XP-Pen to write something in it. So it is not useful to me. Hence I am requesting you to help me to discontinue this subscription.
Domain Mapping & Image Publishing Issues on Zoho Sites
Hello, I am facing two issues with my Zoho Sites account: 1. Images not visible after publishing. 2. Domain mapping error: "Domain already exists". I am a paid customer. Please connect me with Live Chat Support or Zoho Assist so I can show my issue
Prevent duplicate with custom fields?
I was wondering something about custom field/custom modules in Zoho Desk. For some reason you can make a custom field mandatory but not unique? For example, if I create a custom module to manage equipment and renewal and make a field serial number no
Two currencies
More and more I am finding that internattional payments' fees are unpredictable. I would like, on my invoices that are in a foreign currency (eg. USD$ or EUR€) for there to be a GBP£ TOTAL display alongside the invoice's currency total. This would make
Generate leads from instagram
hello i have question. If connect instagram using zoho social, it is possible to get lead from instagram? example if someone send me direct message or comment on my post and then they generate to lead
Where is the desktop app for Zoho Projects???
As a project manager, I need a desktop app for the projects I manage. Yes, there's the web app, which is AWESOME for cross browser and platform compatibility... but I need a real desktop app for Projects that allow me to enter offline information where
White Label certificate
Hi all, About 72 hours ago, we fulfilled all steps for white labeling (CNAME to point to mail.cs.zohohost.eu), but since then the configuration page is now stuck at "generating certificate" since 3 days. When I execute an NSLOOKUP mail.webfoundry.be it
How to Automate Monthly PDF Reports with Filters in Zoho Creator
Hi everyone, I’m trying to build an automated monthly reporting process in Zoho Creator and would appreciate suggestions or best practices from anyone who has done something similar. What I’m trying to do: I have a form called New_Customer with fields
Feedback: Streamlining Note Management in Zoho Notebook
Dear Team/Support, I would like to share some feedback regarding the note management system that could help improve usability and accessibility for users like myself. Notebook 1 (screenshot attached): Currently, the system does not allow selecting and
showing Limit exceeded
Good afternoon...trust you're good. I've been having issues working with but it's not responding. it's showing Limit exceeded, sorry it seems like too many people are working on the sheet right now please try again later. meanwhile no one is working on
Sorting columns in Zoho Projects
Hi, In project management best practice, sorting columns (ascending, descending) is an important tool. Sorting dates to see the order of tasks starting, sorting on priority or even on planned hours is a must for an efficient project control. Currently,
Upload API
I'm trying to use the Upload API to upload some images and attach them to comments (https://desk.zoho.com/DeskAPIDocument#Uploads#Uploads_Uploadfile) - however I can only ever get a 401 or bad request back. I'm using an OAuth token with the Desk.tickets.ALL
Losing description after merging tickets
Hello, We merge tickets when they are about the same topic from the same client. It happens sometimes. We recently noticed that after the merger only the description from the master ticket is left in a thread. And the slave-ticket description is erased.
update linked contacts when update happens in account
Hi, I have a custom field called Licence in the Accounts module. When someone buys a licence, I’d like to update a custom field in the related Contacts. How can I achieve this? I noticed that workflows triggered on Accounts only allow me to update fields
Problem Management Module
I am looking for a Problem Management module within Zoho Desk. I saw in some training videos that this is available, and some even provided an annual price for it. I want an official confirmation on whether this is indeed available. This is not a particularly
Unable to explore desk.zoho.com
Greetings, I have an account with zoho which already has a survey subscription. I would like to explore desk.zoho.com, but when I visit it while logged in (https://desk.zoho.com/agent?action=CreatePortal) I just get a blank page. I have tried different
Offline support for mobile app
Accessing your files and folders from your mobile devices is now quicker and simpler, thanks to the power of offline support. Whether on an Android or iOS device, you can use the Offline function to save files and folders, so you can review them even
Zoho Desk KB article embedded on another site.
We embed KB articles from Zoho Desk on another site (our application). When opening the article in a new tab, there is no issue, but if we choose lightbox, we are getting an error "To protect your security, help.ourdomain.com will not allow Firefox to
OPTED FOR STORAGE BY DESCRIPTIVE MISGUIDANCE
We've opened a domain with three mail ids and payment has also been processed now the bill raised is for single use ID with additional storage capacity. Kindly request you to modify the purchase.
List of packaged components and if they are upgradable
Hello, In reference to the article Components and Packaging in Zoho Vertical Studio, can you provide an overview of what these are. Can you also please provide a list of of components that are considered Packaged and also whether they are Upgradable?
Does Attari Messaging app have Bot option and APIB
Hi, Does Attari also have Bot and API as we use in WhatsApp??
How to add application logo
I'm creating an application which i do not want it to show my organization logo so i have changed the setting but i cannot find where to upload/select the logo i wish to use for my application. I have seen something online about using Deluge and writing
Email login error
Login successfully but email page error
Zoho Analytics Regex Support
When can we expect full regex support in Zoho Analytics SQL such as REGEXP_REPLACE? Sometimes I need to clean the data and using regex functions is the easiest way to achieve this.
Change of Blog Author
Hi, I am creating the blog post on behalf of my colleague. When I publish the post, it is showing my name as author of the post which is not intended and needs to be changed to my colleague's name. How can I change the name of the author in the blogs?? Thanks, Ramanan
Show Attachments in the customer portal
Hi, is it possible to show the Attachments list in the portal for the particular module? Bests.
Feature Request - Insert URL Links in Folders
I would love to see the ability to create simple URL links with titles in WorkDrive. or perhaps a WorkDrive extension to allow it. Example use case: A team is working on a project and there is project folder in WordDrive. The team uses LucidChart to create
How to sync from Zoho Projects into an existing Sprint in Zoho Sprints?
Hi I have managed to integrate Zoho Projects with Zoho Sprints and I can see that the integration works as a project was created in Zoho Sprints. But, what I would like to do is to sync into an existing Zoho Sprints project. Is there a way to make that
how to differentiate if whatsapp comes from certain landing page?
I create a Zobot in SalesIQ to create a Whatsapp bot to capture the lead. I have 2 landing pages, one is SEO optimized and the other want is optimized for leads comes from Google Ads. I want to know from which landing page this lead came through WhatsApp
Split my account
Hello, I recently bought an email service for a friend. But, looks like I used my personal account to buy the plan. Please split the account so that the email service stays in a different account than my personal account.
How to record company set up fees?
Hi all, We are starting out our company in Australia and would appreciate any help with setting up Books accounts. We paid an accountant to do company registration, TFN, company constitution, etc. I heard these all can be recorded as Incorporation Costs, which is an intangible asset account, and amortised over 5 years. Is this the correct way to do it under the current Australian tax regulations? How and when exactly should I record the initial entry and each year's amortasation in Books? Generally
Have Mail Lite, wish to add/purchase 2nd domain and use email
Hello, I have recently created two new businesses. I have successfully used Zoho to create a domain for one business and have set up two email addresses / users on that domain. I am trying to figure out how to create a second domain, just like I did the
Show Payment terms in Estimates
Hi, we are trying to set up that estimates automatically relates payment terms for the payment terms we introduced on Edit contact (Field Payment terms). How can it be done? Our aim is to avoid problems on payment terms introduced and do not need to introduce it manually on each client (for the moment we are introducing this information on Terms and Conditions. Kind Regards,
Search Bar Improvement for Zoho Commerce
Hey everyone, I've been using Zoho Commerce for a bit now, and I think the search bar could really use an upgrade. Right now, it doesn't show products in a dropdown as you type, which would make finding items a lot faster. On Shopify, for example, you
Next Page