Subform: Prepopulate Rows using Unique Picklist values on Deal Conversion?
Upon conversion of a deal, I want to automatically add rows to my subform from my picklist values. I don't want to add all of them but about 15. One row for each unique value. Currently when I convert a deal my sub form looks like this by default. Then
How to query for Deals record based on Pipeline?
I want to query for Deals records that matches a specified Pipeline using a Deluge function. When I call zoho.crm.searchRecords("Deals","(Pipeline:equals:" + myPipeline + ")"), I get this error: { code: 'INVALID_QUERY' , details: {...} , message: 'Invalid
Can you modify "Last Activity Time" in deluge? If so what's the field name?
I need to perform some bulk modifications on records in the Leads module, but I need to avoid changing the "last activity time" or "date modified" because I am using those fields to filter and sort leads for follow-up action. I cannot find an answer anywhere
Map fields from CRM record to Finance Suite/Books Invoice fields
I'm trying to auto-fill unique record specific field inputs that I have in my Contacts and Deals modules onto Invoices created from the record's finance suite related list upon creation. One example is a field called "Job Number" that I have in my Contact
Subir o Preço Unitário já acrescido de um valor
To com um desafio grande, e se alguém conseguir me ajudar, seria ótimo! O que eu preciso é que o na hora de adicionar um item no subformulário dos itens cotados do módulo Orçamentos, o preço de lista do item venha acrescido de 20% automaticamente e de
Custom Functions - Calculate Commission - failure after migration from US to EU
Hello, i would ask for help. My Custom Function - Calculate Commission stopped working and shows a failure. Mismatch of data type expression. Expected List but found String What is the problem? Could anyone help? Here is script: void automation.ObliczProwizje(Int
Deluge upload to upload file field
Trying to upload a file to a field type Upload File. I believe I have most correct. I have a merge and download from writer. I have this same script in many other functions and it works fine. I then upload the file to ZFS and get a success response However,
URL_ROLLING_THROTTLES_LIMIT_EXCEEDED
Hello, for several times now we are getting URL_ROLLING_THROTTLES_LIMIT_EXCEEDED in the Failure tab. What does it mean, and how can we solve this? Thanks, M.
Cant add owner to field update in workflow
Hi there, Currently when i tried to add owner of the record of the module to the field update, i am unable to. Is there a way to do so?
How to Implement Time-Based Filters in Zoho Workflows?
Hi everyone, I’m looking for a workaround to implement time-based filters in Zoho workflows. Specifically, I need a workflow to trigger only within certain hours (e.g., between 10:00 AM and 8:00 PM, Sunday to Friday). Currently, Zoho workflows execute
Change script to add fields
Hi, I have a custom function (writen by a different implementation company in the beginning) which I would like to edit to add a different field as well. Can't get it to work on my own though. - The script now adds the address fields to a new quote (needs
Map fields from module X to a lookup field in subform in module Y
Hi there In the 1st screenshot attached, you can see a subform in myLeads module. You can see that there is a number already filled there - that is the 'Property ID' and it is a single line field. It is the 'Property ID' of an entry I have in another
tax summation function - getting error
Hello, I'm trying to create a function that adds all of individual tax rates from a few jurisdictions. I'm getting an error on line 9 - Value is empty and 'get' function cannot be applied. I've checked that I have data in each of the required fields,
Calculate months and years between 2 dates on subform
I am looking for a function syntax for an employment candidate to calculate the number of years and months (decimal format. eg 1.2 years) they are employed. I have their start date entered, but if the end date is blank, that tells me they are still employed
Task module and related-to field
In modules other than the Task Module I can add several lookup fields to provide a variety of relationships. In the Task module lookup fields are not available. There is only one "related to" field which I want to use for Company. But I want to relate
See Calendar When Creating Meetings On Record Page
It would be a great user experience to see you calendar while you are creating a meeting on a record page. Here is how I imagine it could look:
Add Feature To Hide Plugin Sections On Record View
Hi team, I'm trying to help a client tidy up their CRM. When it comes to record view some sections and fields are visible no matter what Layout Rules are applies and they are not removeable from the layout editor. I would like to see an option to hide
Zoho CRM functions editor is not in the programming language deluge
I am trying to write a function for a button. I helped someone before in deluge and I'm using this new editor I'm not familiar with - I guess it is new. Why is the default code statically typed? The editor will not let me create a variable without a type.
Workflow - Execute Based on Date
Hello, I have trouble understanding the documentation for Execute Based on Date or Date Time Field's Value. I want to send an email every time I have a Case opened for more than three days with its status unchanged. I set : This rule will be executed 3 days after [date]. Condition : Status is [New]. Instant Action : Send an email notification. However, I'm not sure I follow this part of the documentation: "For all the records matching the rule criteria, rule will be triggered either monthly or yearly
Calculate hours between 2 date/time fields
Hi, Does anyone know if it is possible to get the number of hours between 2 date/time fields in a zoho crm custom function? Thanks, Michael
Issue with Create Note Button and Popup Form in Leads Module
Hello Zoho Community, I am trying to implement a "Create Note" button in the Leads module with the following functionality: 1. When the button is clicked, a form should pop up with fields to add notes. 2. After filling out the form and clicking Send,
How to get a list of selected records into a button-function? Here is how!
So, you might know already how to get a button on a page somewhere and perform actions with a function when pressed, but how about a button that only works with the records you selected in the list view? The button selected is a custom button in the modules
How to Add Break line / Return on button click
I need to return the text concate with difference field from lead with line break i try "\r" ,"\n" "<br>" return "ali \r\n <br> baba"; None of above work. i expected result something like this ali baba but got this ali \r\n <br> baba so, how can i
Sync custom module ID to Lead module
Hello, I am trying to sync Contract ID (custom module) from Deal module. I have an existing function that whenever a contract is created, it will automatically creating deals based on the frequency of the contract. Now i am having problem to show the
In Kiosk, please support "File upload field" in the "Field Update" action
Hello. Supporting "File upload field" in the "Field Update" actions would be a great addition to Kiosk Studio. I would appreciate it if you could evaluate it. Saludos,
Creating a Zoho Online Meeting in a Blueprint
We are looking for an easy solution to schedule online meetings in a blueprint and ran into the same problem discussed in this topic: https://help.zoho.com/portal/en/community/topic/custom-function-to-set-meeting-to-online-meeting (After connecting Zoho
Function for Emails tranfer from Lead to Deal
Hi Due to the fact that my Deals conversion needs to be done in 2 ways - depending on the fact if those records already exists or not - resources in fields are different. I am making function control conversation for Leads but I have problem with transferring
CRM - Clearing a Subform
I seem incapable of working out subform functions without assistance. I've searched, but can't seem to find anything that works. I have a subform that gets filled in when a Zoho Sign document is completed but the fields don't match with the original field values held on CRM (I did have it automatically update, but some fields were being filled in with terrible data, so had to put a stop to it). There are 4 fields on the subform: Field Name Original Value New Value Update Update is automatically
Why can't we associate a contact to mulitple accounts?
This simple feature has been for 14 years now... it's way past ridiculous. We don't want to add a multiple lookup field, we just want to add a second account to our contact. This way i'll go on Jonh Doe and see in the account field : Company 1 and Company
Avoid None option in List Custom Fields
Does anybody know a way to avoid -- None -- option to be displayed in a List Custom Field? - With Mandatory option selected, you can prevent from saving if user select --None-- value. - With Default value selected, a different value than --None-- is
Limit tasks per due date
I am trying to figure out a way to limit the number of Tasks users can set on any given due date. But the number of tasks will differ for different users. Example - User 1234 will be permitted 100 tasks on each due date User 5678 and User 9012 will be
Getting email status through api
Refer to code below for getitng status of mail sent through CRM any modules. You can get the subject as a key in each response, so if you want to filter a specific email you just put an if condition for that. Note that the status will be given as a JSON
AMP HTML in Email Templates on Zoho CRM?
Hello Team! Is it possible to add AMP HTML features to the email tempalte in Zoho CRM? Im using an external service to create tempaltes and they provide me with AMP HTML features, or dynamic HTML modules. But when I try to add them to the Email template
Kiosk Studio: Function FIX for Date/Time Field (Keep getting wrong format error)
I am using the foillowing function in my Kiosk Studio to update the previously entered Date/Time field from previous screen to update that to the same date/time field in Lead Record. Every time I 'Save & Execute' I get a Success but with 'Date/time Format
Searching Notes & Attachments
Is it possible to have the search in CRM search the Notes and Attachments for key words
Call Counter
For context, our Leads Page is configured with three separate phone number fields. This allows us to store multiple contact numbers for each lead. We've also integrated a click-to-dial feature in our CRM system, which enables us to make calls directly
Scheduling Actions by Date and Reusing Webhooks in Journey Builder
Hello, I’m trying to use the Journey Builder feature, but I noticed that it only allows scheduling actions forward in time, not based on a specific date. It would be very helpful if we could schedule actions ahead of time based on predefined date fields.
How to have two separate views for different countries
Hi there, currently i have two offices i want to add to zoho crm, one office is in singapore which i have already implemented fully. The other office being malaysia which i want to implement. One issue with this is we want the malaysia office users to
Canvas Fit to Screen
Hi, is it possible to have the Fit to Screen tickbox unmarked as a default?
Deluge help - Looping in Zoho CRM
Hi! I am trying to create a function and struggling as I cannot get the function to repeat without. breaking. Trying to write a function (currently doing through schedule) to run daily. Searching for tasks that are 90 days or more overdue. If task is
Next Page