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?
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.
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
Syntax for updating a record "stage" that is in a blueprint
I'm writing a custom function that will update a record's "stage" based on an change to a related parent record. The child records are all active in a predefined Blueprint. When I run the custom function to update the "stage" of the child record, nothing happens. For testing, I disabled the Blueprint on the child records, ran the function, and the "stage" field updated as expected. It seems the Blueprint is preventing my custom function from progressing my child records through the Blueprint stages/states.
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 are
Deluge Custom Function - Product_Details wrong data type when parsing back to Purchase Order
Please note I'm not a deluge expert, but I have attempted to tweak a custom function but seem to be having issues with the last operation. Essential the function should do the following: Get the Quote Details Iterate through the Quote Product Details
Storing 3000+ elements in an array
Hi, I have a very particular use case. I need to store 3000+ throwable domains in an array for a custom function. Use case: whenever a lead is created I want to check if the email provided by the lead is within these domains or not, we have a 3rd party
Zoho People - Auto update Date field
I am new to Deluge Scripts so am posting this issue here so someone can assist me. I am working on Zoho People and tried to use the form validation but cannot figure it out. I have the employee form with multiple fields and a linear section with the following
Function error "HTTP Status 400 – Bad Request"
I have a function in a workflow that trigger when lead is created, the function is working fine for more than 2 years but recently we're having this issue were it fails and the reason for failure is HTTP Status 400 – Bad Request. However when I execute
Syntax Request for a Date/Time
I need the syntax for the following this code that is correct: dealRecord = zoho.crm.getRecordById("Deals",DEAL_ID); appsubmitRecord = dealRecord.get("App_Submitted"); info appsubmitRecord; IF I need the syntax for how the "App_Submitted" is 10 days or
Deluge 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,
Issues with "Connections" panel
Hello, I have summarized a couple of issues that i think should be fixed with the connections panel (in Zoho Books, Zoho Inventory, etc.). 1. Please don't translate to my browser language. It is completely redundant and and makes it very hard to understand
read compressed file in GZ format, Ex. impression-day-2019-01-22.json.gz
We have a file upload on S3 bucket in with .JSON.GZ extension. We are trying to write a script to read that file, unzip that file and then upload it to ZOHO Workdrive. Code is below: ========================================================== zip = invokeUrl
Support Scope in Client Credential grant type
Hello, As Scopes are supported by this grant type, It's useful to have this option (and we need it) in the Create Service form like Authorization Code grant type Thanks
Can't zoho.ai.parsePhoneNumber be savvy enough to extrapolate the country from the phone number's country code?
Ok. So one of my Deluge scripts involves extrapolating the country name from the country code in the phone number, for which I was going to just create some sort of lookup table. But... then I came across the zoho.ai.parsePhoneNumber function, and initially
A peek into Deluge's file functions
Hello everyone, Recognizing the importance of files in Zoho products, Deluge implements FILE as a unique type of data. It also comes with a set of built-in functions that operate on FILE data type to identify the properties of files, zip or unzip files, and more. In this post, we will cover Deluge file functions that let you work with your digital documents using Deluge. Files in Deluge Files in Deluge must be fetched from the web or cloud service. It doesn't operate on offline files. The following
Change Date's Language
Hello! I'm usign this function to change the format of the date. This works fantastic. Is there any way I can change the language of it? I need to translate it in Spanish since im always receiving it in English. fecha_apertura.toString("dd-MMM-yyyy")
Merge and Send
I have a custom function that uses zoho.writer.mergeAndSend it has been working for months and in the past few days it has stopped working is there an issue on the Zoho side that may have caused this? I have tried revoke and reconnecting the connection,
How to escape characters in ${!Leads.First_Name}
I want to use this string in a call to replaceAll() replaceAll( ${!Leads.First_Name}, "some text"); How to escape the necessary characters?
In 'zohoapis.com/crm/v4' a space character matters. FYI;
The delimiter for the list of fields to return is a comma ",'. However, if there is a space between the comma and the the next field name, the field name is excluded from the result set I did not test this with earlier version of the api.
Where can I find API documentation to get file attachments from custom module?
Where can I find API documentation to get file attachments from custom module?
Why can't I add an event to my calendar in Zoho Creator/Deluge?
I am trying to build a script using Deluge in Zoho Creator which will create a calendar event in Zoho Calendar when a new form is submitted or an existing form is updated. I am using the Zoho Calendar connection with the following code: response = zoho.calendar.createEvent("<calendar-uid>",
Deluge in Zoho Services #4: Zoho Sheet
Hello everyone, Greetings from Deluge! It's been a while since we connected, but now we're back in action, continuing our series of posts on Zoho services that support Deluge. We hope you found the previous post in this series useful. In today's post,
Search in Zoho Desk contacts by Boolean custom field - using deluge
Hello, I am trying to search for contacts that cf_sync is false here is the script: contacts = zoho.desk.searchRecords(orgid,"contacts",{"customField1":"cf_sync:false"},0,100); info contacts; but the output is: {"errorCode":"UNPROCESSABLE_ENTITY","message":"The
Next Page