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 200Deluge should permit a connection to be set with a variable
Hello, Being one who occasionally likes to post code in the forums, I try to make anything that the end user needs to define be present at the very top of the script so that those who want to implement the script won't have to hunt through lines of code,How to set the width of the columns in a script
Dear community, hope you all are doing great, I'm creating this thread to check the following: I have a deluge script that creates a PDF file with a table and I'm strugling to set the width of the columns. Here's the snippet of my code which creates thisContinue 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 removedSendMail in CRM Deluge function rejects a validated email address
In a CRM Deluge function, the email address is considered invalid. Is there another method by which it can be validated? It's unacceptable in my current situation to use either the zoho.loginuserid or adminuserid as the From address.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'));Deluge script to add Mail Task
Has anyone out there created a custom function to create a Zoho Mail task? I'd be interested in hearing how you accomplished it. Sample code is appreciated!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 ofWhy Are Arrays Not Allowed in Webhook Payloads?
Hello Support, I would like to understand the reasoning behind the limitation where arrays are not accepted in API payloads. Could you please clarify why this restriction exists? It seems like arrays would be a natural and efficient way to handle multipleDesk Search tickets only returning 10 records
I am attempting to make a schedule to make tasks to review older tickets but it is only getting ten records. The response gives a count of much more then 10. is there a limit to the size of the return I have tried setting the limit parameter higher butDeluge 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 servicesSearchRecords Search Limit?
Hi, I'm trying to clarify how many records the deluge searchrecords function will search through. I expect a return of 10 or 20 but need to search all 8000+ records. Is that possible? ThanksHow can I set the task layout when creating a project with Deluge
Hi, I am automatically creating a new project in Zoho projects with Deluge. I cannot find any documentation on how to set the task layout, which needs to be set at the project level upon creation, as far as I can tell. I can see the response when theDelete 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");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 assumingDeluge and Javascript/Node.JS code examples (and others?) should be added to the API docs instead of just CURL
Hello. While I realize that it's not rocket science to convert from CURL, it would undoubtedly save a lot of time if the code examples for Zoho's own app API documentation also included examples for both Deluge (which I'm kinda surprised isn't there,)Version of PDF in Zoho Writer Conversion API
Hello, I was wondering if anyone could tell me the version of PDF that is output when using the Zoho Writer Conversion API Convert Documents with filename | Zoho Writer | API Reference We're using a function in CRM to grab an DOCX attachment from a record,EMAIL TEMPLATES | DELUGE
Good day Zoho Team, I am trying to create a custom function on sending email notification with different conditions, Is it possible to insert the created custom email template to my custom function? The email template contains content with several placeholders.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/66bb923956e10db1cec007464d814fc05465c85001d1c5d467016f0ed1c70f29When will you rollout Creator Blueprint Tasks?
For existing users...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.htmlHow can I create an external share link with upload option via deluge scripting?
I have a requirement, where i need to create a folder and get the external share link of the folder with upload option via deluge , so that I can collect documents from my external vendors. Please assistpostUrl method content length limit workaround
Hello, I'm currently trying to call an API in Deluge and it's giving me the "Invoke url response content length cant be greater than 5 MB" error. Is there a workaround for this? I tested the API on postman and it returned about 7 MB worth of information.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. ThanksHow to correctly use workdrive integration to upload file from file_upload field?
I have no idea if this is supposed to go into WorkDrive or Creator forums or Deluge but I'm hoping someone can help me out either way. So according to the information on the workdrive integration with creator to upload file (https://www.zoho.com/deluge/help/workdrive/upload-file.html)Confirming a Sales Order
Hi, A Sales Order is created in Inventory by a Woocommerce plugin (Wordpress) . The SO is in draft, I'm currently using a zoho flow and a deluge script to update some fields and want to set the SO as confirmed. There is no approval blueprint. The SO isNo 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"hoursBetween() returns zero
Why does this code: info current_date_time_zoho; info customer_sent_email_on; info hoursBetween(customer_sent_email_on, current_date_time_zoho); Produce this result with hours being zero? The answer should be 3. 2023-09-11T17:16:19-05:00 2023-09-11T14:58:51-05:00Deluge Arizona Timezone is Inaccurate
Hello, We're running into an issue with the Arizona timezone. Zoho seems to treat 12:30 PM PST as 11:30 AM in the America/Phoenix timezone, however this is not accurate. If I understood correctly, almost all of Arizona is in Mountain Standard Time allWhat is the replaceAll syntax to replace " " with a single tab character?
What is the replaceAll syntax to replace " " with a single tab character?Combine searchRecord and distanceBetween
Hello! I need your help. Is there a way to combine searchRecord with distanceBetween? I want to have all records that have a certain distance between an address from the record to another address. How can I manage that task?Error code 7049 - No record available with the specified record ID
Hi, I am working on a data migration, reading the data from the Certifications tabular section from the employee form to insert them in a new form (Certifications2). I created a record in my new form for each employee using the import. My script: ---------------------------------------------------------------------------------------------------------------------------Convert a table within a Zoho Writer document into a map or collection
Hello, is there any way to take a table within a Zoho Writer document and convert that table into a map or collection. For example, assume the first row of the table are the keys and any subsequent rows are values for those keys. Then perform a for eachHow to include & ampersand in a search
How do I escape the & to do an exact search on this text string in the workdrive find folder api? name = "Aerial Bound Tumble & Cheer"; url_url= "https://www.zohoapis.com/workdrive/api/v1/teams/" + team_id + "/records?search%5Bname%5D=" + name + "&filter%5BparentId%5D="How to deal with pagination?
Hello guys, I am stuck in a problem with pagination. I am building an app that retrieves all the items from Inventory and we have more than 200 items, so the invokeURL has pagination. According the API, the field has_more_pages indicates if there areNext 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 Learning Series – Best Practices in Deluge | December 2025
We’re excited to bring you the next session of the Deluge Learning Series, focused entirely on writing cleaner, faster, and more reliable Deluge code. In this edition, we’ll dive deep into the essential best practices every Deluge developer should follow[Integration Edition] Deluge Learning Series – Custom API with Deluge | November 2025
We’re excited to conclude this four-month Integration Edition of the Deluge Learning Series: Session 1 – Integrating Zoho Apps with Deluge Using Built-In Integration Tasks Session 2 – Integrating Zoho Apps with Deluge Using invokeURL and invokeAPI SessionDeprecation of the Zoho OAuth connector
Hello everyone, At Zoho, we continuously evaluate our integrations to ensure they meet the highest standards of security, reliability, and compliance. As part of these ongoing efforts, we've made the decision to deprecate the Zoho OAuth default connectorChanges to the send mail Deluge task in Zoho CRM
Hello everyone, At Zoho, we continuously enhance our security measures to ensure a safer experience for all users. As part of our ongoing security enhancements, we're making an important update on using the send mail Deluge task in Zoho CRM. What's changing?Introducing AWS authentication for connections in Deluge
Hello everyone, We're incredibly excited to announce the all-new AWS authentication for connections in Deluge! This highly anticipated feature simplifies connecting to Amazon Web Services, opening up a world of possibilities and allowing you to seamlessly
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.
Zoho Show Resources
Zoho Creator Resources
Nederlandse Hulpbronnen
Zoho Inventory Resources
Zoho CRM Resources
Sticky Posts
Function #41: Sync Associated Subforms!
Welcome back everyone! The last custom function showed how to update a Contact with Product details from it's Related list in Deals. This week, let's look at a function that lets you update subform records in two modules simultaneously when one of them is updated. Business scenario Let's look at how subform helps in an education institution that has deployed Zoho CRM. National Public School, Austin (made up, of course!) has set up Zoho CRM and it follows the same relationship pattern of "Students",
Top Contributors
Ashwin Vishal R
gautam.raman