Deluge Script to update Custom Field in Product Details section of Quote record
Just wondering if anyone can provide insight on the Syntax required to access (update) custom field that have been created inside the Product Details section of a Quote or Purchase Order record? For example, we might have a Date/Time custom field In the
For each element, what is the good syntax?
Hello, I'm trying to use the for each element in Deluge in a custom function in Zoho CRM but I get error message no matter how I write the code. If I write like this: 20 for each x in notesinfo { 21 x.Parent_Id.id = contact_id; 22 x.$se_module = "SubContacts";
Workflow for changing US state names to state postal abbreviations
Currently we have a workflow that automatically corrects the country fields any time anyone enters "US," "us", "USA", "usa" or "United States of America" to the standard "United States." This works great. However, in order to accomplish this I had to
Extract email address from JSON payload string possible?
Hi Support, Current Functionality I have a flow that receives information via a JSON webhook POST and then updates/creates records using this information in Zoho CRM. What I Want An example of the JSON payload data which is received looks like the below
Value is empty and 'get' function cannot be applied Line Number:11
Hi Everyone, I wrote a custom code to check if leads are referred and to check if the client who referred the lead exist, i had used single line field to check who is the client who has referred. everything was working fine with the code after i used
Formating just Created task to update module
Hi All, I am attempting to store the follow-up task ID created below in the Enquiries Module. When I do info on the Follow_up_task_id it gives me the right Task ID number that was created. But for some reason it is not storing it in the following update
Provide better formatting of Deluge code in all forum posts and replies
Please consider improving the formatting of Deluge code within your forum's rich-text editor and in replies to posts. Your code blocks leave a lot to be desired: // Here's some Deluge code from Learn Deluge: person = { "name" : "John", "age": 22 };
Troubleshooting in Creator #3: Deluge execution limit optimization
Dear developers, A Deluge statement execution corresponds to each line of code executed within a certain script. The total number of lines executed to complete a certain task on an action like on success is associated with a Deluge execution limit in
Deluge function zoho.crm.updateRecord not updating
Hi, I have a very basic function that when a new record is created it takes the value of a few fields glues them together and then adds the result into a new field. The function was working fine till a few days ago when it magically stopped working !
Solution: Deluge script to determine the default Layout for a given User to be used when creating a new record
My use case: Create a new Invoice, using fields in the Potentials module in Zoho CRM - I want the layout to be set to the default layout of the user who is creating the invoice. Problem - when creating a new record using a Deluge function, the layout
zip.extract() throws error 'Error at null' for uploaded file.
here is my code - zip = input.image_file; file_collection = zip.extract(); error: Error at null
Duplicate value on duplicate field
Hi, I have created a field (Single Line or Long Int : the same problem) In a custom module with the option "Do not allow duplicate values". With a Deluge fonction executed by a workflow, I insert several entries in this module. But I see that there is several times the same value in the "unique" field !!!! Help !!! Thanks, Pierrot
Function Needed - Calculate Currency Fields Every Day in Deals Module
Hey there! I have a common issue with our clients that we onboard into the CRM that I'm hoping to solve with a custom function. Most of our clients work of a 50% deposit upon contract signing and the final 50% after the delivery of services. The goal
Getting related records from a custom module in a function
Background: I'm trying to put an automatically-calculated field on Account records that totals up all the sales to that account. Sales are kept in a custom module called "Sales Records," because we just get a spreadsheet of orders from our distributor
Deluge trying to Invite an Attendee via invokeURL
Hello, I get the error "Execution Failed" while trying the following code: params = {"sessionMembers":{"emailId":"#####","sessionId":"######","role":3,"source":1}}; file_variable = invokeurl [ url :"https://showtime.zoho.eu/api/v4/#######/sessionMembers.json"
Subform file insert
Is there a way to get a subform file field insert to work ? The same script works ok for other fields but not if the field is a file field Deluge show the file field as string, and it works to copy across forms but inserting in a subform fails with this
Parent and child Maps don't stick
Posting to see whether anybody has come up with a solution to this, which appears to be a fundamental flaw in Zoho Deluge. Try this code: //testing nested maps with updated values. ParentMap = Map(); ChildMap = Map(); ChildMap.put("Item1","Value 1");
How to add a record to a related list from Deluge?
Hello, I have a custom module called Applications. In my Contacts module, I have added Applications as a related list. How can I add entries to the Applications related list of a Contact, using Deluge? Thank you.
zip.extract() throws error 'Error at null' for uploaded file.
here is my code - zip = input.image_file; file_collection = zip.extract(); error: Error at null
Create invoice from 2 salesorders with custom function
Hello, We want to make a custom function that, when a customer has 2 or more sales orders, create only one invoice instead of 2 (we have a workflow to create invoices automatically from sales orders that have been sent). I have been investigating the
open *existing* record for editing via Deluge or embedded in page
I have a page with embedded reports showing different views of a single record. The built-in Edit function opens in tiny panes where only a few fields are visible at once. To improve usability by making more of the field visible, I want to open the form
Simple Widget to Count # of Records in Zoho CRM
Hi, I have a Custom Module and have created a custom view for a subset of the records. I would like to display a simple counter on my Zoho Site site that displays the number of records in that custom view, to be refreshed/updated once per day. What
For each : Skip if field is missing
I've created a set up that will allow my users to import a spreadsheet and via a Function it will run through each row in the imported daa and update matching records in a chosen form/report. It's strange that Zoho Creator doesn't have this function as
How to search for related records in Zoho Books?
Hello, Deluge reference documentation here: https://www.zoho.com/deluge/help/books/fetch-records.html Note: This is in a Zoho Creator function I'm having some difficulty writing a function in Deluge which will search for related records in Zoho Books.
auto adding brackets to my if statement
I'm using free-flow scripting and have a reasonably complex if statement being used to filter a whole bunch of criteria in a search form. It was all going along ok, until I added the tenth criteria. As soon as I did that, Deluge decided that I had the brackets all wrong and has added in 5 more sets of brackets and completely broken the logic. So to the Deluge developers, please leave my brackets alone - I know what I am doing here. My If Statement if (((Item_Type_Rec = input_ItemType) || (input_ItemType
How to set value of dropdown based on another field?
Hello, I'd like to set the value of a dropdown when I can determine certain formats in a string field. Specifically, I am entering shipment tracking numbers and I want to set the associated carrier based on the string's format. The best example is probably UPS because their tracking numbers usually begin with "1Z". This is my first Deluge script so I'm probably way off. It has no syntax errors but it doesn't do anything. The workflow I setup is "on update" and states that it will be executed as the
Increment update record in report
Hi everybody i need your help I’m creating an app on zoho creator i would to insert a bouton in a report who will increment updaterecord in my report with the button +1
Tip 30: How to perform Google search from Zoho Creator
Hi everyone, Hope you all had a chance to try out our last tip. This month we have another interesting one for you—how to perform a quick Google search from Zoho Creator. This tip can be useful for redirecting your users to Google to find relevant information
Adding White Space in Deluge Code.
Hi there, I've been coding in Deluge for around 7 months now. Something I usually do within my code files is adding some white space to section out parts of code. I've noticed in Creator, and other Zoho Apps, that when I save my code in functions, the
two subforms of the same form - possible?
I have Purchase form which has a Purchase-Item subform. after the purchase Is made, the manufacturing process begins and i subtract from stock the needed items to make the desired purchase item. to keep track of the stock movement, i create on validation a purchase item of the needed component where i record a timestamp and the stock level at that point. this way, the report showing Purchase-Items can show me stock movement of different items over time. i would like to connect the needed component
Automations from email statuses
Recruit shows the status of a sent email but I can't find a way to trigger any workflows as a result of them as they cannot be targeted from within the module workflow. We have lots of automations on our referencing custom module and most are auto-approved
Workflow rule does not trigger/run when the 'field update' field is updated by a finction.
Hi there, I have found that workflow rules do not trigger when the field that is set as "Field update" is up dated by a function. I have a DEAL workflow rule set like this, When do you want to execute this? : *On record action, *field update. I have created a schedule action. I have specified a field (on the deal), which is updated by a function. The function that updates the field is run in a blueprint in the TASK module. The workflow rule works as expected when the field is updated either manually
Weird bug with API
Good afternoon, I may have found a very strange bug. On a blank sheet named "test", I create 3 columns with headers in the first row : "type", "color" and "check". I input values for 2 rows : "car", "blue" for the first row, "car", "yellow" for the second
Missing documentation for "related lists"
This question is related to both Zoho Books and Zoho Inventory. Under settings you can add something called "related lists" to a resource, like items. When I do this I get some sample code of how this is supposed to be implemented: /* This is a sample
Deluge seach last deal updated
Hi , How Can I seach last deals updated by deluge code ? other question : Can I seach in date fields with deluge code ? like this : files = zoho.crm.searchRecords("Deals", "(dateCreated < Now())"); Thanks for your help
Price Books - Simple, but powerful Improvements
Hi everyone, so, I guess we all agree that Price Books (PB) are a very essential element of every good CRM. Here are some of my ideas of how Price Books functionality could be immensely upgraded: Bulk Apply Price Books Probably the easiest and most straightforward of all. One button - One Price Book. No matter if it's a Quote/Sales or Purchase Order, most of the time it's one price book for the whole thing. Having to pick a PB for each single product is insane, especially when dealing with 20+ products.
Adding a department assignment to a project or job using deluge / Flow
I'm working on getting Zoho People to add the same three departments to each project and job. I'm attempting to use Zoho Flow to accomplish this but there doesn't seem to be a way to add a department via Zoho Flow. Which leads me to create a custom function
Creator Multi Select
How do I add and remove data from a multiselect field with deluge ? I want users to tick a box to "pin" a row so I have constructed a lookup multiselect box that addes users who have pinned.... if they untick the box I want to remove the current user
Populating Form's Subform from unrelated Report
Hi Guys, I’m trying to make a button in a report that, when multiple records are selected, it will run through the records, collect some of the fields from the records, then open up another form in a popup window and populate it’s subform with said fields.
On Validate or Validation Custom Function
Is there an on validate or validation code I can use with Zoho Recruit's custom function? I tried the on validate{} but I received Syntax error. Expecting statement. Found 'validate'. I want to do some date validations in Recruit that's why I thought
Next Page