How to trap and handle "Failed to execute function Value is empty and 'get' function cannot be applied Line Number:30"
How does one trap, and then handle, this error? Failed to execute function Value is empty and 'get' function cannot be applied Line Number:30Retrieving dropdown values in a tabular section
Hi, I would like to retrieve all the values from a dropdown list for a field in a tabular section from the employee form in a deluge script. Any help would be appreciated. ThanksAdding Account tags to associated Project
Hello, I am trying to edit a function that I created to also pass along the account Tag to its associated project. The function I created below is used to create and associate a project to its account (I created a workflow to kickoff this function onceZoho
When creating a connection in CRMPLUS to Zoho OAuth, I am getting an "Invalid Operation Type Scope does not" page when connecting. Scopes: ZohoCRM.bulk.ALL ZohoCRM.Files.CREATE ZohoCRM.Files.READ ZohoCRM.functions.execute.CREATE ZohoCRM.functions.execute.READIs there a way to force a write commit?
I have Deluge code, triggered by a workflow, that creates a Workdrive folder structure. There are times when the workflow must be getting triggered in quick succession, because two folders get created. My code properly checks for the existence of theWhat is the data map() for url field?
I need to set a URL field via deluge. how to specify the data map for each sub-piece of the url field type? url link name title Thank you.reformat eoMonth() function
I am trying to get the eoMonth() to produce year-month-day since that is the only accepted input in my flow for updating a module to accept a date. However using this function shows month-day-year. Is there anyway to resolve this?[TYIA] Zoho Campaigns using Deluge
Hope all is well. I would like to learn systematically to develop Zoho Campaigns using Deluge, is there any training/websites that would be helpful? Any trivial information would be helpful and appreciated. Thank you in advance.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 thisGetting thread content in bulk?
With the Desk API, do you have to get each thread individually with a separate API call in order to retrieve the content of a thread, or is there a way to get the content back when listing the threads?Get the context ticket ID to move it to a different department using custom functions.
Hi, My goal is to move a ticket from one department to another on a field update, using custom functions. I'm picturing the ticket as an object, so when I have it opened in front of me, and I want to apply the function to it, how do I pass the ticketAll Zoho integration tasks to follow only OAuth authentication - We're stopping new Authtokens generation
Hello everyone, Deluge provides a set of pre-defined integration tasks that allow users to integrate with different Zoho services. These tasks are API driven, i.e., executing these tasks trigger API calls to the respective service's API in the backend.Need Custom Function that will send an email template/notification to user
We have a custom function that is triggered when a new ticket is created. Inside that custom function we have some conditions that determine next steps. in one of those conditions we want to trigger an email notification to be sent. How do we use DelugeDeluge Training
I have been beating my head on the Deluge wall for over a week now. Watched dozens of videos. Read lots of help forums. Read docs galore. Is there any decent training available? Please something more than "it is so simple...." or "here are all the great things it can do" Most of the stuff I find is pre 2018 and does not reference the current functionality.Deluge API - to set Tax
Hi, Has anyone managed to update VAT rates through the API using Deluge? Thanks, Andrew.Working with ranged values Zoho Deluge
Dear community, I'm creating this thread because I need help to archive the following: I have a system that must receive the numeric value "requests" and based on this value, it must give me the output telling me on which plan this number of requestsField not updating
Hi All Please have a look at my code and guide me where I have gone wrong, I juts cannot get the field to update in the form "Expiry Date" even though it says the codes executed fine. records = zoho.crm.getRecordById("Contracts", 4994407000000384299);Field not updating
Hi All Please have a look at my code and guide me where I have gone wrong, I juts cannot get the field to update in the form "Expiry Date" even though it says the codes executed fine. records = zoho.crm.getRecordById("Contracts", 4994407000000384299);Using invokeurl to upload files to Google Drive
I'm running into an issue when using invokeurl to attempt to upload files to Google Drive using the Google Drive API v3 When I run the code below I get this error: "Missing end boundary in multipart body" However, I define the boundary string in the header,I need Documentation for full argument options or combinations of .get() when v2 api invokeurl is used.
Hi i am using the v2 api to create record and trying to get the new record id. example: dlist = List(); dlist.add(paramap); dmp = map(); dmp.put("data",dlist); createResp = invokeurl [ url: "https://www.zohoapis.com/crm/v2.1/Quotes" type: POST parameters:Deluge in Zoho Services #2: Zoho Writer
Hello all, We hope you found the previous post in this series useful. In today's post, let's explore how Deluge works in Zoho Writer. Zoho Writer supports Deluge in the following three areas (workflows): Workflow 1 : Execute a Deluge function after aIs there a way to automate adding Client Users to a Project?
I've been struggling to find a solution to this issue in these forums. Is there any way I can automate so that upon Project creation, Client Users are automatically associated from the CRM Contacts module?Working with a Retainer Invoice in a custom function
I cannot find any documentation on fetching fields from retainer invoices with deluge. I have the retainer ID, I just need to use that to fetch two fields from the retainer: date of creation and the paid amount remaining on the retainer.Pdf file upload
Hello everyone, I am trying to upload a pdf of an invoice into a file upload field and I keep getting the error that is it an invalid api call. If anyone could help telling my what i'm doing wrong that would be great. My code is below. Thanks. invoice_pdfZoho Writer Template filled in by form to create new Zoho Writer document , then using a function to share and send link to the new Writer document to an email address
Hi folks, We have set up Zoho Writer template that takes a user input from a form and then created a new Zoho Writer document into a folder. This is done by using the Zoho Writer automation feature for Forms, and under the heading: OUTPUT SETTINGSConnecting to Zoho Desk API with PostMan
Do you have instructions for connecting to the Zoho Desk API in PostMan for testing? I only found instructions for other Zoho Products but would like some guidance to test out API calls and responses.Automatic Scheduled Call
Hi PLease can someone Help, I have written a script that will automatically add a scheduled call on a trigger, hoever it keep sadding the scheduled call as a closed activity. I cant seem to find the error contactDetails = zoho.crm.getRecordById("Contacts",contactId);How to iterate over all records?
I need to iterate over all records in a module (4,500). Is this still the best way: lst_iterator = {0,1,2,3, etc....}; { records = zoho.crm.getRecords(moduleName,iterator, 200); for each item in records { // Do something } }Update Call Subject with Call result afer the call is completed
Hi I need to update the call Subject with the call result once i have completed the call. I have tried a few options but keep coming short.Sending data from Zoho Projects to Zoho CRM
Dear community Hope you all are doing great! I'm opening this thread to understand how can I setup the following workflow between my Zoho Projects portal and my Zoho CRM portal: In my project, let's call it PROJECT X, I have new incoming bugs registersDeluge in Zoho services #1: Zoho Mail
Hello everyone, We hope to present the various Zoho services that support Deluge through a series of posts. In today's post let us explore Deluge in Zoho Mail. Filters is the Zoho Mail feature that encompasses Deluge. When a Deluge function is associatedPull Data from Zoho Books to Contacts Module in Zoho CRM
Hi, I've integrated my Zoho Books with Zoho CRM. For every contact that I have in my Zoho CRM, I wish to have the following three fields: 1. Total Sales 2. Total Receivable 3. Due Receivables (based on the Account the Contact belongs to) How should IHelp with zoho.crm.getRecords
Dear community, I have one question about a deluge function. I'm using the function zoho.crm.getRecords("Accounts", 0, 200, {"cvid": 3966036000418539959}); To return all the records from my custom view id 3966036000418539959. The issue I'm facing isBooks API error 3044: "email address can not be blank for contacts associated to recurring invoices"
Hi, I am having this issue but do not understand why. I get this error when I try to update contact in Books Example: params: {"JSONString":{"contact_name":"CUSTOMER NAME","currency_id":"xxxxxxxxx","phone":"11111111111","billing_address":{"address":"ppppppppppppp","state":"DDDDDDDDDDD","city":"cccccccccccccc","zip":"sssssss"},"contact_type":"customer","custom_fields":[{"api_name":"cf_rut","value":"111111111111111"},{"api_name":"cf_raz_n_social","value":"DDDDDDDDDDD"},{"api_name":"cf_c_digo_iso","value":null}],"contact_persons":[{"email":"mail@server.com"}]}}File Attachment API does not return a value when there are no attachments
I need to know if a call to: https://www.zohoapis.com/crm/v2/{module_api_name}/{record_id}/Attachments has null results. It appears to return nothing, not even "null." Video explanation here: https://workdrive.zohoexternal.com/external/554971171ccfRecent updates to built-in functions in Deluge
Hello everyone, Deluge offers more than 200 built-in functions for widely performed actions, like adding specified number of business days to a date, removing extra leading & trailing spaces in a text, and so on. You can refer to our help documents andExtracting data out of XML in Deluge
Hi, I'm getting a data through API from GET function such as get_data = getUrl(" "); info get_data; This responds with: <DTDCREPLY xmlns="http://dtdc.com"> <CONSIGNMENT xmlns=""> <CNHEADER> <CNTRACK>true</CNTRACK> <FIELD name="strShipmentNo" value="T04525306"/>Google Drive API integration - request body - invokeurl
Hi, I am accessing Google Drive API (documentation at https://developers.google.com/drive/api/v3/reference/files) through Zoho CRM. This is working fine, using commands like the following, which pull a Google Drive folder reference from the Contact, and returns a list of files inside that folder: gdriveURL = "https://www.googleapis.com/drive/v3/files"; mapParameters.put("q","'" + Contact.get("gdriveextension__Drive_Folder_ID") + "' in parents and (name contains 'foo' or name contains 'bar') and trashedDeluge Script to update Custom Field in Product Details section of Quote record
Just wondering if anyone can provide insight on the Syntax required to access (update) custom field that have been created inside the Product Details section of a Quote or Purchase Order record? For example, we might have a Date/Time custom field In theFor each element, what is the good syntax?
Hello, I'm trying to use the for each element in Deluge in a custom function in Zoho CRM but I get error message no matter how I write the code. If I write like this: 20 for each x in notesinfo { 21 x.Parent_Id.id = contact_id; 22 x.$se_module = "SubContacts";Next 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
Why 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 multiplelist.contains(object) returns null instead of false when list is assigned to null
Consider the following code: list1 = list(); list1 = null; info list1.contains(1); Info returns: null (see attached screenshot) According to the documentation of List.contains(), the only possible return values of List.contains() are true and false. ButHelper Functions and DRY principle
Hello everyone, I believe Deluge should be able to use 'Helper functions' inside the main function. I know I can create different standalones, but this is not helpful and confusing. I don't want 10000 different standalones, and I dont want to have to
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
Sakis Oikonomou
Kurt
Bulat Gainullin
Ishwarya SG
Bhoomi Joshi