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 followingChange 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":"TheCreator + Zoho Sign
Hi All, First off, thank you for everyone's help so far. I am trying to accomplish the following in Zoho Creator: Recall Document & Remind Signer. Both of these functions are not available via deluge so I am trying to use the Zoho Sign API. I believeHow to get data from response?
In deluge I used a simple statement to get a Zoho Sign Document response resp = zoho.sign.GetDocumentByID(XXXXXXX); info resp; I get a response in this format { "code": 0, "requests": { "request_status": "completed", "notes": "", "attachments": [ ], "reminder_period":Writer Deluge Variable
I'm building a custom function for zoho writer and am a bit stumped with the initial variable. Once I have my crm record id I'm good, but how do I define a variable for that id that triggers the custom function? Whenever I leave the id variable in myHow to transform file Content-Type from Multipart/form-data to application/pdf ?
Hi, I have a big issue with file content-type during uploading the files into Messagebird server. After successful uploaded into Messagebird server, but the file content-type always in Multipart/form data. But the requirement from Messagebird the Content-TypeHow to sort result set from getRecords
Hi, I want to sort the result by the "Reporting_To". If someone could assist. ----------------------------------------------------------------------------------------------------------------------------- listVar = list(); //Create map to hold searchgetting UnAuthenticated Connection error when executing custom functions from employee account
Greetings i'm testing a custom connection between zoho books and expenses, i created the connection from zoho books side and enabled the "use logged in user credentials" option. the custom function uses invokeUrl to add entries to zoho expense. when iSort a list of key-values elements
Dear community, I have the following question. I have list called list_values: list_values = {{"name":'Carl',"age":6},{"name":'Adam',"age":8},{"name":'Bob',"age":9}}; I want to reorder the list values based on the name key of each key-value element, theNo records found
I want to track all employees who do not have records for a specific month. response = zoho.people.getRecords("Legal_Rest_Monthly_France",0,1,searchList); When the search criteria is null it returns an empty map. I understood that I could use the "isEmpty"Error using zoho.sheet.createRecords: There was a problem while trying to integrate with DRE
In Deluge, when I try to use zoho.sheet.createRecords to add to more than 1000 rows, I get this error: There was a problem while trying to integrate with DRE Only some of the data is added to the sheet. The number of rows added varies each time, but itJSON Parse Issue
I am trying to parse response like so info response.get('data').get('Store'); and get the following error: Failed to execute function Argument type mismatch - Found 'DATE-TIME' but Expected '[BIGINT]' for the function 'get' Line Number:16 however, infoUpload workdrive file to sharepoint
Hello, I'm trying to upload a specific file from workdrive to Microsoft Sharepoint when a workflow is triggered. I've tried using flow to accomplish this but it can only upload .txt files (The file I need is a .docx). Any ideas would be great. ThankNeed Help Converting CURL to Deluge
Hi, I am having an issue with converting a CURL command into Deluge. The CURL Command is formatted as follows (token is a bogus string): curl https://{subdomain}.zendesk.com/api/v2/users.json \ -H "Authorization: Bearer 52d7ef4ee01e2c2c75bff572f957cd4f12d6225eee07ea2f01d01a"Deluge - convert datetime from api response to local time zone
Hello, I use the following testing code: I would like to know why the result is "21-Jun-2016 04:16:14"... Why is the hour = 04? The result I expected would be = 18:16:14 (UTC +2) ------------------------------ Where do I actually get this string: "2016-06-21T13:16:14.000Z"Apparent time-out of Deluge code
See video explanation here: https://workdrive.zohoexternal.com/external/e9a38e2c5bacfdfd9f23fcdb899b1e2cbebfa1431f43b95653afae31a415b0d1How to process a PDF to the Writer API?
Hello :) Does anyone have experience in processing an invoked PDF to the Zoho Writer API? In Deluge I requested a PDF estimate from Zoho Books downloadedEstimate = invokeurl [ url :"https://books.zoho.eu/api/v3/estimates/pdf?organization_id={ORG-ID}&estimate_ids={ESTIMATE-ID}"My Love / Hate relationship with Deluge
Ok... so I should first say that I very much have an appreciation for all of the awesome things that I can do with Deluge. It really can be quite powerful in a variety of ways, and allows for all kinds of customization that otherwise would not be possible. Admittedly however, I've had days (and sometimes late nights that turn into early mornings) that I end up feeling like my head is going to explode when coding in Deluge. Now let me emphasize something here... Deluge is a terrific language...Auto-sync email attachments to tickets - Problem with ANSI encoding
Hello, I discovered the following Zoho tutorial: https://help.zoho.com/portal/en/community/topic/automation-3-auto-sync-email-attachments-to-tickets I have created a function based on the post, which also works BUT there is a problem with the text encodingHow do I create a subfolder in a team folder using deluge?
Hello--working on an app in creator creating a database of different records associated with different organizations. I would like to create a folder for each organization within a team folder I've created specifically for this app, then make anotherAssigning Teams to Projects from CRM Function Challenge
We have a function in our CRM that creates a Zoho Project (from a Project Template) when a particular field is updated. I'd like to try and assign teams to the project at that time but I can't seem to make it work. Is this possible and if so can someoneGet Related CONTACTS Id of a list of Accounts
Hi There, I am trying to get just the id's of a related contacts from a list of accounts, I can get it to output the full Json info , but i need just the Id's. I keep getting the following error: Failed to execute function Argument type mismatch - FoundCustom function for Inventory
Hello, Anyone know how i can create a custom function inside Z Inventory in order to delete both the package and shipment (Mark as undelivered) ? A lot of the time we get customers ordering and picking up products straight away, before they even leaveRetrieving Invoices via zoho.crm.getRecordById failing in a deluge function?
Hi, While updating a deluge function in CRM (that creates a corresponding invoice in Books), to use OAuth, it looks like I'm getting { "status": "failure" } at the very start of the function (even the old, working code no longer appears to work). TheEasiest code to convert date format from Books to CRM
There's got to be a better way....? Books - 06 Sep 2022 CRM - 2022-08-27 day = estimated_ship_date.left(2); year = estimated_ship_date.right(4); month = estimated_ship_date.subText(3,6).lower(); info month; // 06 Sep 2022 // 2022-08-27 if(month == "sep")getRelatedRecords not working while getRecords is working
So i have the following code that gets all the records ( at least the first 200 ) of my custom module: notificationLines = zoho.crm.getRecords("Notification_Lines", 1, 200 ); for each notificationLine in notificationLines{ //info notificationLine;How can I update the value inside a custom function from another custom function?
Hello there, I have two custom functions right now, one of them has a variable called 'token' inside of it, and then I have another function (custom function) that I want to use to update the 'token' variable I have in custom function 1, is this possiblePossibility to convert non-ascii characters to ascii in Deluge
Hi! I am making a function that automatically creates emails for participants in a project. I am currently trying to convert all non-ascii characters that might be in a users full name to ascii characters. I can't seem to find a built-in function to doHow can I get the payable days from attendance form using deluge what is the label name of form and field?
response = zoho.people.getRecords(form name); what is the query?Next Page
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 multipleHelper 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 tolist.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. But
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
ご検討中の方
Zoho Sprints Resources
Zoho Books Resources
Zoho Projects Resources
Zoho Orchestly Resources
Zoho CRM Plus Resources
Zoho Campaigns 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.
Zoho Creator 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
Bulat Gainullin
Kurt
Ishwarya SG
Andres