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. WhetherHow 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 entriesWhat'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 200Error 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), theAdding 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 RudyContinue 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 thinkWhy 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- theDeluge 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 removedHow 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 ChromeAdd 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 ofFunction #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 toHelper 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 toDeluge 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 buttonlist.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. ButCreating 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 extensiveDeluge 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 servicesI 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 uploadDelete 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 tasksHow 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 assumingHow 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 automateCreating 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 themSyntax 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/66bb923956e10db1cec007464d814fc05465c85001d1c5d467016f0ed1c70f29Client 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 fillZDK 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)aError 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.htmlPlease 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 IUpdate 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 QuotesError 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. ThanksConvert 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
Access your files securely from anywhere
New to Zoho Recruit?
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Bigin?
Announcements
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. WhetherFunction #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 toCreating 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 extensiveDeluge in Zoho services #5: Zoho Connect
Hello everyone, Greetings from Deluge! Whoosh 🌬️ That's how quickly the first two months of 2023 came to an end, and now we're in full speed ahead! We hope you found the previous post in this series useful and are now back with our latest post. Basically,
Zoho Developer Community
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
ご検討中の方
Zoho Sprints Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho Books Resources
Zoho Projects Resources
Qntrl Resources
Zoho CRM Plus Resources
Migrate to Show’s New Community
A place to share, discuss and stay updated about everything relating to Zoho Show presentations.
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Design. Discuss. Deliver.