Deluge Tips & Tricks: Mastering dates and times
Hello everyone! We're bringing back our Deluge Tips & Tricks series, where we show you how to make the most of Deluge for achieving a wide range of use cases. Working with dates and times is a fundamental part of almost any business application. Whether
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
What's wrong with this COQL?
What's wrong with this COQL? Code returns "invalid operator found". SELECT id, Name, Stage, Account, Created_Time, Tag FROM Production_Orders WHERE (Account = '4356038000072566002' AND Stage NOT LIKE '%customer%') ORDER BY Created_Time DESC LIMIT 200
Error Code 4: Invalid value passed for JSONString
Okay, I want to start by saying I know I'm a terrible scripter, so sorry if this is a dumb mistake. I just can't figure it out, even with LLM help. Here's my code: // --- Input Variables --- customer_id = salesorder.get("customer_id"); so_id = salesorder.get("salesorder_id");
Dynamically Sync zoho.adminuserid with Current App Admin
Hello Zoho Team, We hope you're doing well. We’d like to request an important enhancement to the Deluge sendmail task functionality. As per the current behavior, in most Zoho services (excluding Zoho Cliq, Zoho Connect, Zoho Mail, and Zoho Sheet), the
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
Continue after error for each loop on invoke url
Hello. I'm trying to upload files to workdrive using invokeurl. It goes through a list of urls using for each. Sometimes the file is larger than 5mb. The whole workflow stops in that event. I'd love a work around to upload larger files, but I don't think
Why is my deluge code not executing properly? (New and learning deluge)
I'm trying to update a sales order number through deluge for an automation I'm trying to build. What is wrong with it? /* replacing SO with SOR for sales order pre-fix */ SO = salesorder.get("salesorder_number"); replace = SO.replaceFirst("SO","SOR");
Breaklines In Deluge/OpenAI
I've created a model in OpenAI to take a transcript, summarize it in bullet points, and e-mail it. I'm able to format the e-mail intro and ending (the text I can control in Deluge), but I'm not able to format what gets sent and returned to OpenAI- the
Deluge Script Converting Time Wrong
Good day everyone. I'm hoping someone can help me solve this problem. With the help of several of you, I created a script that will allow me to convert a date/time field to a written field. It works great but I didn't want the seconds to show so I removed
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.
All Deluge environments draggy! Negatively impacting productivity
Hello, I have been using Zoho flow, CRM, Project, etc to develop custom functions, integrations. etc. for over 5 years. However, just about 3 days ago, I observed the deluge integrated environment is now acting draggy across all Zoho products using Chrome
Add Owner to deluge-created module record note
Is it possible to include the "owner" aka "creator", of a Note when creating it via delulge? This sets "superadmin" as the Note creator. I need to override it. notemap = Map(); notemap.put("Parent_Id",program_contact_id); notemap.put("Note_Content",program_contact_data.get('Note'));
How to Iterate a Function in Zoho Desk Workflow with Delay Between Calls?
Hi everyone, I’m working on a function in Zoho Desk that searches for a specific ticket record. If the ticket is not found, I need to retry the search multiple times with a delay between each attempt until the ticket is located or a maximum number of
Function #28: Automatically calculate Customer Loyalty points
Hello everyone, and welcome back to our series! Today, we're excited to share a workflow designed to streamline the management of loyalty points. Many businesses offer incentives or rewards in the form of loyalty points to their customers as a way to
Helper Functions and DRY principle
Hello everyone, I believe Deluge should be able to use 'Helper functions' inside the main function. I know I can create different standalones, but this is not helpful and confusing. I don't want 10000 different standalones, and I dont want to have to
Deluge in Zoho Services #3: Zoho People
Hello everyone, In today's post, let's explore the ways you can use Deluge to achieve more with Zoho People. In addition to supporting connections, Zoho People supports Deluge in the following four areas: Validation Workflow Scheduler Custom button
list.contains(object) returns null instead of false when list is assigned to null
Consider the following code: list1 = list(); list1 = null; info list1.contains(1); Info returns: null (see attached screenshot) According to the documentation of List.contains(), the only possible return values of List.contains() are true and false. But
Creating a Gmail integration using custom connectors
Hello everyone! Greetings from Deluge. Following up on our series aimed at exploring the capabilities of Deluge, today we'll take an in-depth look into the Deluge custom connections that can be created across Zoho services. Deluge boasts an extensive
Deluge functions for Zoho Campaigns
Zoho's website lists Zoho Campaigns as supporting Deluge: https://www.zoho.com/deluge/help/zoho-services-supporting-deluge.html But when I try to call Zoho Campaigns Deluge functions from Zoho CRM under Integrations, I cannot find it in the list of services
I will kill myself
I spend almost a hour trying to figure out why nothing changes and re-running my code. It`s looks like a meme, for real. ✅ Error Successful ✅
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
Delete Registro no Zoho CRM usando Zoho Deluge
Pessoal, eu estou precisando fazer uma script para apagar milhares de registros Potenciais dentro do meu Zoho CRM, mas não estou conseguindo encontrar a função específica para apagar 1 único registro. deleteResponse = zoho.crm.delRecord("Deals", potencial.get("id"));
What is the format string for toDateTimeString to conver to a CRM date-time field?
This ain't it. toDateTimeString(time,"yyyy-MM-ddThh:mm:ss","CST");
Deluge integrated tasks not working!
It seems like the integrated tasks of deluge no longer work. We received a couple months ago from support a suggestion to avoid using the integrated tasks and work with the APIs. Today we realized that it's very blurry to understand which integrated tasks
How do you sort an MapList based on value of Key
Hello, How do you sort a Maplist based on the value of one key. For example, let's say you have ; product_Detail = {{"company":"Zoho","Product":"Creator"},{"company":"Alphabet","Product":"Google"},{"company":"ChannelsTV","Product":"TV"}}; And assuming
How yo upload a file to workdrive
Hi, I need to upload a file from a Zoho CMR attached field to a Zoho workdrive folder. This is the function: map sube_pasaporte_WD(string xurl, string myurl, string carpetawd) { fichero = invokeurl [ url :xurl type :GET ]; info fichero; response = zoho.workdrive.uploadFile(fichero,carpetawd,myurl,true,"zoho_workdrive");
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
Syntax to create Books Package via API?
I want to create a Package from an existing Sales Order https://www.zoho.com/inventory/api/v1/packages/#creating-a-package I pass to the Packages Create function items_list the output from the Create Sales order. Here is the JSON. https://workdrive.zohoexternal.com/external/66bb923956e10db1cec007464d814fc05465c85001d1c5d467016f0ed1c70f29
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`);
Get data from APIrequest gives null values
Hello, We are facing problem with geting values from CRMAPIrequest. The function was executed when a contract was signed by zoho sign, the data was sent by zoho CRM API rest, and then function was getting recipient email to match the deal and then fill
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
Error with Zoho Cal API Search Request
I keep getting an error when running an API request for Zoho Cal in Deluge using the Get Event Through Search. Does anyone have any ideas? Error: {"error":[{"description":"Extra parameter found.","message":"EXTRA_PARAM_FOUND"}]} API DOC: https://www.zoho.com/calendar/help/api/get-event-through-search.html
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
Error in using Google Sheets API to add value in Google Sheets
Hi, I am using the following code to add values in google sheets through custom functions. I am not able to figure out correct way of adding values in the invoke uRL. Can anyone help me out. I am attaching the code and the error message which we are getting.
Creating Sub Tasks in Projects Using Deluge
Hi I would like to create sub tasks in Zoho Creator. Aside from using the API, is there any way to do this in deluge? It's an integration from Zoho Creator, so using deluge seems like the straightest way to do it. Thanks
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");
No Output from Custom Function
Hi Guys, This is my first ever attempt to write in deluge so please go easy. I needed to create a custom function in Zoho Flow - to turn a full name string like "Ian Robert Smith" in to a separate output of First Name and Last Name i.e. "Ian" and "Smith"
Next Page