Formula to calculate working days
How can this formula that calculates working days from ANYDATEFIELD to TODAY() be adjusted to Zoho CRM formula functions? CASE(MOD( ANYDATEFIELD - DATE(1985,6,24),7), 0 , CASE( MOD( TODAY() - ANYDATEFIELD ,7),1,1,2,2,3,3,4,4,5,4,6,4,0), 1 , CASE( MOD( TODAY() - ANYDATEFIELD ,7),1,1,2,2,3,3,4,3,5,3,6,4,0), 2 , CASE( MOD( TODAY() - ANYDATEFIELD ,7),1,1,2,2,3,2,4,2,5,3,6,4,0), 3 , CASE( MOD( TODAY() - ANYDATEFIELD ,7),1,1,2,1,3,1,4,2,5,3,6,4,0), 4 , CASE( MOD( TODAY() - ANYDATEFIELD ,7),1,0,2,0,3,1,4,2,5,3,6,4,0),
Search bar in portals
Is there a way to add a search bar in portals for finding Contacts or Deals in the list?
Approval Processes Issue
Hello, I have a significant issue that could potentially cause serious problems for our company. We have developed a new module that we use as a payment request module. In short, payment requests are made through this module and are approved by different
Associate Potential with Purchase Order
Dear Zoho Team I'm looking at associating a Potential with the various Purchase Orders that are issued to Vendors for that specific Potential. This would be of tremendous use at a later stage. Is this possible? I have tried looking at mapping dependency fields, but couldn't find a solution. Please advise.
How do I add page breaks to Sales Order templates?
I would like our Terms and Conditions to start on a new page of the resulting PDF. How do I do this? I tried adding <div style="break-after:page"></div>, but this did not work.
Possible to delete the "Big Deal Alert" in Zoho CRM?
Hi, Is it possible to delete the "Big Deal Alert" in Zoho CRM? My company has no need for it and I want to remove it to clean up my email templates list. Thank you.
COQL equivalent to zoho.crm.getRelatedRecords
Hello i add a standalone function, that i call from my js app with ZOHO.CRM.CONNECTION.invoke etc in the function i fetch with something like this AllContacts = zoho.crm.getRelatedRecords("relation_name","parent_module_name",recordid); it works great
2024 recap: Key updates to Zoho CRM's mobile app
Hello everyone, 2024 has come to an end, and as we welcome 2025, let's take a moment to look back at the updates that made Zoho CRM's mobile app even better last year. Here's a quick feature recap! Share record URL (Android) Users can now easily copy
Introducing new options for more flexible validation rules in CRM
Editions: Professional and above DCs: All Release plan: We've started rolling out this enhancement to customers. It is being released in a phased manner and will soon be available to all customers in all DCs. [Update | 26 Sep 2024] This enhancement has
Adding or displaying "Accounts" to Campaigns
I understand we can add contacts to a campaign, but to really get use out of campaigns I need to be able to add Accounts (or at very least, display the Accounts that the Contacts are associated with). In my business, we are on first name basis with many
Where do i find my latest mass email draft?
I spent hours doing an eblast, sent it out to my team, and now cannot find it in my CRM. Where do I locate drafts?
Zoho CRM Client Portal
I have set up domain mapping. https://help.zoho.com/portal/en/community/topic/early-access-rebrand-your-crm-with-the-all-new-custom-domain-mapping-setup-18-5-2023 When a Portal User logs into the Client Portal and prints any page, the Zoho branding still
What is the recipient when creating Whatsapp Notification in Zoho CRM?
I want to make a whatsapp notification in workflow rules. I want to send whatsapp notification from whatsapp template for the leads after 24 hours conversation window is closed I really don't understand what the recipient here is could you please elaborate
can we split the Whatsapp Message (Business Messaging) to only appear to certain user?
I know that we can split the leads record if a user send a message through Whatsapp API in here as you can see from the image above, we assign two users to handle the messages but it seems to me that all users can see all messages in the 'Message' module
API Casing needs consistency in names
The JSON for an account record looks like this: {"Name": "Name of the Account", "id": "id of the account", "Address": "address of the account" "Owner":{ "name": "Name of Owner", "id": "id of owner", } } It makes no sense that "name" is capitalized in
Shopify DTC Sales into from Books to CRM. Can the imported sale be a "contact" only with a sales record?
Currently our integration when importing sales from Books, is creating a Contact and a Account for that contact under the same name. We have been told by our integration partner this is a mandatory function of ZoHo. They are not able to import a Sale
TEMPLATES FOR QUOTES
Hi I am facing a lot of issues in creating a template for a quote with discount in ZOHO, we are unable to maintain alignment in our quotes . We have tried lot of things and still cant manage to get this basic thing right. Various emails to the ZOHO was
Trigger an action when a Product item is added to the Deal's Product Related List section?
Hello, Is it possible, via workdlow, to trigger an action when a Product is added to the Deal's Related List section? Thank you Moderation Update: We are locking this post as a similar discussion is ongoing in the linked post below. We encourage you to
Removing or dissociating contacts from deals
Hi all, I am working on creating an intuitive system within the CRM to deal with old contacts who have since left the company. We still want to keep them in the system, but do not want them attached to their old accounts or deals. What I've done thus
Function went from fine to nonfunctioning without change
url = "https://www.zohoapis.com/crm/v7/Accounts/" + id + "/Attachments/" + attach_id; file_engage = invokeurl [ url :url type :GET connection:"zoho_attachments" ]; The attach id is grabbed from a file upload field account = zoho.crm.getRecordById("Accounts",id);
How manage to hardware and software contracts.
So I have been tasked with setting up on crm a way of managing our software and hardware contracts. with a filter switch, so if they are no longer on say a hardware contract but still on a software, we would like the history about the hardware contract
INVALID_TOKEN CREATING LEAD
An error occurs when create token with curl "https://www.zohoapis.com/crm/v7/Leads" -H "Authorization: Zoho-oauthtoken HIDE" -d"@Lead.json" -X POST I can read leads, but I cannot write them. The permission are: ZohoCRM.modules.leads.ALL ZohoCRM.modules.deals.ALL
Creating Custom fields controlling visible lines?
I am very new to Zoho however I do not see anything on the Multiline line field creation that lets you control how many visible lines will show after data is entered in. I would have thought there would be a setting once you go into the Edit Properties
Mail Merge Document linked to Wrong Module
I've typed up a big document and realised its linked to the wrong module (Jobs). Is there a way to change this?
How to search Locked Record?
Hi, I have script like below, however seems this cannot search those locked record. what para I can add to search locked record? var invoice_info_list = ZDK.Apps.CRM.Invoices.searchByCriteria("(Sales_Order:equals:"+ so_record_id +")");
Moving contacts from one folder to different folder
I set up two folders. Uploaded CSVs and build my fields according to what I needed. My boss wanted more fields and changed the categories wants different fields added and contacts in one folder moved to the other due to reclassification. How can I do
Export multiple Invoice PDF
As part of end of year accounting a client needs to export all of their Invoices in PDF from Zoho CRM. Do they need to click into every single Invoice and click the Export to PDF button. Is there a means of either doing a mass Export to PDF of all Invoices
Creating a code for Task to event creation
I am looking to automate an event creation to do the following: When a task is created for a user, create an event at 530PM simply called TASKS. This will serve as a reminder that we have at least one task that needs to be addressed. We miss the task
Audit Log Export via API
Hello, Based on the documentation here https://www.zoho.com/crm/developer/docs/api/v7/create-export-audit-log.html I need to specify the scope ZohoCRM.settings.audit_logs.CREATE to create a log export. I've created a Self Client app but when I specify
When Email is sent, automatically have information be stored inside.
Hi there, I just wanted to know if it was feasible to make it so that when i receive an email to a specific email, all of the information or contents would be filled up inside of leads. This will help me with another side of the process that im working
How can I create individual records from a subform
Hi, I am collecting subform data into a Lead record and I need to create individual records for each row associated to the account when it is converted. How can I do this?
Account
I need to know how the maximum contact records available in my subscription. Also pleas advise the process to increase Contact Records. Also I need someone to contact me, I may need to add users, but need to workout a package that would fit my budge
Form to update a CRM contact field
Hello I need an help as I am going crazy. I need to create a form where there is a dropdown field with the contacts of Zoho crm (if possible filtered on the base of a field) and where other fields will be be automatically fetched with zoho crm data as
Kiosk Studio wrap-up | How our community used kiosks in 2024
Hello, everyone! Happy new year! The end of 2024 has been busy, and 2025 promises to be bigger and better. As we ring in the new year, let's rewind and look at Kiosk Studio, our no-code customization tool. The past 300 days have seen the CRM community
Create deal from estimate
Hello, I have integrated CRM and books. I created an estimate on CRM but I would like to allocate that estimate to a deal with the contact. How can I do this please?
Want to upload images to custom image fields using zoho crm api v2.
Hi i want to upload image to my custom image field from third party application using zoho crm api v2 . Please tell me how i can do this? Thanks
Related list Mobile Device
Hello, We use an the Zoho creator application to make reports linked to Accounts. On the computer: it's easy to go the Account and see all the created reports in the related list below On iPad/Phone ZOHO CRM APP: we cannot see the reports on those accounts
How can I visualize the events of a pipeline records?
Hi I need a list of events, including the date and address of the event related to the pipeline record. Can I do that? I know that for every pipeline record I can create events associated (Tasks, events, calls). But what I need it is an easy way to get
Zoho CRM - how to change SuperAdmin
Hi there - I'm looking for current guidance on how to change the Zoho superadmin for our company - I'm transitioning out of my role and need to delegate to another adminisstrator
Pass json to ZDK.Client.openMailer TO parameter
Hello I try to make send emails to a list of emails with : ZDK.Client.openMailer({ from: 'example@zoho.com', to: details_output, subject: 'test Mailing List', body: 'Test Mailing List Body' }); where details_output is an array like : [{ "email": "testcarte18078@test.com",
Next Page