How to overcome Zoho Deluge's time limit?
I have built a function according to the following scheme: pages = {1,2,3,4,5,6,7,8,9,10}; for each page in pages { entriesPerPage = zoho.crm.getRecords("Accounts",page,200); for each entry in entriesPerPage { … } } Unfortunately, we have too many entries
Adding two custom fields
Sorry if it is too simple, but how can I create a custom field in Desk to add first and last name e.g. first Name + Last Name = Full Name Thanks Rudy
How do I connect a Google Cloud Project as a Custom Service
How can I connect a Google Cloud project as a custom service to ZohoCRM? I need to pull YouTube Analytics data into CRM, but I cannot use the included YouTube service as it does not have the scopes I need. Therefore, I need to create a custom service.
Clarification on Workflow and API Limits
Hi Team, Greetings! Are there any specific limits for the workflow, or does it consume API limits? Kindly share your thoughts on this.
Converting XML to JSON
Hi! I need to convert a variable in XML to JSON. Can i do it without using an API on deluge? I looked into the documentation but couldn't get any answers to this. Thank you in advance!
Adobe PDF Services API
Hello, Big stretch here, but I'm wondering if anyone here can point me in the right direction. I'm attempting to connect to an Adobe api to manipulate a pdf I have in WorkDrive. I'm able to get the Bearer token, but the next piece is to get the upload
Any good resources for scripting custom functions with deluge
Hello, are there any good resources for someone to start diving into scripting custom functions for automations with Deluge in Zoho Desk. I've read the articles in the KB, but when I want to write on my own I struggle. Basically I'm looking to automate
Creating a query table which counts the number of separate stage 1 and stage 2 payments per month.
Hi, I am trying to create a query table which counts the number of separate stage 1 and stage 2 payments from the same module received in the same month. The trouble I’m having is that if I try to calculate these value in a single table Zoho treats them
Client script - avoid an additional fetch
This is a script for onCustomViewLoad. I already have the record ID for the record to update. Is it possible to update a record without doing the additional fetch on line 4? var reservation_details = ZDK.Apps.CRM.Size_Run_Details.searchByCriteria(`Fulfillment_Status:equals:Available`);
ZDK client script code snippet to find all Open Deals for a given Account ID?
Looking for a ZDK client script code sample snippet to find all Open Deals for a given Account ID Trying to work with this, but I don't think it's gonna get me there. var leads = ZDK.Apps.CRM.Leads.searchByCriteria("((Last_Name:equals:Burns%5C%2CB)a
Client script error on searchByCriteria()
The error message for this code is: <!doctype html><html lang="en"><head><title>HTTP Status 400 – Bad Request.....etc.. product_id is correct. module api name is correct. product_id = reservations[i].Product_Lookup_Id.trim(); log(product_id); var ledger_entries_for_product
Please help with my first custom action
Hi :) I try to understand Deluge, but the help section is quite hard to understand. I can script (quite good) with Powershell and other scripting languages, so logic is not a problem, I can also create Business rules for our Zoho ticket system. What I
Update Subform when Lookup Module is updated
Hi team, I hope you are all doing great. We would like to create a custom function (Button) that updates the subform values when the source module's field/s is updated/modified. The subform is under the "Quotes" module. Quotes - API name of the Quotes
Convert String to Date
Hi There, I am trying to convert a string to a date with MM/dd/yyyy formatting but I cannot get it to work. The field Departure_Date_Website holds the value of: Sep 09, 2024 resp = zoho.crm.getRecordById("Leads", recordid); stringdate = resp.get("Departure_Date_Website");
What is COQL syntax for LIKE in a compound where clause?
This works: queryMap.put({"select_query":"select In_Production, GS_Due, Stage from Production_Orders where ((Stage = 'Preparing Order') or (Stage = 'Order In Production')) limit " + offset + ", 100"}); When I add the like condition it fails. queryMap.put({"select_query":"select
Syntax to fetch value from an Organization Variable in Client Script
Here's the call: var variable = ZDK.Apps.CRM.Settings.fetchVariablesById('4356038000115717184'); Here's the response: What's the syntax to get the "value" attribute?
Syntax to get Value from a standalone function
My function returns a Map(); How do get fetch the Value from the reponse? var response = ZDK.Apps.CRM.Functions.execute("get_estimated_lead_time_from_design", {"design_id": active_design_id});
Syntax for updating a record "stage" that is in a blueprint
I'm writing a custom function that will update a record's "stage" based on an change to a related parent record. The child records are all active in a predefined Blueprint. When I run the custom function to update the "stage" of the child record, nothing happens. For testing, I disabled the Blueprint on the child records, ran the function, and the "stage" field updated as expected. It seems the Blueprint is preventing my custom function from progressing my child records through the Blueprint stages/states.
Function error "HTTP Status 400 – Bad Request"
I have a function in a workflow that trigger when lead is created, the function is working fine for more than 2 years but recently we're having this issue were it fails and the reason for failure is HTTP Status 400 – Bad Request. However when I execute
getting UnAuthenticated Connection error when executing custom functions from employee account
Greetings i'm testing a custom connection between zoho books and expenses, i created the connection from zoho books side and enabled the "use logged in user credentials" option. the custom function uses invokeUrl to add entries to zoho expense. when i
Working with a Retainer Invoice in a custom function
I cannot find any documentation on fetching fields from retainer invoices with deluge. I have the retainer ID, I just need to use that to fetch two fields from the retainer: date of creation and the paid amount remaining on the retainer.
Pdf file upload
Hello everyone, I am trying to upload a pdf of an invoice into a file upload field and I keep getting the error that is it an invalid api call. If anyone could help telling my what i'm doing wrong that would be great. My code is below. Thanks. invoice_pdf
Connecting to Zoho Desk API with PostMan
Do you have instructions for connecting to the Zoho Desk API in PostMan for testing? I only found instructions for other Zoho Products but would like some guidance to test out API calls and responses.
Automatic Scheduled Call
Hi PLease can someone Help, I have written a script that will automatically add a scheduled call on a trigger, hoever it keep sadding the scheduled call as a closed activity. I cant seem to find the error contactDetails = zoho.crm.getRecordById("Contacts",contactId);
Deluge Script to update Custom Field in Product Details section of Quote record
Just wondering if anyone can provide insight on the Syntax required to access (update) custom field that have been created inside the Product Details section of a Quote or Purchase Order record? For example, we might have a Date/Time custom field In the
For each element, what is the good syntax?
Hello, I'm trying to use the for each element in Deluge in a custom function in Zoho CRM but I get error message no matter how I write the code. If I write like this: 20 for each x in notesinfo { 21 x.Parent_Id.id = contact_id; 22 x.$se_module = "SubContacts";
Annual Revenue
I want to show the auto populate a field in the account module with the sum of amounts in all invoices associated with that account in essence this would be my Annual Rev for the account. Is this possible?
Any opened Deluge repository ?
I plan to use a bit Deluge for some functions in our Zoho One, I was wondering is there were some open repository of scripts or snippets ? This would be a way for me to start learning :) As for a start, I'd like to get message in my Cliq, when I get an estimate approval request. This is parallel to the email notification, I just want to test with Cliq. Thanks !
How to update a CRM user using Deluge scripting?
I am trying to update a CRM user (not a Contact, but an actual user of the CRM system) using the following Deluge snippet: zoho.crm.updateRecord("users", 438564385646, {"alias":"abc"}); However, I am getting the following error: {"code":"MANDATORY_NOT_FOUND","details":{"api_name":"users"},"message":"required field not found","status":"error"} which required field is this complaining about? What is wrong in my code snippet?
Zoho Project Task Field
I'm trying to obtain a list of all Tasks that have been completed today within a certain project. I'm first using the getProjectDetails method to return the details of a specific project named "Ganar LLC". Then I use the following getRecords method to return the tasks from that project. All works well. Then I attempt to retrieve the completed time from each task by using the following for each/get method: projectData = zoho.projects.getProjectDetails("mazumaprojects","active"); //info projectData;
Users Module List in Deluge
Hello everyone, I am using deluge function for to get users list. I can take all user list but I need to specific field For example : GetUser.get("status"); status field but it is not working. Result null Do you have any idea? Note: you can see result of code from screenshot GetLead = zoho.crm.getRecordById("Leads",LeadID); PersonelID = GetLead.get("Owner").get("id"); GetUser = zoho.crm.getRecordById("users",PersonelID); status = GetUser.get("status"); info status ;
Create entry in Custom Module when creating Deal & Populate Lookup fields
I have a custom Module titled "Agreements" which is CustomModule10 Whenever I create a Deal I want an Agreements module entry created and pre populated with information from the Deal. 3 Lookup Fields are in CustomModule10 Contact Deal Account
Counting the completed tasks for a contact
Hi Community. We use tasks to track our emails, calls and voice messages. We are putting together a prospecting process that is based on a 90 day cycle of 8 outreaches. After the 90 days we take 60 days off and start the 90 day cycle again. Currently i need to look through all the activities for the contact, eliminate the completed tasks older than 90 days and add up the recent activity. Is there is a easier more automated way to do this? I know that i can run a report but I would like to
How to use hash sha256 in zoho creator?
Hello everyone, I need to ask you about hash function in zoho creator. Because I want to import some data from another website, and in that website, it need to has their signature in SHA256. In PHP, its very easy, you just use the HMAC function: "string hash_hmac ( string $algo , string $data , string $key [, bool $raw_output = false ] )" But its so hard in zoho. Its cost me 1 month to find solution for this. If there is no way to has string by SHA256 in zoho creator, could anyone please give
Script Popup
When managing Leads in Z CRM, when employee answers a phone call or calls a lead, would like for a predefined script to pop up that is populated with the Lead's name. Suggestions? JLW