Get Zoho Analytics Data from the Table by Analytics API
Hello If you are looking for a solution to get the data of Zoho Analytics Data by the API, Please have a look below email = Zoho Analytics Owner Email workspaceName = Zoho Analytics Work Space Name viewName = Table / Report Name Scope will be use:- ZohoAnalytics.data/
Cliq 5.0 | Unfurling a Richer Cliq Platform Experience
Hello everyone, This time we're back again dedicated to transform Cliq into your personalized playground, giving you the power to tinker, tailor, and tweak your apps to perfection and extended Cliq's native functionality. We've added some new features
"Else / If" Statement in Zoho CRM Inventory Template
Hello, I would like to use the below "Else If" in my Inventory Templates, but it's not working correctly. Essentially, if the field "Quote Payment Terms" is filled in, display that. If "Quote Payment Terms" is blank, display "Account Payment Terms" instead.
Can Deluge be used for conditional formatting of records?
Hi all, I need to highlight records in a report that meet certain criteria. Unfortunately this criteria depends on related records from a different form, so regular conditional formatting in the report "configure fields for web" page will not work. There
Mark an email as Important using a sendmail task
Hi, I have recently came across a scenario where a client wants to know whether he/she should process a request on priority or not. For that, client requested to have some field differentiating between standard and urgent requests and the same should
Idea - Zoho CRM Workflow trigger for when the number of a Record's assigned Relate List Records changes.
To explain the Idea, I will describe my issue with an example: We have two modules in Zoho CRM: Module A and Module B. Module B is a "Related List" when viewed from Module A. Essentially, multiple records from Module B can be linked to a single record
Get Old Owner of zoho crm record
Hello Team Sample code:- Getrecord = invokeurl [ url: "https://www.zohoapis.com/crm/v5/Leads/"+Lead_ID+"/__timeline" type: GET connection: "zcrm" ]; if(Getrecord.get("__timeline").size() > 0) { for each rec in Getrecord.get("__timeline") { if(rec.get("field_history")
Get responses for KRA
Good day, I am trying to get the responses to KRA in a self appraisal in Deluge. When I get the data from the self appraisal form, it does not include any data for KRAs that were answered. The simple code I used to get the self appraisal data is as follows:
Cerate Zoho Interview By Deluge Help or Zoho Recruit API
Hello Team Here is the sample code to create a Interview using Zoho Recruit API or Using Deluge. Sample Code:- Department_Name = Department ID Candidate_Name = Candidate Record ID Job_Opening_Name = Job Opening ID Interviewer = Zoho Recruit User ID Getrecorddetails
Detect success or failure of script execution when pressing a transition
Hi team I need to know the following, I have a transition button on blueprint, where in the after section I must assign a function, at the time of its execution, the function must indicate the success or failure of its execution, in the case of success
Send Attachment From Zoho Recruit to Email
Hello Zoho Developer There are other tips and tricks, if you are looking for a deluge script to send the Zoho Recruit Attachment in email, please have a look Deluge Code:- GetAttachment = invokeurl [ url: "https://recruit.zoho.com/recruit/v2/Candidates/"+candidateid+"/Attachments"
Create Zoho CRM Quotes Using Zoho CRM API but Tax and Aggregate Field Not working.
Hello Team, I have wrote a deluge script to create the record in Quotes and update the same quotes, all things are working fine but line Item Tax value is coming more then 2 value after point, like 2.0002, 2.0036 I am also sharing the Deluge code, Please
Deluge 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.
Date time field manipulation in custom Deluge function
Hello, I'm having trouble manipulating the date-time field in a custom function. I want to do a seemingly simple thing like add minutes to a date-time value but it keeps returning unexpected results. Even basic date-time functions like getTime() don't seem to be working as expected. When I do info on the date-time field "2020-09-15T14:00:00+10:00". However, when I use getTime(24) on this it returns "00:00". Why? According to the documentation this is not meant to happen, it should return 24 hour
Debug Info statements replace newlines with spaces
The info statements in Zoho Deluge can be helpful for debugging. However, they convert newlines to spaces before being posted. In my case, I had some old records with a field that was accidentally multi-valued. I wanted to get the last instance of the
Calculate Hours Minutes Sec in Zoho Creator Using Deluge
check_In = "8-Aug-2023 10:00:00".toDateTime().toLong(); checkout = "8-Aug-2023 18:00:00".toDateTime().toLong(); //difference = start.timeBetween(end); check_In = "8-Aug-2023 17:56:50".toDateTime().toLong(); checkout = "8-Aug-2023 18:00:00".toDateTime().toLong();
Zoho Sign Automation
I want a more seemly and automated integration between Zoho CRM and Zoho Sign. I recently signed up for your Zoho One trial and I just added the Zoho Sign marketplace integration to Zoho CRM. It's okay but has challenges. For example, even though I'm
get current record
hello I'm trying to add a list in Zoho crm product (part of the code) Productid = 133994; productList = zoho.crm.searchRecords("Products","(Product_Code:equals:" + Productid + ")"); what I'm trying to to is to get the value of a custom field in the current
Help with Deluge
Hi All I am trying to copy notes from a custom module onto a lead on a button press. I have managed to copy the note title & body but attachments are much different (as they are a related list?). I have wrote the below but I am getting error 400: Bad
How to Exit Contacts on Reply?
It appears that there is no reasonable method to exit a contact from a Campaign/Workflow, thereby preventing a user from receiving automated emails after they've already replied (which would be confusing at that point). Could you please confirm the following
ChatGPT with saving user context
Hello, everyone! I've encountered an obstacle on my way that I can't solve. I want to create a Zobot instance connected to ChatGPT. I want to chat with ChatGPT while saving previous user questions (context). So, I have created a Zobot instance with codeless
is it possible to trigger to selenium or another tool from deluge?
Hello, good afternoon, I would like to use an automation tool, so that when a browser window is opened, with the openurl() instruction, it immediately triggers a call to selenium or another automation tool, so that the browser loads the data that it receives.
Keeping 'deals' in sync with sales orders in Zoho Inventory
Hey all, I have a function that generates a sales order in Zoho Inventory when a deal is created in Zoho CRM. I'd like to implement a function (or solution) that keeps them both 'in sync' after creation, trigged by an edit of the line items in either
Return failed HTTP status from incoming webhook
We want to be able to intentionally fail an Incoming Webhook request if something goes wrong in our code. This is important because then the system making the request can then retry it later. How can I return an HTTP 400 or 500 from our Incoming Webhook
A custom function creating invoice in zoho books, from zoho crm deals is not working anymore
Hello everyone, We had made a custom function creating an invoice in zoho books, from the deals selected in zoho crm deals. It was working perfectly fine, but all of a sudden, it is not working anymore. Does anyone have an idea of the problem ? I re-synchronized
How to prefill fields for the recipient
Here's part of the Deluge code: 'Startdatum' and 'Einddatum' are fields defined as 'Recipient: Prefill by you', while 'Naam' is defined as 'Recipient: Guide'. Above code correctly fills in 'Startdatum' and 'Einddatum' in the form, but fails to pre-fill
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 update
Calculating the average time between deals
Hey all, I am looking for some help with a deluge script that will calculate the average time between deals for an account. We create a new deal for most of our accounts (when they re-order) anywhere between 20 - 90 days. What I want to know is: Average
Avoiding XML while creating custom related lists
Is there a way of defining custom related lists that does not require you to format them in XML as documented here? It appears in Zoho Books you are able to define these in the way you would expect (i.e. by just supplying the row data as a list of maps
Dissociate a payment from invoice
Hi everyone, I am dissociating a payment against the invoice and marking the invoice as void, this is happening manually but I want to achieve this using deluge. I have checked the Book API documentation but there is only I can GET, PUT, and DELETE a
Replicate Zoho Sign UI in Deluge script
I'm trying to write a Deluge function for sending document sign link via SMS With my current deluge script, I can get the sing link delivered by email, no SMS info zoho.currenttime.addHour(17); deal = zoho.crm.getRecordById("Deals",id); account = zoho.crm.getRecordById("Accounts",deal.get("Account_Name").get("id"));
Convert an integer to a formatted currency string for use in an html page
TL;DR - the deluge custom scripts below can convert a plain integer into a currency-formatted string, i.e. convert -12345678 to ($12,345,678) or 12345678 to $12,345,678 --------------------------------------------------------------------------------------------------- hey there fellow zoho community members! i have been developing custom html pages for my apps in zoho creator and came across the challenge of formatting integers into nice and clean currency values. i struggled with this for awhile
Update Custom Fields via API
Hi - does anyone know if there's a way to update custom fields in Zoho Connect tasks? I have tried passing parameters but it returns "errorCode":"EXTRA_PARAM_FOUND","devReason":"Extra param found 'customRecords'" map1 = Map(); map2 = Map(); map3 = Map();
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 transferring
Hide values in a lookup field for non-logged in users.
Hi all. I have a form that contains a lookup field. Let's call the form "Booking form". The lookup field is called "Package". Basically, it lets the customer choose the package they want to book. This field is a lookup to another form called "Packages"
Replicate Zoho Sign UI in Deluge script
I'm trying to write a Deluge function for sending document sign link via SMS With my current deluge script, I can get the sing link delivered by email, no SMS info zoho.currenttime.addHour(17); deal = zoho.crm.getRecordById("Deals",id); account = zoho.crm.getRecordById("Accounts",deal.get("Account_Name").get("id"));
Convert Number into Ordinal
Hello Developers, Here is the solution for converting the Number into Ordinal. For Example: This Idea can be used when lets say you are creating the Dashboard where you are showing upcoming celebrations like work Anniversary for you HRMS Application.
Unable to change tax with custom function
Hi, In the Global Edition, Zoho Books has not the feature of having taxes related to customers, so I was trying to do a custom function to do so. The idea is to create a custom field in the client and when the sales order is created, check that custom
Deluge 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 Details
Storing 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 party
Next Page