How to call existing function within a custom function
Hello, I'm using the script below to create a custom function but it gives the error "not able to find PV function." How do I call the PV function? float PVD(float rate,float n,float d,float pmt,float fv,int type) { PVD = PV(rate,n+d,pmt,fv,type)-PV(rate,d,pmt,fv,type);
Automating exporting and importing data into Zoho CRM
Hello everyone, I hope you are all having a nice week. i am new to zoho and i hope this question is placed in the correct section. If not then i am sorry. I have several questions and if i can take a bit of your time i would be very thankful :) 1st here
Deluge for Zoho Recruit Application Module
I have been playing with the new Application functionally for Zoho Recruit. The Application module is really interesting. It is a pity that you can not have any fields that can be updated after the Application has been created. I can see that you can
Custom Functions for Tasks
In Zoho Projects, you can now automate the workflow of your tasks by creating a custom function. You can drag-and-drop Conditions into your function using Deluge. These functions can be called from one or more task workflow rules and blueprint. For Instance,
Repeated notifications for Ticket/tasks depending on their status
Hi, everyone, For our day-to-day operations, we need the ability to be repeatedly notified about tickets and/or tasks depending on their status. This would affect one of the following cases: 1. A ticket has been open for a long time. 2. A ticket has been
Why zoho's deluge platform does not include any asymmetric encryption functions?
Asymmetric Encryption uses two distinct, yet related keys. One key, the Public Key, is used for encryption and the other, the Private Key, is for decryption.The Private Key is intended to be private so that only the authenticated recipient can decrypt the message.As of now zoho only allows developers to encrypt the data with only one key with AES encrypt function which is symmetric Encryption which intern uses only one key but when dealing with banking and other service's the providers expect their
how to create popup in Zoho CRM sales order module by deluge?
how can I create popup by another module in Zoho CRM using deluge like this: openUrl("#Form:Popup?
Request body malformed using Webhook
Hi all, After changing the authentication type from General to Connection in my webhook, I noticed some strange behavior in the request to my API call. It seems what before was made by Zoho CRM, now uses an intermediary called Deluge, which produces
Accessing Custom Field values within Deluge, using Map and List functionality
Hello, I am looking to create a custom function which will pull the placeholder and value data for each custom field for each line item on a Sales Order in order to make calculations with this newly created Map. I have not found a way to directly reference
Flow Custom Funciton Not Returning String
I have a simple custom function to return a string value in Flow. This works when I test the function in flow. When I run it in flow, it errors out (See below) Flow Output Value is empty and 'get' function cannot be applied at line number 4. Resolve
Recurring Invoice message:- java.lang.Object@9ede8b
Trying to access and update a recurring invoice custom field using the following but not recieve any kind of response other than the subject title message. the code /* This is a sample function. Uncomment to execute or make changes to this function. recurringInvoiceID
Is there ANY way to output a function response as an ARRAY of MAPS?
I need to hae something like the following produced and created as a MAP. As of now, i have tried for 3 consecutive weeks to resolve this issue. No matter what I attempt, Zoho will see the data as a String, or if it gets converted to a map it only sends
Custom field update from Deluge custom function giving permission error
Hello, We are trying to create a custom function which will sum the total quantity of all line items on a Sales Order and output this to a custom field on the Sales Order. We have a custom field called "Sum of Line Items" which is a Number type and is
How to setup a schedule function to create Invoices in Zoho Books?
Zoho CRM offers a wide range of functionalities that can be performed in a set interval. One of these is scheduled functions. Schedule functions are a very powerful tool that helps users set up specific tasks that are repetitive and need automation. Today
Branding
Hi All, How do i remove links and branding of zoho from the template i print?
Print
Hi All, I have written a code to print a page and content is feeded from a particular form but when i print something is overflowing and going to second page and i dont know what please help me here. I have attached the issue png as well. Style Code
Trying to setup custom auto-responder using Zoho Mail Filter Custom Function - But auto-responses go to recipient's spam
Hi, we have a custom domain setup in Zoho mail (eg. ourdomain.com). We want to use the inbound filter rules to find specific incoming emails, and send an auto-response. So we are using the "Custom Function" feature to try to do this. in the custom function
Deals Validation Rule (Deluge) - How to get record Stage value?
I'm working on a deluge Function for the Deals Module validation rule. Is it possible to get current Stage value of the Deals record? I can get the newly changed Stage value, but I need the original value before the user change. This code snippet gets
How to access Deals fields when a Deluge script is linked to a button?
Hi, Please note I am new to Zoho and not a developer. I created a button in the view page of my Deals module that is linked to a Deluge function that sends a message to a vendor via Zoho Clic. What I want to do in that function is get the name of the
can we apply approval process between two application in zoho creator
Hello Everyone, I hope all doing well. I wanna ask some things, if we have two applications in Zoho creator can we apply for Approval and Reject Process. between two different applications in Zoho creator. condition:- app owner name is same, the domain
task created from blueprint not triggering/showing-up in function
When a task is created it triggers a workflow function. (the function sets the owner) I try to get the last task created by zoho.crm.getRecords("Tasks",0,1,{"sort_by":"Modified_Time","sort_order":"desc" This works for other tasks created in Deal, but
Logging and debugging
Hi, Is there a simple debugging tool that works like nLog? log.warn(), log,debug(), log.error(). That kind of thing, it can capture variables and logs date/time/linenumber automatically. Destination can be configured. Logging level and scope should also
how to apply multiple subform total addition value in a single field?
Hello Everyone Please help me I am stuck in the Zoho creator I have made 3 different subforms and their Total Amount is available, I got all the total amounts of each form separate, but I want to perform one more action these individual values will be
CRM - Deluge - For each record
Hey am not sure how I would write this script below: This is for Schedule Function. API names Module: Leads Field: Sched For each record that Sched == “AA” && zoho.currentdate == 10/10/2021 THEN Update Sched == “ ”(empty) For each record that Sched
Quote Module, custom button for email, email not generating or being sent from Zoho.
Problem Custom Button: Deluge outbound email fails to generate or send from Quotes Module Environment: Zoho One, CRM, Writer, Work Drive, Outbound Email. Confirmed Good: Email Settings, Deluge Code. Testing Results: Button testing redirects output to
Mail merge with related list using deluge
Hello, i have a problem when i try to merge sub field ( related list ) with mail merge. It only merges main field ( main module ). I don't how to merge sub field using zoho deluge. I am using a custom function to integrate to a button in Zoho CRM Can anybody help me with this problem ? thanks so much
Select/Deselect in succession does not work!
Hey guys, I managed to find a bug. It has to be a bug. I did loads of testing and can see no other reason this does not work. With my app I am trying to select a corresponding checkbox in another field when a user chooses its equal in another field which
How to Pass Form Collection to a function?
I have been trying and trying and cant figure this one out! Trying to pass the entire collection to my custom function that I have tested and works. I am trying to invoke a function I wrote that takes all the form info and send to Zoho Sign. I have it
How to Add Latest Order Last Modified Date to Accounts
Hi Is there a way to always display the last date an Account has purchased on the Account page? I know I can add my Orders module as a list view but I would like to have it on the Accounts screen as I want to do a formula from that field. Thank you
How do I create a Credit Note from Zoho CRM
Greetings to you all! Hope somebody can help me with this one.... Here's the issue: When I create a Deal on Zoho CRM, I create a function to create an Invoice in Zoho Books. I need to create a Credit Note the same way when I create the Invoice, in case
Setting entry level discount in Sales Order with API
Hello, We want to create a Sales Order with discounts in some items. The main problem is we dont know how the API is working in this scenario. Reading the documentation we have to send the quantity discount in the JSON in discount_amount in the line item
Record Successfully added
I am trying to add bulk records in zoho people using deluge The response i get is "Successfully added" however the records don't actually get populated in the view.
Reserved keywords
Reserved keywords If you name your form field to any of following reserved keywords you will risk runtime failure when communicating with your application: script – (this seems to have been resolved, please refer to the list in further reading) type count Background This post is here to address issues that randomly occur while using reserved keywords when communicating with Zoho Creator through the REST API and/or integrated Zoho services using Deluge. Since Zoho Creator does not use namespaces
Create Deal ID only once the record reaches a pre-defined stage
Hi, Was hoping someone can assist. We would like to create a workflow rule/function so that our deals (we have renamed them opportunities) generate a unique ID only after they reach a certain stage in the sales cycle. For instance; 1. create a deal called "Council asset repair" and set sales stage as "Notional interest" = No ID number created or shown 2. edit the sales stage of the deal to "submitted a quote or tender" = create and show a sequential ID number I have had the friendly Zoho chat people
Building a page that runs a script on multiple records
Hi there, I'm building a system on Creator for a loan company. I'm trying to build a page where they can go and search a name and then received a list of loans as well as the total payoff between them. Ideally a search form at the top, a record list/report
Barcode Scanning - Auto Submit
Hello, When i scan barcode using a scanner the form automatically submits. How do i stop form from getting automatically submit?
Solved: Add a button in the CRM to activate a ZohoFlow activity
Here is a useful little code example that can help create complex workflows triggered by buttons. The scenario I wanted to perform a many activities for an advisor when they are starting to work on a client inquiry. Once an inquiry is has been picked up, the advisor needs to set up a time for a call with our client to discuss, which means sending an email meeting invite (with a link to Zoho Booking) setting up dates, making notes on work activities and creating a follow-up task should the client
Add (related) record(s) to Campaign programmatically
Hi, how can I add Contacts (or Activities) to a campaign (in Zoho CRM) programmatically (using Deluge script)? I can retrive the related records once they are already there (getRelatedRecords), but how can I add them? Thanks
How can I fill in an address field with a lookup field's address field in Deluge?
I am trying to allow my user to create a job and select a customer from a lookup field. When the user selects the customer, they have the option to select a decision box "Job Address Same as Customer Address." If this value is true, the customer's address,
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 trashed
Next Page