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, GooglepostUrl 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)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 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"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.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 allFunction-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, setDeluge 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":"selectHow 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 theWrite 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 knowWhat 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 updateCombine 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 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="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 transferringDifference 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 haveSyntax 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 areDeluge 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 DetailsStoring 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 partyZoho 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 followingFunction 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 executeSyntax 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 orDeluge 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 understandread 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 = invokeUrlSupport 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 ThanksCan'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 initiallyA 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 followingNext Page
Access your files securely from anywhere
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
Updates to Analyse Sentiment task
Hi there, The Deluge team continuously strives to improve the performance of the various Deluge tasks, and as part of these efforts, we have made significant backend changes to one of our AI tasks, Analyse Sentiment (zoho.ai.analyseSentiment). What isCreating 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 extensiveDeprecation of Google Drive and Google Sheets connections in Deluge
Hi there, We hope you've been enjoying your experience with Deluge. We would like to inform you about important updates to the Google Drive and Google Sheets connections in Deluge. Google has identified and notified us about sensitive scopes within theseFunction #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 toDeluge - 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,
Most Discussed Topics
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 Chrome
Zoho Developer Community
Zoho DataPrep Resources
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
Zoho Campaigns 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
David Afolabi
Ashwin Vishal R
Anand M B
Andres
julien