Populate the Amount field of a Deal by calculating the number of related products and its unit price
I am trying to use this code:
RelatedPotential = zoho.crm.getRelatedRecords("Products", "Deals", potId.toLong());
//info RelatedPotential;
unitprice = 0.0 ;
for each ele in RelatedPotential
{
unit = ifnull(ele.get("Unit_Price"),"0.0").toDecimal();
unitprice
Invalid collection string
Hi, I created a function in CRM and it worked perfectly fine. I saved it and when checked it again the next day I got this error. What are the possible causes of this error? This error message is not mentioned in the documentation I found. Any kind of
How to add linked records to a subform?
Hello, I do have a custom module "Subscriptions" and I want to add every single invoice that is attached to a subscription to a subform. So every subscription contains several invoices. Each invoice will be added to the subscription after the subscription
How can I use IF null for a date field in a formula?
I have the following calculation in a formula field: 40-((Datecomp(${Matching.Due Date},Now()))/10080) Can someone help me to modify it so that the formula only calculates when ${Matching.Due Date} is NOT empty and ${Matching.Delivery Date} IS empty?
Using a button to run a workflow?
Hey everyone, Googled this and found reference to it but no guides or details on how. Just wondering, if I have a workflow that is set to update fields and send an email, can that be triggered with a button? Right now there's a dropdown that when the
How to output combination of Current Date and Record ID?
Hello, I am looking for a way to combine two values in a single line field with the name "Unique_ID": And the record ID (Invoices module) The Current Date or the Modification Date incl. hours, minutes and seconds So the result should look like: 32154890126890_2023-04-11-20:24:00
How to create a serial number in Invoices module in Zoho CRM?
Hello, is it possible to generate a serial number and output the number in a custom input field with the name "Serial_Number"? I already used the autonumbering field for another serial number, but I need a second one. Thanks for help, M.
Need help with Function
Hi - I am having a difficult time getting a function to work. This is a copy of a function that is already working well in our CRM, but with variable names different. So no idea why the original works and this variation won't. This function executes on
Associate multiple deals with one invoice
Hi, My organization is using the Enterprise edition of Zoho CRM. I would like to convert multiple deals into one invoice. I am currently trying to create a custom action, to create this but we are not able to link multiple deals in one invoice. The code
Deluge: Converting Lead to Contact if Contact already exists
Hi guys, Is there a way to convert a Lead to a Contact when the contact already exists with the same email? I've seen that you can update the contact using the lead.mapto() function which is already working for me. I really just want the lead to drop
Multi-Line Separation / Split
I am trying to figure out how to do a function to take a Multi-Line field and break it into other fields: Example Data: Data1 Data1 Data2 Data2 Data3 Data3 Field One: Data1 Field Two: Data2 Field Three: Data3
Manage color themes for all users
I know I can change the color themes of my admin account and my sales reps can change the theme colors of their own individual accounts, but is there a way for me to centrally manage color themes for all users? I want everyone to have the same color scheme
Date and datetime fields formatting and wrong data type issue when update or create
Hello, I'm trying to update a field in the Potentials module;update a datetime field with a date field value. But, I'm getting the error below. Code below: // get Deal records dealDetails = zoho.crm.getRecordById("Potentials",dealID); // get site survey
I deleted fields permanently and I don't know how to get them back
I was testing mapping fields on zoho crm to zoho form and I deleted a few fields permanently. The dropdown field doesn't appear anymore and others that now I can't map to Zoho forms. Please tell me how I can recover all the fields again. Thanks
Credit deduction for function calls
Good morning, As I understand, there is a limit to the number of function calls you are allowed to make in a Deluge application. So for every function call, there will be a credit deducted. Does this only apply to calling a custom function, like this:
Is it Possible to Add Another module create form within another?
I have been playing around with client scripts trying to see if it was possible. I read through all the docs and it looks like it isn't. Here's what I am looking to do: Whenever we create a contact they are ALWAYS associated with a deal. So instead needing
How to assign values from lookup field depending on picklist value?
Hello, I am looking for a way to do this… In the Invoices module there is a lookup field with the name "Textmodule_Introtext" that links to a custom module with the name "Textmodules". And there is also a picklist called "Subscription_Type" in the Invoices
Attach Merged Document back to the Record
Hi I have a merge template that I have merge tags from the Deal Module. I want to be able to do 3 things automatically based on updating one field in the Deal: 1) Quickly Create the Merge Document from the Trigger Deal Record. 2) Email that merged document to a specific email address pulled from a field in that deal 3) ATTACH the merged document back to the Deal it was created from I can do the first 2 steps using Zoho Flow. BUT I have asked Shyam, and there is no way to attach the Merged document
CRM campaign won't show contacts
I have sent out a survey using the Campaigns module in our CRM, but I now can't access the contacts I've sent it to and their status. The section just says "Loading" and never loads. I could access this info with no problems until a few days ago.
Number of sold products in account
Hi, I am using deals for my sales process in my organization. With creation of one deal, I am selling one product. Naturally, one product, can be sold more than once for the same client. When I go back to the account view, in product section I would like
Is there a way to delete related records from a custom module upon deleting a parent record ?
Hello, Is there a way of deleting records in a custom module in CRM through a custom deluge function, when the initial record is deleted ? Let's say I have a record A in the Potential module. When he's deleted, I want to delete records B and C which
Workflow Function mixing data between records
We have a number of workflow functions and suddenly the data is being mixed between records, the functions have been running successfully for over 2 years until last week. Below is the function and the highlighted error
How to create monthly CRM Sales Commission Report (organized by User + Product + Account)
I'm sure there is a way to do this and hope someone can help me. We have a number of sales associates (users). We'd like to create a 'commission paid' report for each associate (user) on a monthly basis that includes product(s) sold, cost per product, commission rate per product (varies product to product) and commission paid to sales associate for this pay period (monthly basis). Each month, each associate would receive a summary of their commission paid and an outline to understand which accounts/invoices/products
Display the name of an assigned price book in subform in "Invoices" module
Hello, I am trying to figure out how to display the value of an assigned price book in the "Invoices" module. In the product order subform in Invoice I assigned a price book to a product. But the problem is that I don't see which price book is assigned
Summary total Purchase orders
Hi, I am looking to see if there is a way that I can create a custom function that adds add the total value for a deal that has mulitple purchase orders raise on the one record. For a example fulfil the sale, we may need to order stock from 2 different
Add Invoiced Products automatically to Products on Account
I'm struggling to set up a function which will be triggered when an invoice is created, to automatically add the invoiced items (products) to the Account the invoice belongs to. I'm currently trying to adapt the following code: relprod = zoho.crm.getRelatedRecords("Products","Deals",potid);
Calculate related record
Hi, I am trying to look for a way to solve this problem… I do have two custom modules "Subscriptions" and "Subscription_Issues" that are linked to the regular Invoices module in Zoho CRM. When I add a new invoice I can choose: A value in the field "Subscription_Length"
Only one name in email for customer w/ multiple contacts
If you are sending an email to multiple contacts, how can we do it so that all the contacts' first names will appear in the template? Example: Contact 1 = Mickey Mouse Contact 2 = Bugs Bunny Template contains: Hello ${Contacts.First Name} ${Contacts.First
Custom functions - get records by view name - getRecords(viewName)
Has there been a breaking change with this feature? Several of our deluge automations no longer work, as of today. For example: deals = zoho.crm.getRecords("Potentials Awaiting review Unassigned"); info deals.size(); Returns 0, even though there are many deals in the view named "Potentials Awaiting review Unassigned" Changing to: deals = zoho.crm._getRecords("Potentials Awaiting review Unassigned"); info deals.size(); Returns 1. Performing a .get(0) still returns a map of size 1. Performing a further
Failed to execute function - Mismatch of data type expression. Expected List but found String Line Number:12
I've had the above error, for the following function. I have a customer module (Customer Onboarding) where I want to create a record for each row in a subform in the Deals module, this currently works, however I'm working in sandbox to change the subform.
How to run a workflow based on date field in Subform?
Hello, in the "Invoices" module I have added a subform that contains several fields incl. a date field. I am running a workflow and several lines/records in this subform will be created. And I want to run another workflow based on the date field in the
Field update every 2 years
To keep it brief - our clients have a certification that renews every 2 years and I'm trying to set up a function to auto update just the year. What would be the best way to do this? Apologies if this is a huge noob question.
How do I calculate the values from individual fields?
Hello, I am looking for a way to calculate the values from individual fields in the module "Invoices". "Sub_Total" (it's the "offical" field of the Products subform) "Discount_in_Percent" (picklist) Result: "Discount_Value" (input field) The result should
Update ZOHO CRM Subform Custom Field by Deluge
Hello Team, resvp = zoho.crm.getRecordById("Deals",5575250000004540106); Quoted_ItemsList = List(); ProductDetails = resvp.get("Products_Details"); for each rec in ProductDetails { mp = Map(); PodcastName = rec.get("Podcast").getJSON("name"); PodcastID
Not Able to Fetch data more if file size more 5 MB
Hello Team, @Bhoomi Joshi @Anamika Prasanth @Ashwin Vishal R Greetings of the day, I am Facing an issue with Fetch data from the getURL() & also with the InvokeURL 1. file size is more than 5 MB, please provide the solution for
How create a new record with workflow/function in another module in Zoho CRM?
Hello, I do have a custom module "Subscriptions" and I want to create a new invoice in the module "Invoices" in Zoho CRM by running a workflow. The new invoice should be generated on the basis of various fields in the "Subscriptions" module: "Contact_Id"
How zoho calculate touch point score
How to zoho calculate positive and negative touch point score
Find most recent date in related records
Hi, I'm slowly learning how to use custom functions to expand our use of Zoho, but am not experienced in this type of script. I have a Custom Module (eg Items). It has a related Custom Module (eg Visits). Each Visit is a separate record, with a date applied.
Delete record function in CRM deluge scripting
Is there any plan to add the capability to delete a record by ID in CRM Custom function scripting? If not, can you provide suggestions for possible work-arounds? Thanks!
Limiting leads to owner
How do I restrict the number of leads to each lead owner? Once the limit is reached, any new lead is to be assigned to another owner or admin.
Next Page