Get CRM data center from Deluge function
Hello, I'm developing a Zoho CRM extension. This extension will be installed in multiple Zoho CRM data centers (.eu, .com etc...) I would like to know if there's a way to get the data center of the Zoho CRM where the extension has been installed in
Get ContactID when a Contact is updated
I'm using this code from a previous question to update a field in a Contact whenever a Contact receives an email: //access the emails field from the Contact emailInfo = zoho.crm.getRelatedRecords("Emails", "Contacts", --yourcontactID--); //create a list
Zoho Developer Community learning Initiatives
Developer Zoho User Group (ZUG) is a platform to encourage developers from the Zoho ecosystem to connect, learn, and share their expertise to find solutions for common business challenges. There are a couple of ongoing initiatives to help you get onboarded
Show Hide Zoho Creator subform Fields
It seems like ZOHO has recently launched a new feature that allows users to hide/show Subform row fields, which was highly anticipated. Previously, users were using the disable/enable feature for this purpose. Reference Code:- if(row.College_Name.isEmpty()
Add a row in Analytics
I've been trying to add a row in Analytics using the below code. orgId = "-----"; workspaceId = "----"; viewId = "----"; headersMap = Map(); headersMap.put("ZANALYTICS-ORGID",orgId); columnsMap = Map(); columnsMap.put("User ID","Hello"); columnsMap.put("User
Form Workflow Action Order and Dependency
I'm trying to wrap my head around how the Creator workflow actions handle order. Is it expected behavior that the downstream actions do not have access to the upstream actions' input changes? And do downstream actions only start after the completion of
Deluge Workflow: Cannot insert and retrieve a new record
I've got a calendar app that lists events for different high school sports. It needs to import non-standardized excel spreadsheets - the school does not force standardized sheet layout from each coach - and create events for the season. I do some manual
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
API Request Key Value Entry - Zoho FLOW Custom Function
Hello, Could someone help me about below API Request custom function of Zoho Flow script? How can I get params part between [ ] in output as key and value? They have to appear as key-value but I couldn't get success it. Probably need some small change.
How do I collect single-row checkbox value in a report?
Hi Zoho Community, I would like to collect a report checkbox value and would like to execute some Deluge code based on checkbox-checked report rows. Is there any way to collect this checkbox value?
Deluge in Zoho services #5: Zoho Connect
Hello everyone, Greetings from Deluge! Whoosh 🌬️ That's how quickly the first two months of 2023 came to an end, and now we're in full speed ahead! We hope you found the previous post in this series useful and are now back with our latest post. Basically,
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!
How to check if string contains any digit
How do I check if a string contains a any digit/ number? this is the code I cant seem to get working Str = "1Mustard Mustard23"; if (Str.contains("[0-9]")) { info true ; } else { info false ; }
Custom Function Argument Mapping Formatting Help
Howdy, I'm attempting to implement this custom function that checks for duplicates between the Leads and Contacts modules, using the email address. The code: relcont = zoho.crm.searchRecords("Contacts","(Email:equals:" + email + ")"); relcontsize = relcont.size();
Reschedule today's open calls to the next business day
Does someone has a Deluge script to reschedule the non-executed calls of today (at the end of the day) to the next business day ? The calls may be related to leads, potentials, contacts, ... it's just to be sure that those calls are replanned for the
Zoho CRM Deluge - Converting Date/Time field to format "5:30 PM" with original timezone
EDIT: This is resolved. The solution is the following: Appointment_Date_Time="2023-02-23T10:30:00-08:00" Appointment_Date_Time.toTime("yyyy-MM-dd'T'HH:mm:ss").toString("HH:mm a", "PST"); ------------- Hello! I'm trying to turn a Date/Time field (i.e.
Need to Filter Report on Multi Select Field via URL
Hello all, I am trying to filter and embed a HTML Creator report in a Page and filter based on the selections in a multi select picklist. Here is what I am trying to accomplish but I cannot seem to get the syntax right for the "OR" portion of the URL.
Automatically create deal from Contact
Hi all, I would like to write a custom function to automatically create a deal when a new contact is created in our CRM. I have found in the community forum how to do it from a new account creation but I would like to do the same from a new contact creation. Could someone help me with Deluge script? Thanks a lot ! Ganesh
How to return the content of a Lookup field rather than the ID
I wish to use Setvariable using the content from a lookup field but i am only getting the ID. A method? Gosh I wish there was some really basic resource with lots of examples to facilitate learning Deluge . Deluge for Dummies - I like the alliteration.
Editing a sales Order / Invoices with Deluge Script
Hello, In Books, I have Sales Order (draft) that I need to update. Depending of some parameters, I need to update the description of each line items. I wrote a simple deluge script for test purposes first. I can read the sales order and all line items
Blockading Timesheet if status is not equal to "In progress"
Hello, I've been figuring out a way to force my coworkers to change the task status when writing time. Most of my coworkers don't even look at the status and let it sit on "Open" If possible i would like to know or create a way to force a task go to "in
Create a Zoho Connection Not Tied to a User
Hello, While automating things, whether it's on a deluge script in the CRM or via Zoho Flow i always have to provide a connection to create / update fields in the CRM. The problem is that those connections are attached to my User and all records created
zoho.books.getRecordsByID in Zoho Flow is not working.
Hi. I am trying to use getRecordsByID in Zoho Flow but it is not working. Could you please give me any advice? I try the next code in Zoho books and it work's fine, but it is not working on Zoho Flow. response = zoho.books.getRecordsByID("contacts","MyOrgNumber","contact_ID");
Unknown Function Error
Good day, I recently got an error on a functions that have been working and tested thoroughly for about 2 weeks now. The Error is Found 'TEXT' but Expected '[BIGINT]' for the function '755' The error does not make sense as the function worked and nothing
Creating a Task with Custom Fields via Deluge Function
Hi all, I'm trying to create a task in Connect via a custom function I wrote as part of a Flow. The function works perfectly to create the task according to the documentation here: https://www.zoho.com/connect/api/create-task.html I am using invokeurl.
Update Status via Deluge
Hello, Im trying to update some tasks status via API but its not working. heres the too codes i've already trying (besides a lot more): values_map = Map(); values_map.put("status",input.Status); response = zoho.projects.update("roboplan",input.Project_ID,"tasks",input.Task_ID,values_map); info response; The second i've tryed was this: (because i've noticed that "status" haves more maps inside. values_map = Map(); values_map.put("name",input.Status); status_map = {"status":values_map}; response =
ZOHO Inventory - Update Custom URL Field
Hello Team I am trying to update a Custom URL Field Inside the Zoho Inventory But not will happen, below I am sharing my sample code with you can anyone help me with the same? Sample Code customfieldmap3 = Map(); customfieldmap3.put("label","Podcasts
Help to Copy data from CustomModule and Contact to Potentials Module
Hello, Our Challenge: We need help with the deluge script to update the Potentials Module with data from Contact when it is updated. We have a custom module ("Coaches"). It has a many-to-many relationship with Contacts. One coach will serve many contacts.
Get and Update ZOHO Inventory Category by API
#Tips of the Day 15 - Feb - 2023 We can GET the ZOHO Inventory Category by the API inventorydata = invokeurl [ url :"https://inventory.zoho.com/api/v1/categories?organization_id=" + organizationID type :GET connection:"zohoinventory" ]; info inventorydata;
Barcode Generate in ZOHO Creator
Hello All, Problem:- How can Generate a barcode inside the Zoho creator? Solution:- BarCode API:- https://bwipjs-api.metafloor.com/?bcid=code128&text=PIyushGoyal&scale=3&rotate=N&includetext rotate:- N : Normal (not rotated). This is the default. R :
Create or Update Data in Multilookup by Deluge Zoho CRM
Hello Team, if you want to update and create a record's Multi lookup Field by deluge, When you using a Multi lookup then Create a Cross Module Like this. Take Course Multi Lookup in Student then create cross Module. Now a New Module will be create inside
Recording Meetings in Different Time Zone
Hi everybody! I saw quite a lot of times that people are asking Zoho to have this functionality to record a meeting in a different time zone. While they did say they will forward this to the development team, we all know too well what that means. *wink2
Deluge script not working for validating a single line field
Good day, I have created a function to validate a field in the contacts module. However, it doesn’t seem to be working and I can not find the reason. In South Africa, our unique identification number is a ID Number. I am using that as the unique identifier
Designig Page: Is it possible to use ZML and Deluge to create a Panel dynamically?
Hi. I want to create a Page with a panel for each record in a Form. I tried to use 'for each , but get get only 1 panel containing the first record. Is it possible to create a panel dynamically? This is my code: <%{ for each rec in Contact[ID != 0]
Fetching Sub Folder with Deluge
I have written some script in Deluge to fetch a folder dynamically via a custom module, then save a merge file in the folder from the deals module. I have that running perfectly now. The problem is I actually want to save the file two levels deeper in
Add Rows to a SubForm Using Deluge
I got a form called Invoices with customer data and a subform that contains the fields: product, qty, price, subtotal. I also got a lookup field on the form used to lookup a quote number, so when I choose the quote number, the Invoice form is filled with the customer data and the subform is filled with the products data (product,qty,price,subtotal) present on that quote. I had read (post of 3 years ago here) that is not possible to fill data to a subform because only the first row is filled (in fact
Adding Multi-Lookup references in Deluge
How do I assign new multi-Lookup references using Deluge? I have a multi-lookup field in Deals that looks up multiple Accounts (which I've renamed as Entities). I need to be able to assign multiple Entities to a deal in a via Deluge, but I cannot find
Inserting a watermark on an image upload field on zoho creator
Hello, how can I pass as an argument an image field upload to a java function and then insert a watermark and return the file with the watermark to a deluge script and replace the original with the watermarked image file?
Would like to create X number of records based on input
I have 2 forms, "Lots" and "Mass Create Lots". I would like to create X number of lots based on the criteria placed in the following form. This will be a useful tool to avoid the manual creation of Lots in the system. I think the best way to accomplish
Newbie Coder - "Error at Null" trying to save script
Hi, extremely new to coding in deluge (or coding at all). I'm working on a dependent dropdown function that takes 3 dropdowns and narrows down options based on user entry. This is what code I have, and every time I try to save it in a workflow I get "error
Next Page