Unable to correct error in Creator custom function
I am trying to write a custom function that will send a response email as part of a Mail filter. I keep getting the same error when I try to save it, but I'm unable to track down the actual problem. The error is Line NO: 9, Improper Statement Error might
Alert message inside custom function
how I can show an alert inside the custom function or popup notification? when I use alert inside the custom function it shows this error. Any solution on how can display alert messages related to a custom function on the record page?
Delete call records if they don't have a Result
Hello. I use voip telephony to call from Zoho CRM. When i call it's required for me to create a call record. But i don't want to save some calls, so how can i automaticlly delete the calls, that don't have a Call Result field (it's empty)? I think using
Automatic Deleting a Lead
Hello, I understand there is no straightforward way to automate deletion of a lead (that is, moving to Recycle Bin)? I'm using a service which mostly syncs junk leads to me. They name all leads in a standard way so I can set up a workflow rule to mark them as junk but I see it would be more efficient to move them straight to the Recycle Bin. I look them up in the service in question, anyway, so can manually fish the rare good ones out of that Recycle Bin as needed. Just less work for me this way.
Upload large files cloud-to-cloud via URL
I have large file url that I wish to upload on my WorkDrive. Can this be possible without having to download from internet to my PC & then to upload back to Zoho WorkDrive cloud? Is there a webform (or how to setup one) to upload files directly to specified
Zoho Books Automatic Exchange Rate Calculation based on Currency Amounts
Hello, I have a request about Zoho Books bank transfer function. My base currency is GBP on the system and when I exchange currency on my bank I record it to Books. For example, according to my attached record; I have exchanged 47.08 GBP to 1.000 TRY
Inconsistent payload in payment api when writing custom function
Dear support team, I'm having trouble writing and testing the custom function for payment module. I want to retrive the subscription record involved with the payment in the Customer Payment module Custom Function. For some reason, the payload I retrieve
How to convert a string to integer / decimal?
Hi, I've got a select list for a quantity calculation with following values 0.5 1 1.5 2 etc... I'm trying to check the input.caseLaborHrs and assign it as an integer or decimal but get the following error. Variable 'qty1' is already defined of data type 'BIGINT' but trying to update 'DECIMAL' data type My code is below... not sure if I'm coming at this completely wrong! My goal is to use this value to do a calculation to auto-create a sales order from a case based on the input Labor hours. eg: LaborRate
How to execute a CRM custom function OnSave a product? I got this already
What I'm looking for is trying to fill the Unit Price field with the value of the Price 1 field converted to CAD on my ClientScript side I got this product_ID = $Page.record_id; var response = ZDK.Apps.CRM.Functions.execute("Product_OnSave", { "product_ID":
Custom Button to auto populate a custom field in Sales Invoice
Hello, I want help with a deluge for executing a Custom Button in Invoices named 'Status of Invoice', where I would have 4 options to choose from after selecting the Custom Button: a) Del CHallan b) Dispatched c) Delivered d) Undelivered. The logic of
Delete Multi Line Text type field whenever it meet criteria using Custom Function
Given that Multi Line Text Type fields can't be deleted using the Field Update option within the workflows I wanted to create a custom function that will perform such an action whenever workflow conditions are met. The reason I want to do this is to be
Function-2: Round-Robin assignment of records
Welcome back folks! Last week, we saw how to update sales commission in quotes using a custom function. This week, let's see an interesting use case asked by many of you - auto-assignment records by round-robin method. Business scenario: Right now, the solution allows you to auto-assign leads from web form and imported lists. Let us look at a need where you want to auto-assign leads from in-bound calls in a round-robin method, across modules. Prerequisite: You must create a permanent record in the
Custom Button - IfElse Function
We have a working custom function that can create PDFs from our module, in this instance we are using it to generate quotations from a lead module. Button clicked > PDF created and attached to record However, we operate in different countries and have
Converting date to Unix UTC millisecond
Hello, I need to create a function that will convert/return my date from Calendly in the following format: "2022-08-10T14:00:00.000000Z" to a UTC timestamp value in milliseconds. Can someone help? I tried the following: string UnixDate(string myTime,
Custom function to create an invoice from a list of subforms
I want to create an invoice based on the list of subforms created in a custom module. Please tell me the custom function to be assembled. The custom module JSON is below. { "Owner": { "name": "EX NAME", "id": "3872746000000200013" }, "$currency_symbol":
Fetch ticket time entries
Hello, I want to know how it is possible to fetch/search all time entries like with the tickets search API. -> https://desk.zoho.com/DeskAPIDocument#Search#Search_TicketsSearchAPI Inside the time entries we have some custom fields (bool) and need to get
Tip #4.2 Auto-creating package and shipment records for your online sales orders
Hello again, I hope you've checked out the part 1 of this post where we auto-create packages and shipments for your offline orders. This is part 2, and here we will see how we can automatically create packages and manual shipment orders for your online sales orders (or in other words, orders generated from Amazon, Etsy, Ebay or Shopify). Setting up the custom function: Log in to your Zoho account and click on this link to generate an Auth Token which is required to make this work. Open your Zoho
Tip #2.1 Auto-updating shipment charges from multiple shipment records to sales orders in Zoho Inventory
Hello, Hope you are doing good today. Last week we saw how we could convert our online sales orders into invoices automatically. This week, we will see how we can automate the process of adding up shipment charges from across multiple shipment orders and add the total shipment cost to a sales order or an invoice using custom functions. To make it easy on the reader, we have split this post into two parts. Part 1, or in other words this post will tell you how to apply this custom function to sales
Update all custom module related records when a contact is updated
Hi, I'm trying to write a custom function which will run whenever a 'Contact' is updated - it should update all items within a related list (called ProductContacts which is CustomModule1). How do I retrieve the ID value to pass into updateRecord? I've
getRecordsById not working for fetching from Books custom module
The custom function I am working on is pretty simple - I need to fetch a record from a custom module in Books. Here is what i am using: response = zoho.books.getRecordsByID("Countries of Origin",orgID,recordID); info response; OR response = zoho.books.getRecordsByID("cm_shipping_detail",orgID,recordID);
Copying/Converting Data from One Module to Another Module along with Notes
One of my client has more than 15 Module and he wants to move Convert Data from almost Every Module to all other Modules. To avoid all these tedious tasks, I created a generalized Code to Convert from One Module to Another Module. All you need is to change source_module and dest_module names and create a parameter of module_id. Also need to add some fields if there is a change in Field Name and what you dont want to copy information. (upto Line 24) I added as many pieces of information I can to describe
APPLYING CREDITS to invoice
How to apply credits to overdue invoices using custom functio when a credit note is created
USE DIFFERENT EMAIL
How to send emails from different email expect zoho.adminuserid using custom function I have already added 2 emails
Function-21: Update all member accounts simultaneously when the parent account is updated.
Welcome back everyone! Last week, we learnt how to create events automatically on specific days of the week. This week, let's look at a custom function that helps you to update member accounts automatically when the parent account is updated. Business scenario: It isn't strange to have multiple branches in a business. Or having contacts with multiple branches of the same company. Either way, it would be better to have multiple member accounts for easier identification rather than have all contacts
Update a bolean field with a custom function
Hi! I want to update the field "isAccountTicketsViewable" from true to false. I have a workflow rule that trigger when the field "Account" of a contact is modifyed. When the rule trigger I wanto to update that field. I write this funcion and mappde ConctaId
Retrieve multiple items in one request
We are building a CF to retrieve the vendor information of every item in an invoice. Loading the invoice, and the associated item list, is working. Unfortunately, the items retrieved do not include custom fields or preferred vendor data. We have considered
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
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 do I make custom function to execute first then create task in blueprint?
I have this custom function that autocomplete open task. I want to autocomplete any open task anytime I click the next state. the problem is any task I auto created in the next state ended up as complete. I figured the problem must be because after clicking
Pulling address from account within a custom function in Deals
I have this function and I need to pull the billing and shipping address from accounts and put it in the quote that is created when this function is run, you can see the section that I tried to put in there before I realized the addresss isn't in deals,
Set Custom Function to Open "Detail View" of a record
This may be an easy solution, however, I am looking to create a custom function button that will directly access the "Detail View" of the same record I'm viewing in another report. I assume this will be some variation of an Open Url script? i know how to create the function, just not the particular code needed to access the record detail view. Any help would be greatly appreciated.
Incoming webhook parameters
I have an incoming webhook into Flow with info I need to create a Sales Order. It needs to be a custom function because multiple items are possible. When I create a custom function to gather all this data, I need 13 parameters to map all this data.
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
Create Subscription Upoin New Account in ZohoCRM
I'm looking for, a preferably for a Custom Function example or, some other way I can create a new Zoho Subscription when a new Account is created in ZohoCRM? This seems like it should be a simple task but maybe because I'm using the GoCardless plugin
Is it possible to use searchRecords to search a subform on a module?
I am trying to use .searchRecords to access a field in a subform on a module. The name of the custom module I'm searching is "Residual_Purchases" and the subform APi name is "Affected_Accounts". I've tried using both the API name of the subform, and
Custom Function: Tracking the Case Closed time
Scenario: Tracking the Case Closed time We create cases and close them but how do we keep track of the details on when the case was closed? This custom function helps you track the closed time of a case, in a custom date-time field. You can then generate reports based on the closed time. You need to have a custom date time field to update the Closed Time. Please follow these steps: Log in to Zoho CRM with administrative privileges. Click Setup > Automation > Workflow > Create Rule. In the New Rule
how to pass email as param to invoke url
I have custom function for my button contDetails = zoho.crm.getRecordById("Contacts",contactId.toLong()); email = contDetails.get("Ryze_Username"); header_data = Map(); header_data.put("Content-Type","application/pdf"); file_object = invokeurl [ url :"https://radiant-gorge-88984.herokuapp.com/reports/:email"
Error generating journal from custom function
Good day, I am trying to generate a journal from a custom function but it returns the following error: {"code":11,"message":"Solicitar carga útil no debe estar vacía para la solicitud."} Reviewing the documentation of the books apis, I am considering
Function-22: Automatically update field details from Contacts in Deals right at the creation stage
Welcome back, everyone! Last week, we learned how to update all member accounts simultaneously when the parent account is updated. This week, let's look at a custom function that helps you update the relevant details from contact records in deal records at the click of a button. Business scenario: The Deals module in Zoho CRM helps keep track of all your business opportunities. To ensure proper lead qualification process with all specifics, it is recommended to first create a lead, convert it into
Function-7: Add Country codes to contact numbers.
Welcome back everyone! Last week, we learnt how tosum up the total across multiple quotes associated to a deal. This week, let's look at a custom function that allows you to add the country codes to mobile numbers that makes it convenient to make calls directly from CRM. Business scenario: Web forms is one of the easiest ways to generate leads in most organizations. Be it an access form that lets prospects watch an on-demand webinar, or a 'Contact us' form that a prospect fills out to reach you,
Next Page