How to use deluge scripts to insert rows to subform
I have 2 forms, Box form with Seed_Packs entries that links to another Form Seed_Inventory entries. After I have use the import functions, the entries did not link from Seed_Inventory to Box.Seed_Packs, I want to use scripts to do the linking by creating
How to clear all Tags from Account via Deluge
Hello, I created a function to read the status of an Account's Related List items, and then add a Tag to the Account's pre-existing Tags based on those statuses. When those items' statuses go to status terminated, I need the Account's tag to go away,
Open another form as a Pop-Up
Hello, How do i open another form as a Pop-up Dialogue on click of Button which is a custom button in report? Can anyone help me with a code? Thanks
Create CounterParty Zoho Contract Sample Code
Hello Sample Code Create a CounterParty userlist = List(); usermap = Map(); usermap.put("displayName", "Piyush Goyal"); usermap.put("emailId", "piyushgoyal@yopmail.com"); usermap.put("jobTitle","test"); usermap.put("phoneNumber","8955484428"); userlist.add(usermap);
Getting Error when Making API Call in Zoho Creator to FreightCom API
I want to make an API connection between my Zoho Creator app and the FreightCom API. Here is the code for my function: ``` string FreightComTest() { endpointUrl = "https://customer-external-api.ssd-test.freightcom.com"; apiKey = "This is my API KEY. I
Pulling a record in a custom contact field to a custom ticket field
Hello Everyone, I am trying to know on how do I pull information(in a custom field) from a contact so it automatically updates when I fill in a ticket using the contact name? Example: When I lookup an account: It auto populates the other fields such as
Zoho billing API by deluge
I am creating new function to update subscription activate date. And I got this error message for now. "For security reasons you have been blocked for some time as you have exceeded the maximum number of requests per minute." How long does this message
com.zoho.dre.exception.DREException
Hi, I am getting the following error: Exception : com.zoho.dre.exception.DREException: An error occurred. Check the service and connection details of wixbooks connection and try again. where "wixbooks" is my connection name. I am using a server-application
Trigger a custom function in CRM from Desk
Hi, I have a function written in CRM that requires one parameter, dealId. I would like to trigger this function from a custom function in Desk. I feel like this is possible via an InokeUrl but I am not sure how to accomplish it. Can someone point me down
Kaizen #119 - Updating related records upon parent record deletion using Workflow-Triggered Deluge Functions
Hey ! Happy New Year everyone, and welcome to the first Kaizen of 2024! In this week's Kaizen, we will address this query raised in our developer community on how a workflow triggers a Deluge function to update the status of a field in related records
Invoice Related List - Credit Notes
Hi ZOHO Community! As far as we can see there isn't a way of referencing a Credit Note against an Invoice that is native to Books. You can see it in the Comments & History section and also in the SO byway of the canceled items but not in the body of the
Taking Comment Timestamp and adding to a custom date field
We are using Zoho Projects, including the comments field extensively, and I have had a request from one of our PMs as follows: They would like to be able to sort projects in their project list view, by 'latest comment'. i.e. they would like to see the
COQL selecting a column with space, how i can do it?
Hi Zoho Team I got a problem, when i was programming a Zoho deluge but my query need to use a column name with space, please see the code: queryMap = Map(); queryMap.put("select_query", "select Last_Name, First_Name, Full_Name from Leads where id ="+id+"
Como esconder el boton "Delete" y porque no puedo borrar un registro
Buenos dias! Espero que esten bien! Tengo 2 consultas que no estoy pudiendo resolver y no encontre informacion al respecto 1) Hay alguna forma de esconder u ocultar el boton "Delete" de un modulo? Cuando voy a los 3 puntitos sigue estando y pormas de
Not Getting Subform Data from API 2.1
I have a CRM function that needs to pull subform data from a creator form. I am using the API v2.1 and tried updating the field_config to "all", and "detail_view" (which has the subform in the report I'm pulling from). None of the API responses are returning
Using Deluge to Set Tooltip
Is it possible to use Deluge to set a tooltip? I want to dynamically set tooltips for multiple Multi-line fields.
Populate Account billing address with existing Contact mailing address
I am a new Zoho One trial user trying to learn the ropes and fully anticipating to become a subscriber at the end of my trial. I would like to be able to take a contact record and generate an account record that looks up and populates the associated contact
Crm- subforms and deluge
Due to the current limitations on automation with subforms i find we need to update the main form with data from the subform. In the main equipment form is a field called equipmentstatus. In the subform is a field called status. I would like to to update
How to get values from a Subform when use ZDK.Apps.CRM.Sales_Orders.fetchById ( Deluge Client Script)
Hi Folks, I´m working with two modules Sales Orders and Cases, and I´m needing get from Cases Form the values recorded in the field product_description located in a subform Product_Details in Sales Order module to do a comparation . I´m using this piece
Update Subform when Lookup Module is updated
Hi team, I hope you are all doing great. We would like to create a custom function (Button) that updates the subform values when the source module's field/s is updated/modified. The subform is under the "Quotes" module. Quotes - API name of the Quotes
Zoho Creator Upcoming Updates - September 2023
Hello all! Zoho Creator is on a journey of perpetual improvement, consistently adding new features and enhancements to enrich our platform. Today, we're excited to bring you the latest updates and enhancements for this month: Global variables New default
Is it possible to set arguments in the arguments mapping feature for every use of a function?
Whenever I use argument mapping in functions it drives me insane that I have to create a new function whenever I want to pass another value to a function. Is there a way to set arguments for a function seperately for every use of that function?
postUrl method content length limit workaround
Hello, I'm currently trying to call an API in Deluge and it's giving me the "Invoke url response content length cant be greater than 5 MB" error. Is there a workaround for this? I tested the API on postman and it returned about 7 MB worth of information.
Default field that is present when searching Zoho Invoices is not present when pulling an invoice directly using ID
So when I just pull a list of all records, lets say from the past 7 days. It lists the records in a JSON as expected with data for each. One of the fields listed is "transaction_type". This is generally "renewal", "new", etc. The problem is, when I use
Subforms and Multi-Select Lookup Fields
Hello everyone! In your experience, what is the best way get the data from a subform (only 1 column) and put it in a multi-select lookup field? Thank you!
Best way to clear the response due date in deluge?
When trying to reset the response due date to empty programmatically, I get an internal server error The format works for resetting the due date but not the response due date, is there a specific format I need to use for response due date instead?
Calculate Age by Current Year Deluge
# Tips of the day Calculate the Age from the current year Birthday = "10-Jan-2006".toDate(); age = zoho.currentdate.getYear() - Birthday.getYear(); if(age >= 18) { info "Approve"; } else { info "Under Age"; }
Deluge Code to Create A Purchase Order from Sales Order via Button
Hello community, I need a Deluge code to create a Purchase Order from Sales Order. I want to use a Button for this, so when we hit the button, the PO is created and fields are mapped and the PO is linked to the Sales Order and the Deal. I would be extremely
Function with lookup field to update a field
Hi, I want to update the name of a record based on 2 lookup field in this record. It's working : I have a workflow with this function : resp = zoho.crm.getRecordById("Referencement_expert",Referencement_expert_ID); Er = resp.get("Expert_refere"); Cr =
Get the User Filter value in the Dashboard
Hi team, I have a dashboard with different reports, tables, and widgets in it. The dashboard has one user filter and it's a date filter. I need to be able to get the date value in the user filter. Please let me know how I can do that whether I should
COQL Query, trying to add GROUP BY and SUM
hello I play with coql, works good this my code and the return json (excerpt) queryMap = Map(); queryMap.put("select_query","select el_quote_date, Grand_Total, Contact_Name, Created_By from Quotes where Created_Time between '" + before + "' and '" + cur
Copy autonumber field to a single line field using deluge.
hello everyone. Silly question it might be as a basic script. but not had to do it before. I can't get the unique values up in normal update fields. How would I go about in the customers/accounts module - There is an autonumber field that I want to paste
Extract Pages/Content from Writer File via API or Deluge
Hello, We are wondering if it is possible to extract pages of a Zoho Writer file that is stored in WorkDrive? We have an automation that creates a file for our users to take notes in during a meeting. Pages 1 and 2 will have some information on it that
Formula Field - How to count number of specific weekdays between two dates?
I'm using a formula field in a Request Time Off form to determine how many work days a person will miss if their request is approved. This part of the formula works fine using the workDaysBetween function. However, I want to determine how many regular
openUrl returning "unable to process your request" with "iam-security-error" in new URL
Hello! I have a deluge script that's doing a couple of things off a button press. When openUrl tries to open a new window, I get "Unable to process request." The URL, however, is valid as I have simply returned the URL with copy/ paste and successfully
How to Remove Uploaded File of File Upload Field using Deluge
Hello All, here is example: File Upload Field Name: Unsigned PDF File Name: XYZ.PDF Sample Code: data = zoho.crm.getRecordById("Custom_Function_API",id); pdf = data.get("Unsigned_PDF"); //info pdf; //------------Get Old PDF---------------- for each rec
Macro or function to display each unique value in a column and the count of occurrences
Hi I've been tearing my hair out a bit with this one. I've got a set of data, which I'm applying filters to, but I then need to be able to quickly see how many unique values there are in a given column and the count of each. My initial plan was a VBA
How can I submit a form through deluge?
I have a form that has records which include information on each unique product we sell. Each of these products have their information updated frequently, and thus need new reports printed out each time they're updated. Currently we have to edit the record, submit the update, reopen the record, and click the link that sends us to the report to print. Is there a way that I can click a decision box, have everything in the form update, and then have an openURL pull up the report with updated information
task reminder in deluge
Hello, please, give me a hint, how I can set a reminder for a task I create in script? I made the script which is used in workflow automation for creating a task. It looks like myFieldMap=map(); myFieldMap.put("Task Owner",input.AccountOwner); myFieldMap.put("Subject","Hello");
Get Zoho Analytics Data from the Table by Analytics API
Hello If you are looking for a solution to get the data of Zoho Analytics Data by the API, Please have a look below email = Zoho Analytics Owner Email workspaceName = Zoho Analytics Work Space Name viewName = Table / Report Name Scope will be use:- ZohoAnalytics.data/
Next Page