How To Get Deals Per Contact?
Is there an extremely efficient way to get a list of Contacts with a Created_Time in a date range, and then get a count of their completed deals? I was trying to do a join in COQL but the docs are pretty hard to follow on this. The next thing we need to know is not only how many deals we did for all the contacts in that date range, but what the sales amount was. We're trying to update a third-party business intelligence dashboard with these statistics. (And yes, we're going to use a cache table between
Ability to add emoticons to notes fields
Hi, We gather feedback from our clients through a number of methods but when we paste in content that includes emoticons into a multi-line field in Zoho CRM, the emoticons are replaced with a ? This often means we lose the meaning of the clients message.
How to use pagination when getting records through a COQL Query in Zoho CRM REST API V2?
When I send a COQL query POST request to this endpoint https://www.zohoapis.com/crm/v2/coql?page=2&per_page=10 with this body { "select_query" : "select Last_Name, First_Name, Modified_Time from Contacts where Modified_Time >= '2020-01-10T00:00:00-05:00'", } I get 75 results. How do I properly paginate results when getting records through a COQL Query? According to this link pagination in API V2 should be possible: page: To get the list of records from the respective pages. Default value is
Badger Mapping
Has anyone attempted to integrate Zoho CRM with Badger Mapping or any other mapping software?
SMS Integration for Enterprise CRM
Hi can someone help with the following: I need an SMS extension that will allow: 2 way SMS sent to leads A copy of the message to appear in the Notes section of the lead Replies to either come to the CRM or to the users Mobile Phone Configurable sender ID Can anyone suggest an extension that will allow this? Thanks
Extract the Lead ID that was converted into a potentials via API
When a Lead is converted into a Potential, I would expect the Lead ID is stored within the potentials table. However, this fields is not currently not available within the API. Is there a way to access this information via the API? Thanks.
PDF Export Button
Hi Zoho CRM Community! I am working on the final stages of deploying our quoting module and have hit a few snags. First, our team will be using a different template for each sales channel (Domestic Direct, Domestic Distributor. and international) because the system does not allow any dynamic content generation. We have different fields and models we display to each customer group for various reasons. Reviewing the community board I see a work-around utilized within Zoho Creator, but the work-around
Rich Text field in Potentials entries
Hi, Potentials entries only have a plain text Description field. I absolutely need a Rich Text field in my Potential entries. How can I get this? I need a rich text field in Potential entries because I need to be able to bold/underline the important elements
Zoho Running Very Slowly
Hi, We have been using Zoho for about a week and it seems to be very slow. At times - to the point of being unusable. We have the full paid up version but only 2 users using it atm. Is it always like this or has there been work to the servers? Many thanks, Andre PS> Used IE & Chrome and from 2 different locations and all other websites running fast - so it certainly is not our side.
Change invoice number settings in Zoho CRM
The default invoice numbers generated by Zoho CRM are very long. For example: 4542989000002181606. We are a B2C company (business to consumer) and these numbers are too long for our clients. How can I change the settings to limit the length of invoice numbers (or invoice ID)? Thx.
Update to Connections - Deploy from Sandbox to Production
Hello everyone! Connecting any third party application through a function is done mostly through Connections. However, while deploying the functions from Sandbox to Production, we do not include these connections. We are happy to inform you that moving forward, you can deploy the functions along with their connections from Sandbox to Production. This enhancement will immensely benefit the customers who rely on writing functions first in Sandbox, testing them (UAT) there, and deploying them to Production.
incoming email: multiple email accounts in zoho crm
Hello! I ve two IMAP Accounts, where emails coming in. (two business divisions) I want to get both parsed by the CRM. Whow can I do this? The BCC Dropbox seems to be only for outgoing messages? "The received mails that are related to the particular lead, contact or deal will then get listed under the Emails section in that Lead's, Contact's or Deal's page respectively." (documentation) Question: Are the email also listed in custom modules entrys or only the CRM-standard lead, contact, deal? Thanks!
Scripted Telesales/Telemarketing Campaigns
Hello, I'm looking for a way to do scripted telesales/telemarketing campaigns in Zoho CRM. I have seen solutions like GrapeCity Telesales for Salesforce and CallPro CRM and they do exactly what I want to do, but they don't do it with Zoho which is the CRM I would prefer to use due to the pricing structure and the month-to-month payment model. Particularly GrapeCity; they do a great job of this, include prospect scoring and their interface is easy to use. But they are only on Salesforce and the add-on
Facebook Lead Gan
Hi Zoho Social team, I have a problem with Facebook lead gen. 1. In lead forms I have a Fields Mapped to a field that is a Unique field in the CRM and I think this is way I get an error "failed to sync" from Lead Forms, and I don't get the second request from the lead to get back to him. I need to get a notification if a lead leaves a new form to get back to him, I can lose clients because of this. 2. I am not seeing all the Ads, My marketing manager has uploaded a campaign from the Facebook ad manager
Sending with a Deals custom field filter
I use Contacts and Deals. I want to send an email to all contacts where a Deals custom field called "destination" is = to Paris. How can I do that? From Contacts, you cannot see any Deals fields and from Deals you cannot see Contacts fields?
Reports of (Accounts/Deals/Contacts) WITH NO activity in a period of time, last 30, 60 or 90 days, etc.
Hi, I have been working with Zoho for 2 years now, and I am having problems with these same type of reports. I am trying to create reports and dashboards for Contacts/Leads/Deals/Accounts that have had NO or Zero Activity for last 90 days. (activity i refer to is Calls or Meetings, (notes is a valid activity that a salesperson has to put in (but also if confiogured with salesIQ notes are automatic, but still valid) However, whenever i do reports, it does not have an option to choose Contacts/leads
Attach Files or Photos to records using Zoho CRM Developer API
Attaching files to records directly from your desktop to a record in your CRM is easy. But then, what happens if you want to attach files from an external service? Let's say - you have connected your CRM account with an Invoicing Application using our Developer API. You want to attach all invoices to corresponding records in your CRM account. Our Developer API now has methods that let you do this. uploadFile Method The uploadFile method lets you attach files to records. When files are uploaded,
Contact List in Account View
Is it possible to change the fields that are displayed under a contact at the very top of the Account view? Currently, it lists the contact name in bold and under has phone number and email address. Can their Title be added in that space as well? If not, is this something the developers could think about? It would be immensely helpful to us!
Customer function - How to get current user id?
Hello, I wish to create a new record in a customer module and set the owner to be the user performing the action. zoho.loginuser, zoho.loginuserid appear to give a string and email address respectively, and not the long int required by SMOWNERID. Any ideas please? Simon
Quote subject names and quote pdf names don't match, file name is truncated
How do I make the file name exported match the number of characters that are in the quote subject? The file names are less characters after the zoho update.
Self Client, Zoho Projects, and User-level authentication
Hey everyone, I'm new to this style of development, and have some questions. I'm looking to develop a C# application that hooks into a company's Zoho Projects to read/write/do whatever. I have a Self Client setup, and the OAuth2 working just fine. What I'm looking to achieve is require the users of the application to authenticate or login using their Zoho account against the company's project permissions. I may be poorly wording it, so for example. - I launch the application, and generate the application's
Triggering Zoho CRM workflow based on incoming webhooks from other services.
We have a module set up that creates a record of SMS sent via Twilio. On Twilio's end, whenever the status of the message is updated (e.g. from "Queued" -> "Sending" -> "Sent"), a webhook can be sent to a specified URL. Our plan is for Zoho CRM to be the receiving point of this webhook, so that we can then trigger a function from the webhook event, which then updates our CRM record of that SMS. Bizarrely, I haven't been able to find a way to receive a webhook through Zoho CRM yet. Given that there's
Lead Page doesn't refresh
Currently my work flow is as follows. open lead tab. Click call button within the lead view. Complete call using phonebridge (Ringcentral) by clicking done Workflow triggers and updates lead record. One the lead tab the records don't refresh unless I press F5. Is there a workaround? I know if I update the lead using a custom button it works, but I need it to work from phonebridge. Thanks, Mike
Kaizen #49 - Share Records #API
Hello Everyone! Welcome back to another week of Kaizen! In this post, we will discuss Share Records via Zoho CRM API. Record-level sharing In Zoho CRM, users can share individual records from any module with other users in the organization. You can share records using share records API. Pre-requisite Users with the Administrator profile can always share records with other users in the organization. For users with other profiles, the sharing permission must be enabled. To enable share permission,
Zoho CRM Invoice Module and Zoho Invoice Integration
Hello, I am using Zoho CRM Invoice module to keep all my invoices. Is there any way to sync or transfer all invoices in CRM Invoice Module to Zoho Invoice? Or is it possible to auto create an invoice in Zoho Invoice when I create an invoice in CRM Invoice module? Thanks Hayri
Insert custom text into forms
It would be handy to change the page format so that it can include customised headings, notes and information. This will help Staff members complete fields correctly. Not all fields have the option to include a 'tool tip' or 'static text', and we would like to make the forms as user friendly to complete as possible.
Zoho CRM Calendar / Zoho Calendar Sync not adding events to which I am added
Hello, I have Zoho CRM Calendar synced with Zoho Calendar. When I create an Event in my calendar and I add another User as a Participant, the Event appears in the other User's Zoho CRM Calendar. This is fine and works as expected. When the other User views their Zoho Calendar, the new Event has not synced (I wait extended periods of time to allow the sync to happen.) Events created by the other User do sync across, so this problem seems particular to Events to which the User is invited not syncing
Round Robin Distribution once there's a Field Update
Hi Is there a function that can do a Round Robin Distribution once the user have updated a field. I Created a group = Chinese speakers, English Speakers. Then I also created a dropdown field that says "Chinese Speaker,English Speaker" once they update the field to Chinese Speaker the lead owner would change to a chinese speaker but I want it to be a round robin distribution to Chinese Speakers Group everytime i update each and every leads record.
Zoho CRM Inventory Templates - HTML to PDF Conversion
Hi, I've created an Inventory Template using HTML & CSS and it looks good on the first page but when the content overflows on to the second page it appears to be cut off. And it also starts at the very top as you can see in the attached photo. It should start with some padding at the top. Ideally, it should use the css padding I have defined and apply to every page but it only does that on page 1. The HTML editor also strips off any @css rules such as media & print so I don't have much control. Can
Adding Create Date without the time to templates?
I am creating templates for quotes, sales orders and invoices and would like to use the "Create Date" fields for these however it adds the time as well which is not needed. Is there a way of showing just the create date on templates?
Download attachment (to variable)
I'm writing a deluge script to download an attachment from one vendor and attach it to another. Zoho told me to use invoke url with a connector, but I'm not sure how to esatblish a connector between zoho crm and zoho crm. Any thoughts on how to do this?
The New Error Codes in CRM API - RECORD_LOCKED and NOT_APPROVED
Hello everyone! As you all are aware, Zoho CRM offers an option to upload images for a record. When a user uploads images, Zia vision checks if the record meets any Zia vision configuration rules' criteria, and validates them. Click here to know more about Zia vision. As a part of our upcoming enhancement, we are going to support the image processing state for the records. We have added two new error codes related to the same in the Zoho CRM APIs. 1. RECORD_LOCKED Zia image processing state In our
Search in related list
Hello, Can you help me with one issue? I've created custom module "Payment plan" with field "Number" and lookup fields ('Accounts" and "Invoices"), and added this module as a related list to these default modules. So I can add items from "Payment plan" within Invoice card. But when I open modal window to add items, I can't search in any fields except "Number", but more convenient would be to search in other fields, for example in Account or invoice. Can I do this in any way? Screen capture to
Retrieve CRM Invoice Subject Field in custom function
For some reason the invoice "subject" field is not returned with the zoho.crm.getRecordById method. Essentially all other values except the field that is required to create is not returned. Very odd. But I need a means to retrieve this value in a crm custom function.
How to create a Sales Order by location (split by product) that can be exported into excel
Hi all - I am not sure if i am pushing the capabilities of zoho enterprise but here goes...I would like to save our Sales team building off line quotes and having to re key information that we have each time the customers wants a quote. Our data structure is Parent account, account, contact, site. There are often 1,000s of site at and account level, there can be some cross over of contacts and site contacts but we given them different roles to separate. We delivery different types of consultancy
Internet explorer - can't save notes in Zoho CRM
It just hangs when you try to save a note. It was working last week. Duplicated this on two separate computers.
Filter is not working properly.
Hello everyone, Filter feature in Zoho helps me a lot in the mass update and other quick views of activities. But the sometime filter is not working properly. Kindly find the below pictures for references. As you can see in the above picture, I just copy the deal name and paste in the activity filter but it shows nothing. Kindly help. Thanks, Shubham Agnihotri
Setting a custom lookup field with PHP SDK
I have a custom module "investments" that has a lookup field to the contacts module. If I get an instance of ZCRMRecord with the correct entity id etc can I just set this relationship using something like $contact value is returned from a call to searchRecordsByEmail $investment->setFieldValue("Investor", $contact); However this throws an invalid data error. Couldnt find any examples of the correct way to do this.
Undocumented CRM API Rate Limit?
I have been working on a CRM API integration and today as I was running my test suite I started getting this response: `{"code":"TOO_MANY_REQUESTS","details":{},"message":"Many requests fired than the allowed limit for a minute. Please check the header X-RATELIMIT-RESET for the reset time","status":"error"}` So, I looked at the headers and here we are: ``` X-RATELIMIT-LIMIT: 50 X-RATELIMIT-REMAINING: 0 X-RATELIMIT-RESET: 1598879308011 ``` The API Limits document does not mention a rate limit at all.
Adding a Tag to a new contact takes 6 clicks!
Have you considered the ability to add tags when a record is being created? It takes 6 clicks to ad a Tag after the original creation.
Next Page