Oh no! Woke up to a bunch of {"code":1038,"message":"JSON is not well formed"} error messages in Zoho Books API
Looks like something changed on the backend of Zoho Books' date format, had a bunch of clients that ran into this error : {"code":1038,"message":"JSON is not well formed"}. Looking at the logs, I couldn't see any error in the JSON format, everything was
Code Request to Update Task Dates On Changes to Subtask Dates
I would like to create a snippet of Deluge that executes when Start or Due Date is changed on a Task... Basically this... and vice versa for End Date.. if the Subtask dates are changed to extend beyond the Parent Task Dates, automatically update the Parent
Zoho CRM Client Script Open Pop-Up
Hello All Hope you are doing well. In this article, you will see how we can create a Popup and get the value from the Popup Up. Example:- Suppose we have a field (Boolean Type) City Details once someone selects this a popup will open and capture some
What does this error mean?
Can someone please explain what this error means when I try saving my deluge script?
Why am I getting this error?
Can someone explain why I would be getting this error?
What does this error mean?
Can someone explain what this error means when I try to update my deluge script?
Filter with zoho.crm.getRecords or zoho.crm.searchRecords
Good afternoon, I am trying to create a filter using fields within the "Events" module. Is this possible? I am using the following code: zoho.crm.getRecords("Events", 1, 200, ("This is where the query using the field would go")). If this is not possible,
Show/Hide in Subform
Hi, I want to hide/show the fields inside the subform. Hide works perfectly on load but show action doesnt work it says "Invalid task in Subform action". Code: if(Job_Work_Challan.Accessories = "Cartons") { show Job_Work_Challan.Quantity ; show Job_Work_Challan.Dimensions_Cartons ; } wherein Job_Work_Challan = subform Accessories = checkbox Job_Work_Challan.Quantity & Job_Work_Challan.Dimensions_Cartons = Both single line fields which i want to show.
How to send email with invoice PDF attachement in Zoho CRM Deluge?
// I am creating the invoice here response = zoho.crm.createRecord("Invoices",values); // trying to get the PDF version fileUrl = "https://www.zohoapis.eu/crm/v3/invoices/" + response.get("id") + "/pdf"; invoiceFile = invokeUrl(fileUrl,"GET").toFile("Test.html");
Deluge Developer Required
Hi Everyone Our current deluge developer is leaving us and we're looking for another one. If you are an experienced developer, preferably familiar with the Zoho Developer Platform then we'd like to hear from you. If you are interested please post a reply
Auto Refresh Zoho Creator Page - Zoho Creator - Reports / Dashboard
#Tips & Trick Sample Code:- <%{ %> <head> <meta http-equiv="refresh" content="05"> </head> <body> <h1>My Website</h1> <p>Some text...</p> </body> <% }%> Paste the entire code in zoho create HTML Dashboard Option Thanks & Regards Piyush Goyal LinkedIn
Problem with default value by using Bulk Write API
Hi guys, I have a problem with the bulk writing API. I have 2 modules. First module ("dataimport") is storing csv file uploads of users. The secound module ("Erzeugungsdaten") should store the data from those csv files. My goal is that each entry in "Erzeugungsdaten"
Don't get Bulk Write API to work
Hi everyone, I'm facing current problem. I have csv files (+500 row) which I push into a custom module (each row is one entry). I thought its a good idea to use the Bulk Write API (https://www.zoho.com/crm/developer/docs/api/v6/bulk-write/overview.html)
Find next available integer in sorted list
I have a custom function that finds a next available integer and creates a part number. The function currently takes a sorted list and loops through each item to find the missing number in sequence. On some part numbers I run into an issue where statement
Deluge and Javascript/Node.JS code examples (and others?) should be added to the API docs instead of just CURL
Hello. While I realize that it's not rocket science to convert from CURL, it would undoubtedly save a lot of time if the code examples for Zoho's own app API documentation also included examples for both Deluge (which I'm kinda surprised isn't there,)
Opening and reading a file in Deluge for use in a sort of bulk update
I want to be able to update a large number of projects, and the tasks contained in them, by using a file. The use case would be that i would have a record per project and data that would apply to various tasks in columns in the file. The file would be
Deluge script to set project start date to blank and/or a specific date
I want to be able to set the project start date to blank under certain conditions, or to the current date under other conditions. I have a map named "createproject" and I try things like this" createproject.put("start_date",""); or this createproject.put("start_date",null);
There some FHIR library for Zoho CRM?
Hi People I would like to know if there is some library or deluge instructions FHIR ?, i need to programming some functionalities with this. Thanks in advance
Help request for a deluge script that checks for incoming email from a contact.
Hello, I would like to please request a script for my Enterprise edition CRM. It is really a simple script; but it needs a little bit of an introduction. So first let me describe what I am trying to accomplish, and then I will describe what I would like
Create appointment in calendar from email body text
I am looking to automate the creation of an appointment in a shared Zoho calendar if a message meets the specific sender and subject criteria and extract the information in the body of the email to create a calendar event. ---------------------------------------------------------------------------------
What's wrong with my Dynamic Content Function?
Hello, I'm trying to use Dynamic Content (and Deluge) for the first time. I can't get it to work. Essentially I want to display some content from a Zoho Sheet on a web page. Here's my function: And here's my view: But none of the content shows on my page
Can we determine what environment a deluge function is running in (sandbox/production)?
Is there way of consistently detecting whether a function is running in the sandbox or production? I was wondering if there was a flag to indicate the sandbox, rather than comparing an org ID variable. I took a look at response from zoho.crm.invokeConnector("crm.getorg",Map()) but there's nothing obvious, beyond ID differences, or our sandbox zia_portal_id being null.
How to update CRM record from fillable template
Hi community, Context: I have a pdf fillable document with 300+ fields in Zoho Writer. I've recreated these fields in the Deals module of Zoho CRM. Complexity: Some fields are mapped and prefilled from the Deals module, while fields others are captured
Help with Deluge Function / Workflow
I have 2 custom modules. 1. Exhibitor Registration 2. Marketing Tracker I am trying to create a new record in Marketing Tracker, when a new Exhibitor Registration Record is created. I need it to update the look up field Exhib_Reg_Record that looks up
Access specific row of subform
I have a form that has two subforms within it. Basically, I want to access data from a specific row(the row will have a Main field set to "Yes")in the first subform to use as data in the second form. So what I'm having trouble with is accessing the specific
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.
Function Code Not Working
Can someone tell me what is wrong with this code? It says it executed successfully, but nothing happens. I believe I have all the field and form links correct. void undoButton() { for each a in Memory[Undo == "Undo"] { if(a.InOut == "In") { insert into
Publishing Creator Page with form/record edit in iFrame
I am trying to create a published/public page with an HTML snippet iFrame that displays a single record in edit mode. I would like that record to be passed via URL variable (fcyearId). I am having trouble displaying anything in the iFrame. I have published
Looping through all Tasks and creating Comments
Hello, I am looking to create a Scheduled Function to run weekly to create a comment based on the value of a custom field on the Task object. Deluge in Projects is needlessly complex however and I cannot figure out a good way to loop through all Tasks
Custom Function - Searching Keywords in Latest Email Reply from Customer
Hi All, I got provided from ZoHo Support the below sample custom function to use for ZoHo Desk. This function is supposed to search for specific keywords within a customer's most recent email reply to a ZoHo Desk ticket and then send out an email alert
How to search tickets using custom fields
Hello everyone, I'm trying to use deluge on Zoho CRM to find all tickets from our customers. We identify they using a custom field on Zoho Desk called "id_ideris". Here's what I did: id_ideris = 13238; mp = Map(); submp = Map(); submp.put("cf_id_ideris",id_ideris.toString());
How to update custom field for each invoice item by deluge ?
I have below code to try to update custom field named "Com". When I run it, I get this error message "{"code":15,"message":"Please ensure that the invoice_items has less than 100 characters."}" The reason I tried this way is because I didn't find how
Retrieve full file path
Hello, For files stored in WorkDrive, is it possible to get the full file path (filename and extension included) via Deluge or the api? So instead of.. https://workdrive.zoho.com/file/jdfi38******lewif we're trying to get.. https://workdrive.zoho.com/file/jdfi38******lewif/document.pdf
Prefill "field_data" on Zoho Sign not populating
I'm trying to prefill some information from CRM Plus into a template using the zoho sign deluge task but for some reason, the data passed into the "field_data" object doesn't prefill the form. A few notes I've confirmed that the function is successfully
Zoho Creator Upcoming Updates — February 2023
Hello all! A very happy new year to all of you! We're back with the very first monthly update of the year! Your support has made Creator's journey in 2022 both momentous and remarkable, and we'll be striving hard to make sure 2023 is even more incredible.
Update a lead on an existing Deal
Our DEALS module allows an existing account or existing lead to be added. Often times we work a deal with a lead. I would like to be able to update the deal to show that the lead has been converted to an account. Example at the time a lead is converted
Banging my head trying to parse XML
Hi I am trying to parse an XML in ZOHO CRM. I was able to add a field for the XML to be uploaded so it can be parsed later So far I am able to get the file data just fine, and even to get to the important node of the XML (it's embedded with CDATA) But
Augmenting subform capabilities
Greetings, everyone! Finally, the day has come for us to announce some of the most anticipated, requested, and exciting updates to subforms in Zoho Creator. As you're aware, subforms are an integral part of Creator forms, as they help in establishing
Creating URL in deluge/HTML
Having difficulty adding target=“_BLANK” to a URL I’m creating. I have dispLnk = "<a href='" + i.URL + "'>" + i.Title_Name + "</a>" + " - " + i.Description; where i.URL is a companies site, i.Title_Name is the company name and i.Description is their tag
How to create a journal with Deluge?
Im trying to create a journal with a custom button from a custom module. Some of the info on the code looks like this: LineItem1 = Map(); LineItem1.put("account_id",CuentaCredito); LineItem1.put("amount",ImporteDepreciado2); LineItem1.put("debit_or_credit","credit");
Next Page