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
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
Desk 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 but
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
When will you rollout Creator Blueprint Tasks?
For existing users...
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
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
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
Issue with JSON Formatting in invokeURL task
Hello Zoho Community, I'm reaching out for assistance with an issue I've encountered while trying to integrate Zoho with HubSpot using a webhook trigger. Despite following documentation and trying various configurations, I consistently encounter an "Error
How 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 assist
Deluge - Our interim solution for Gmail's policy changes
Earlier this month, we shared the news about the upcoming changes in Gmail's guidelines and their impact on send mail tasks in Deluge. We've since received feedback from users expressing concerns about how these changes will affect their email communications,
How 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 the
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
Deluge monthly roundup - October 2023
Hello Deluge enthusiasts, Deluge has come a long way over the years, and October was no different, so let's dive right in to the highlights from the past month! toDateTimeString Rebranded Zoho Subscriptions tasks Indian locale support in toWords() - -
Gmail's new guidelines and their impact on Deluge
Hello everyone, We'd like to inform you about the upcoming changes to Gmail's guidelines, set to take effect on February 1, 2024, which will have implications for send mail Deluge tasks across Zoho services. Gmail is rolling out policy changes with the
Integration with Google Groups API, and OAuth2
Has anybody successfully created a connection to Google Groups using OAuth2? Had a long session with Zoho Support today, and neither I nor they could work it out. Essentially: - new custom connection to Google Groups, like all connections, requires completion of settings shown in attachments 'Zoho Connection creation' x2 - In the corresponding Google API section ("Google Credentials' attachment), I've created credentials (details of which are inserted above) - When the connection is created, Google
postUrl 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. Thanks
How 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)
CRM module name capitalisation bug ?
HI, I''m writing a deluge script from Desk to create a task in CRM. All is good when I deal with a lead, but not when a contact is involved. It took me days to figure it out. It might be a bug. Here is a snippet of my script // Ticket Description taskMap.put("What_Id",{"id":ticketContactId});
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");
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 is
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"
SendMail 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.
Deluge: Ready-to-use Artificial intelligence tasks
Hello everyone, AI in business is evolving. We have slowly begun to trust machines with intellectual tasks that are usually performed by humans. Keeping up with the trend, Deluge offers a set of built-in artificial intelligence tasks for prediction and language processing operations. In this post, let us take a look at the existing Deluge AI tasks and the new addition to the set - zoho.ai.translate. AI task Description Analyse Sentiment Interprets the input text to predict if it is a positive, negative,
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:00
Deluge 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 all
Function-12: Add pre-defined notes to records in a click
Welcome back everyone! Last week, we learnt how to turn a contact into a vendor. This week, let's look at a custom function that helps you add pre-defined notes at the click of a button. Business scenario: Every bit of information shared by prospects in a sales call gets you closer to making the sale. Keeping a track of these information not only helps you pick up from where you left off for subsequent calls, but also helps tailor your offering by putting the prospects in appropriate campaigns, set
Deluge Core Codes
If you share the deluge core code with us, we can develop it as open source. In this way, we have a fast development process and we can develop what we need and make Deluge a more comprehensive language.
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
How to automate a Lookup field using deluge?
I have a Multi-Select Lookup field that I need to auto-populate when a 'NETO' text field is populated. Or, maybe make the Lookup field look up for the records based on the 'NETO' text field. I tried creating a script to copy the 'NETO' text field to the
Write Webhook by Deluge
Hi , I am trying to write webhook by deluge to integrate our OA system. but it pops up error. However when I use CRM webhook function , It works. But I don't know what's the difference of them. Can you guide me how to repair my deluge rules. May I know
What is the replaceAll syntax to replace " " with a single tab character?
What is the replaceAll syntax to replace " " with a single tab character?
Sending Info to Custom Module Using Function
Hi, I have set up a custom module called "Entities" in Zoho CRM. Each Entity record can be linked to several Product Records. I want to write a function which will sum the "Amount" fields from every Product record associated with the Entity and then update
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: ---------------------------------------------------------------------------------------------------------------------------
Next Page