If condition in Forumla Box
I am trying to insert a formula box with an If condition but I am continiosuly getting error called "Missing Quotes" My if condition contains strings If('${SalesOrders.Deal Type}'=='Influenced',${SalesOrders.Grand Total}/2,${SalesOrders.Grand Total}) I have a field called deal type, what I am trying to write is if the deal type field contains the string "Influenced" then the return value should be 50% of the Grand Total. Somebody please help me with an accurate syntax Thanks! Suraj
To Do List/Checklist
Looking for a way to create a To Do List/Checklist in the CRM. We have looked into the blueprint/pipeline option but as our "to dos" could happen in various stages, it doesn't work for us. It might be an option if we could have more than 1 pipeline but apparently that's not an option right now. What is the easiest way to have a simple To Do List/Checklist? We just want to have a list that we check off as completed. Thank you!
Can I add a checklist to Zoho CRM
I need to add a checklist to Zoho CRM. The checklist will have several options and I can check the options the customer is interested in. Is there a way to do that?
How to "Append" when importing Contact data to a Multi Pick List
Inside CRM I can perform a 'Mass Update' to a Multi Pick List which gives me two options: 1) Overwrite and 2) Append. Append allows me to 'add' an additional value to whatever might currently exist in the field. However, if I now want to import data from
Import Function: ONLY update empty fields
When setting up an import from a spreadsheet to CRM, there is a checkbox "Don't update empty values for existing contacts" (see screenshot below). While I see some limited benefit from this functionality, I think there should also be an "ONLY update empty
C# SDK Configuration
In my application I installed these package _ ZOHOCRMSDK-2.1 MySql.Data Newtonsoft.Json My application is .NET Framework 4.6.2 This is my Initialize class code screenshot. I use self client and scope "ZohoCRM.settings.ALL" for generate GrantToken code.
possible to search by uploaded/pasted list of email addresses?
I import leads from multiple sources. Sometimes these include contacts that are already in the database, and we don't import contacts. I currently download the list of failed imports and update them manually one-by-one - very tedious! I'd like to do a
Import Contacts with matching Account ID's
I just imported my Customers (Accounts). I would like to match my Contacts to the Accounts by Account ID (created by Zoho when importing Accounts). I do not see a field match for Account ID when importing Contacts. Can this be achieved?
Mapping custom fields from one module to another
I have a custom field, "Subscription Period" that appears as a required field in every Opportunity (Potential). I want that field to appear on any Quotes derived from that Opportunity (and have created a custom field of the same name in Quotes for that
Deluge: how to fetch Zoho CRM subform data
Hey I'm trying to get data from a Zoho CRM subform "PG_Info" to show up so I can merge it into a Zoho Writer template. When I try the code below it returns "null" for all entries. Any ideas? Website r_Deal_Record = zoho.crm.getRecordById("Deals",Deal_Record_ID);
Subform
How to get email body using Zoho CRM API or Node JS SDK
Hi Team, I'm building custom zoho crm widget using Node JS SDK. In that application I want to show contact related emails including the email body. I'm using get related records to get contact related emails, but it only contain the message id, subject
Specific Filed(s) get modified not working
Hi Everyone, I have a workflow rule to automate the Renewal Date Field. The rule will trigger when a specific field gets modified which is the 'Date Completed' once this field gets modified, 'Renewal Date Field' would generate a date +365 days to the
Get the Error "OAUTH_SCOPE_MISMATCH"
Hello, in every case i will get Data from the New OAuth2.0 CRM API i get the error "OAUTH_SCOPE_MISMATCH" Example call/response out of postman what am I doing wrong? The oauthtoken works fine, because i get the Error "INVALID_TOKEN" if i change it...
Is it possible to customise the lead conversion page in Zoho CRM?
I am looking to add/remove some fields and permissions on the lead conversion page when you convert a lead. I can't seem to find any information on whether this is possible or not.
Validate Text Field based on the value in other lookup field in the same Module.
Hi, I want to validate text input when create a new record based on another lookup field selected value in the same module. The flow is, user will select the look up value first. Once done, next user will key-in the text input that needed to be validated.
Send leads to another custom module
Hello In our company, some of the leads we import dont work, disconnected numbers or people not interested. We would like to be able to send this leads to a custom made module. Right now we can only convert a lead into a contact. Is there any way to send
Limit available products in cases from drop down
Hi We have many products in our CRM which are "spare parts" inventory. We only have 4 main saleable products supported using cases. Is there anyway to limit that product drop down in cases to just those few products? Ty
Dashboard Auto-refresh
Why is there no Auto-refresh on the Dashboard? People have been asking for the last 6 years for this function from what I can see in my reasearch, it seems like a very simple intergration for Zoho to achieve. on Sept. 2, 2014, this was added: Support
Filtering Deals Using Last Activity Time "older than x days" or "between x and y days"
I wish to create a filter for the Deals module and save the view so we can display the filtered Deals list on the home Dashboard. I wish to save 2 views: - Deals with a last activity time of 3 - 8 days ago - Deals with a last activity time of 9 days or
Revamped forecasting in Zoho CRM
Forecasting is an important part of a business's strategy to help set meaningful targets, optimize their sales strategies to help users achieve said target and drive revenue for the business. With this in mind, we've brought a number of different enhancements
Multi-Select lookup field has reached its maximum??
Hi there, I want to create a multi-select lookup field in a module but I can't select the model I want the relationship to be with from the list. From the help page on this I see that you can only create a max of 2 relationships per module? Is that true?
How do I define the argument in a function?
Hi, I have watched endless videos on attempting to have a record from one module update from another. It all seems pretty self explanatory until I get to the idea of mapping the arguments. On every video when you click "edit Argument" You get a dropdown
Workflow trigger only works if you open and edit a record and save how can we make this trigger by mass udpate
We have a nubmer of new workflows we would like to update 3000 historical records, however it appears we have to open, edit, save, close each of the 3000 records for the workflow to update the fields required. It would be good to be able to achieve this via mass update. How do we do this? Because with mass update we are editing the record, so it is only common sense for the workflows set to trigger on the field update to process.
Unit Price vs List Price
Hi Guys I am looking at setting up price books and want some clarity. In the product module there is "unit price". I have been using this price as our sell price for quotes etc. I presume though this should be our buy price from our supplier????? Is this
CRM Client Script Show/Hide fields
Good day, I would like to be able to show/hide CRM record fields by using Client Scripts. I hope this might be considered as a new feature in the future. Thanks!
Change Default Mandatory Fields
Is there any way to change the default mandatory fields to a non mandatory field, or remove the default fields from the page layout? While customizing several of the modules to fit our business needs, Cases for example, we do not need fields such as Case Origin - that have been labeled as mandatory, and have little ability to further customize the fields to fit our business needs. We have created several other fields and identified them as Mandatory, but we are unable to save a new record, because
Date Format
Hi I am looking at the best way to chagne a date field that comes in via a third party (Thirdparty_DOB) in the following format in the contacts module YYYY-MM-DD. I want to change this to our system format of DD/MM/YYYY and am trying to figure out if
CRM Business Hours through the API/Deluge
Hey Zoho, We love the Business Hours function in Zoho CRM (see doc here). Is there a way to access the shifts that have been configured using Deluge, or through the CRM API? We would like to be able to use this feature from our code when we are assigning
For medical representative ( field force)
How can i take the best use of crm , for the purpose of my salesperson ( medical representative) in the market, 1) gps location tracking 2) daily report 3) Order booking 4) tour program 5) Customer view 6) territory management 7) doctors activity
Different Auto-Number Prefix for Different Quote Layouts
I am hoping someone can help. We currently have two sales streams that I am slowly separating so that they capture their own specific information, manage their own customers and have their own custom paperwork (Quote/Sales Order/Invoice). Whilst trying
Possible to connect Zoho CRM's Sandbox with Zoho Creator's Sandbox?
We are making some big changes on our CRM so we are testing it out in CRM's Sandbox. We also have a Zoho Creator app that we need to test. Is it possible to connect Zoho CRM's Sandbox to Zoho Creator's Sandbox so that I can perform those tests?
USD vs AUD
Hi Guys We buy in fixed USD, but we sell and pay in AUD with FX Rate changes eg.widget 1 is $100 USD (never changes) but we pay AUD $142 What id like to do is use the unit price in USD for PO etc in the products module, and be able to quote in AUD to
Zoho CRM - Upcoming Features ...
Hi, We would like to inform you about the Zoho CRM features that we are taking up in the near future. Please go through this link. As a policy we will not commit any dates for any mentioned features. However we will try to roll out the listed features one by one in the period of 6 months time. We will keep you posted just in case we change our priorities with respect to any features. Thank you, With Best Regards, Dilip, Zoho CRM
Function-2: Round-Robin assignment of records
Welcome back folks! Last week, we saw how to update sales commission in quotes using a custom function. This week, let's see an interesting use case asked by many of you - auto-assignment records by round-robin method. Business scenario: Right now, the solution allows you to auto-assign leads from web form and imported lists. Let us look at a need where you want to auto-assign leads from in-bound calls in a round-robin method, across modules. Prerequisite: You must create a permanent record in the
Match on auto-number field OR make Account ID visible as field in display
Here's the problem: I'm trying to have a unique ID for each Account that I can match on for imports. The ID needs to be visible on the display of the individual Account, and also needs to be visible on the display of any associated Contacts. I know how
What can be done with the Button element in CRM Canvas?
User field support for subforms
Dear All, Subforms help you add and track data related to your CRM records. We've always supported most of the commonly used field types in subforms, so as to cater to your business requirements. Now we're happy to extend support to a User fields. Here's
Alter a system defined field from a 'single line' into a picklist
Hello, I am looking to switch the STATE field, which is a Zoho defined field from a 'single line' into a picklist. Can you advise how to change this?
Notifications API - how to handle channel expiry
The Documentation doesn't give a lot of detail on how the Notification API should be used. Am I correct that I can only open a channel for a maxmimum of 24 hours? And once the channel_expiry date has passed, I will no longer receive notifications? What
Lead ID - What is it and what should it be assigned to during import? The mandatory field 'Lead ID' must be mapped.
Hi, I am importing my contacts from another CRM via csv file. In the Data Migration section, it says the LEAD ID field is mandatory, but there is no information on what this should be mapped to? Error message shown: The mandatory field 'Lead ID' must
Next Page