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.
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
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
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,
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)
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"
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: ---------------------------------------------------------------------------------------------------------------------------
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});
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 each
How 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="
Introducing additional Writer integration tasks in Deluge!
Hello everyone, We're delighted to announce the addition of new predefined Zoho Writer integration tasks powered by Deluge to our existing and ever-growing list. What integration tasks are and when to use them? Integration tasks facilitate transferring
Difference between functions
Hello everyone, I would like to know what is the difference between using direct code in the forms, either in a field change or when loading the form, and using a function, since thinking a little, at the moment of performing the function, I will have
Next Page