SearchRecords Search Limit?
Hi, I'm trying to clarify how many records the deluge searchrecords function will search through. I expect a return of 10 or 20 but need to search all 8000+ records. Is that possible? ThanksifNull and isNull analyze differently
There is a problem where isNull analyzes "" as true, and ifNull analyzes "" as false. Very frustrating considering that there is no support calling your own custom functions. I would right my own corrected version of this function except you have to goZoho oAuth Connection not working
So my Zoho to Zoho app connections have stopped working. They have become "disconnected", anytime I try and authenticate them they work for a couple of seconds and then "disconnect" again. Support suggested I create a new connection and edit every functionCRM 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});Deluge: changing type of file from .xslx to .xslm
Hello, I am creating an excel merge by sending Zoho CRM data to Formstack Documents (formerly Webmerge) through API. The document created is .xslx, as Webmerge does not allow to generate .xlsm templates. I was wodnering if it would be possible to cnover{"code":2930,"message":"Error Occurred. We are sorry for the inconvenience."}
Hello, Im trying to update my conections with Zoho Creator from V1 to the new. I have a simple update getRecords and updateRecord, but both are giving the same error: {"code":2930,"message":"Error Occurred. We are sorry for the inconvenience."} The code is this way: searchB = zoho.creator.getRecords("roboplan","planeamento-plano-b","Tasks_Report",criteriaB,1,200,"creator"); And creatorB = zoho.creator.updateRecord("roboplan","planeamento-plano-b","Tasks",creatorid,rowDataB,empty,"creator"); I'veDeluge's Encoding and Encryption functions
Hello everyone, In this post, let us discuss the encryption functions available in Deluge. Deluge supports a set of built-in functions to encode, decode, encrypt, and decrypt your data using various encryption standards. Function Description Applicable services zoho.encryption.base64Encode Encodes text data to base 64 format All services zoho.encryption.base64Decode Decodes the text encoded in base 64 format All services zoho.encryption.base64DecodeToFile Decodes the text encoded in base 64 formatExtract first and last name
I am trying to build a custom function in Flow, when a new Zoho Booking is added I want to split the Name field into first last name. I understand the function needs to be a string and this works but I am unsure how to write this in the flow script. result = first_name.getPrefix(" "); info result; I also assume to then create the last name Ill use the same but getSufix Any help greatly appreciated. :-)Deluge upcoming update: Creator V2 integration tasks
Hello everyone, As you are already aware, Zoho Creator V2 APIs were introduced recently. We are now geared up to roll out five new Zoho Creator integration tasks that are based on the V2 APIs in three weeks. Once these tasks are live: The existing Creator V1 integration tasks will continue to work until the Zoho V1 APIs reach their end of life on February 3rd, 2021. Until then, the V1 integration tasks will be marked as deprecated, i.e., these tasks will be struck and grayed out in the Deluge editor.Updating customer shipping address via Zoho Inventory API
My client is looking to add a functionality that will allow Zoho inventory to automatically update the City, State and Country fields on a customer record based on a zip code that they've entered. For example - if they enter 92705 as a zip code (US zipe code) the system will automatically update the following: City: Santa Ana, State: California, Country: United States I was able to write a custom function that looks at the customer record, and calls the google maps API to retrieve the City, StateDeluge: 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,Getting error on call a webhook in Zoho Flow from deluge.
I with to trigger a Zoho Flow via a webhook trigger by invoking a URL from deluge. The Zoho Flow is all set up and running smoothly - but I keep getting an effort with invoking the URL via deluge (which is running as a function with Zoho Sales IQ Bot - Zia Skills. Following is my deluge code (keys randomized, of course) // create an API to create an inquiry process request to Zoho Flow urlCall = "https://flow.zoho.com/123456791012345/flow/webhook/incoming"; urlparams = Map(); urlparams.put("zapikey","243123412.123412341234214332142134213412421435144235");Flow Custom Function: Issues retrieving record from Zoho Creator
I am currently trying to write a custom function in Zoho Flow to get record details from Creator. I am not sure it it is a syntax issues or what. I am using the following code to get the records. string getUnitMembers ( int params ) { response = zoho.creator.getRecords("[MyName]","[AppName]","Members_Details","Unit_Number==params"); info response; return response; } This however gives me this message. [ { "message": "There is no records match for this condition" } ] Any ides here? IAnnual Revenue
I want to show the auto populate a field in the account module with the sum of amounts in all invoices associated with that account in essence this would be my Annual Rev for the account. Is this possible? 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 followingNew built-in functions in Deluge
Hello everyone, In today's post, let us begin with understanding functions, return values, arguments, and built-in functions. Towards the end of the post we will have a look at some of the newly supported built-in functions. What are functions? Functions do exactly what the name suggests. They are used to perform a specific 'function' or a task. Functions are used to combine multiple instructions to form a single piece of code meant to perform an action. And whenever you want to perform that actionupdate milestone status using deluge
one thing that would make projects much cleaner is an option to complete milestones if all task are completed. this would keep the projects clean and focused especially on the mobile app. with that said i have attempted to write a script in deluge to check for all task completed and then update the milestone to completed. i am using the function zoho.projects.updated located here: https://www.zoho.com/deluge/help/projects/get-record-by-id.html i have also referenced the api guide on parameters toCopying field from one module to another with letters like &
I have a custom function that copy fields from Account to Contacts (and opposite) as a workaround since we can simply use a formula to display the field of a parent module. All worked nicely until a customer added a symbol & in a field. The function just fail. How can I fix that?How do I to get the RecordID of the currently active record?
How do I to get the RecordID of the currently active record?Search CRM custom module by date field
Hi folks, I am attempting to create a deluge script that will search a custom CRM module (Publishing) for all records where the Publishing_Date field is set to specific date. My code is as follows: // fetch all publishing module records for the Month and Year searchDateString = concat("Publishing:Publishing_Date:is:",TargetPublishingDate); pubList = zoho.crm.searchRecords("Publishing",searchDateString); info "date "; info searchdatestring; info "Publishing List Returned"; info pubList; When testingSending to Cliq from CRM
Hi, I'm building a workflow in CRM which starts e Deluge script. In that script, I like to send a message to a channel. I see a connection is mandatory. How can I find the requested connection name between the CRM and Cliq ?How to know how many result in total from a getRecords()
Hi, I'm using getRecords() to get a list of accounts. However you need to set a page and a number of record (per page I guess). So the default is 200 results per page. But how do I know if there aren't more results than the limit ? For example, I have 700 Accounts, I already know today there is 300 records marching my request, but as the limit is 200, how do I know there are 100 records left out... How do I know the total of results ? What is the best way to handle this ? ThanksIntegration 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, GoogleJSON getting sub data
Just getting into Flow / Deluge and am making progress but am now stuck and hoping this is a really simple thing. I have a webhook coming in from Quotient. The payload contains sub items I need to for each on, so I can add monthly revenue and One Off. I cannot work out how to use .tojsonList to get this into a list The data I am after is in selected_items and basically all I want to do is run through the items with a couple of if statements that add the revenue together into one varialble if subscriptionGetting Zoho Sign fields for CRM
Using Zoho Sign with a custom module, so can't use the extension. Use a webhook and Flow to send the sign doc with the default value of the fields set. When a document is signed, I want to check the completed fields in the signed document against the CRM fields. Seems relatively straight forward.... apart from my deluge skills just aren't quite good enough. I can get the data using zoho.sign.getDocumentByID. I can see the data I want, but I don't seem to have the skills yet to extract the fieldDeluge 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.Any opened Deluge repository ?
I plan to use a bit Deluge for some functions in our Zoho One, I was wondering is there were some open repository of scripts or snippets ? This would be a way for me to start learning :) As for a start, I'd like to get message in my Cliq, when I get an estimate approval request. This is parallel to the email notification, I just want to test with Cliq. Thanks !Converting time OR date strings into time objects?
I have a list of strings that either contain a timestamp OR contain a date, for example: 2020-02-29T18:50:00+05:30 2020-02-28T02:30:00+05:30 2020-02-28 What it the easiest way to iterate over them and convert each of them either into a time object or a date object, as applicable?How to sort result set from getRecords
Anybody have a code snippet to show me how to sort the result set from a call to getRecords() Here's my working function call: records = zoho.crm.getRecords("Articles_Press",1,100); return records; it would be ideal if getRecords could take a CRM View as parameter, and also specify a sort column, and sort order as parameters.Adding multiple rows in worksheet using insertCSV function
Hi I need to add 2 rows in a sheet using insertCSV function. The CSV string looks like "Row1Col1,Row1Col2\nRow2Col1,Row2Col2" When using this with the insert CSV function, there is only one row inserted with the entries as Row1Col1 Row1Col2\nRow2Col1 Row2Col2 Basically the \n is not recognised as a new line character. Where am I going wrong ?Very Basic Deluge Work Needed
Hello, I am creating some Zoho Flows and need some very basic custom functions entered, and am looking for someone I can pay to help me learn to enter them in a Zoho Assist type session. I have never worked with Deluge and there are a few areas where I am not sure what to enter. I need to enter this custom function so I can convert Zoho Project Events to Google Calendar Events. I need to do similar so I can convert Zoho Desk Events to Google Calendar Events. I need to convert the due date on ZohoZoho Project: Obtain Project Group ID(s)
Hi, I am wrapping up the last of an automated function in Zoho CRM for creating projects from successful potentials. One 'put' that I am not able to complete is with respect to the project group association. I am having trouble completing because I can't locate the group ID values of my existing groups so as to provide the value for that key-pair. Does anyone know of a way to see this information outside of API? I've looked in the Zproject backup, in the browser website address, in the projectsHow to update a CRM user using Deluge scripting?
I am trying to update a CRM user (not a Contact, but an actual user of the CRM system) using the following Deluge snippet: zoho.crm.updateRecord("users", 438564385646, {"alias":"abc"}); However, I am getting the following error: {"code":"MANDATORY_NOT_FOUND","details":{"api_name":"users"},"message":"required field not found","status":"error"} which required field is this complaining about? What is wrong in my code snippet?Zoho Project Task Field
I'm trying to obtain a list of all Tasks that have been completed today within a certain project. I'm first using the getProjectDetails method to return the details of a specific project named "Ganar LLC". Then I use the following getRecords method to return the tasks from that project. All works well. Then I attempt to retrieve the completed time from each task by using the following for each/get method: projectData = zoho.projects.getProjectDetails("mazumaprojects","active"); //info projectData;Users Module List in Deluge
Hello everyone, I am using deluge function for to get users list. I can take all user list but I need to specific field For example : GetUser.get("status"); status field but it is not working. Result null Do you have any idea? Note: you can see result of code from screenshot GetLead = zoho.crm.getRecordById("Leads",LeadID); PersonelID = GetLead.get("Owner").get("id"); GetUser = zoho.crm.getRecordById("users",PersonelID); status = GetUser.get("status"); info status ;Create entry in Custom Module when creating Deal & Populate Lookup fields
I have a custom Module titled "Agreements" which is CustomModule10 Whenever I create a Deal I want an Agreements module entry created and pre populated with information from the Deal. 3 Lookup Fields are in CustomModule10 Contact Deal AccountProblem at the time of copying data from Parent Module to chiled one
Hello I have customized the default function "Mass update of Child Contacts" to copy some fields from Parent Module Leads to child Module Message. We have an structure where one Lead (Email, type) may have many messages, one per (email,Type) combination is contacting us. I am trying to move some details from Lead to the message, so we can generate some automation based on those fields. But I am getting below error: 'TEXT' can not be cast to '[BIGINT]' for the function 'get'at lineNumber 14 The codeCounting the completed tasks for a contact
Hi Community. We use tasks to track our emails, calls and voice messages. We are putting together a prospecting process that is based on a 90 day cycle of 8 outreaches. After the 90 days we take 60 days off and start the 90 day cycle again. Currently i need to look through all the activities for the contact, eliminate the completed tasks older than 90 days and add up the recent activity. Is there is a easier more automated way to do this? I know that i can run a report but I would like toHow to use hash sha256 in zoho creator?
Hello everyone, I need to ask you about hash function in zoho creator. Because I want to import some data from another website, and in that website, it need to has their signature in SHA256. In PHP, its very easy, you just use the HMAC function: "string hash_hmac ( string $algo , string $data , string $key [, bool $raw_output = false ] )" But its so hard in zoho. Its cost me 1 month to find solution for this. If there is no way to has string by SHA256 in zoho creator, could anyone please giveDatetime and timezone not being changed in function
Hi, I have a datetime field that I'm storing in one of my custom modules. In a custom function, I take that datetime (called tourDate) and try to convert it a String in the US/Central timezone (looked like it comes into the function as a UTC datetime since it shows as 5 hours ahead of me after formatting) like below: tourDate = tourDate.toString("yyyy-MM-dd hh:mm:ss a z","America/Chicago"); I'm noticing two problems after doing that. First, a tourDate that I schedule in my module as May 20, 2019Next Page
Zoho DataPrep Resources
New to Zoho DataPrep?
Zoho CRM Resources
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
-
Zoho サービスのWebセミナー
-
その他のサービス コンテンツ
ご検討中の方
有料プランをご利用の方
Announcements
All 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.Zoho Authtokens to be expired and its impact on Deluge
Hello everyone, We hope you are aware that we have stopped new authtoken generation throughout the Zoho suite. Following this, in order to thoroughly move to OAuth authentication, we are now intending to stop the working of existing Zoho authtokens. On
Zoho Sprints Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho Books Resources
Zoho Projects Resources
Zoho Orchestly Resources
Zoho CRM Plus Resources
Zoho Campaigns Resources
Zoho Desk Resources
Zoho WorkDrive 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
Most Discussed Topics
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_pdfAutomatic 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);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.Connecting 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.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.
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
Mirko
Scholfield
Adil Saleem
Bryan Pape - bryan@infraredsaunarepair.com
Joe Sweeney