Syntax for updating a record "stage" that is in a blueprint
I'm writing a custom function that will update a record's "stage" based on an change to a related parent record. The child records are all active in a predefined Blueprint. When I run the custom function to update the "stage" of the child record, nothing happens. For testing, I disabled the Blueprint on the child records, ran the function, and the "stage" field updated as expected. It seems the Blueprint is preventing my custom function from progressing my child records through the Blueprint stages/states.
Deluge should permit a connection to be set with a variable
Hello, Being one who occasionally likes to post code in the forums, I try to make anything that the end user needs to define be present at the very top of the script so that those who want to implement the script won't have to hunt through lines of code,
Deluge Training
I have been beating my head on the Deluge wall for over a week now. Watched dozens of videos. Read lots of help forums. Read docs galore. Is there any decent training available? Please something more than "it is so simple...." or "here are all the great things it can do" Most of the stuff I find is pre 2018 and does not reference the current functionality.
How to overcome Zoho Deluge's time limit?
I have built a function according to the following scheme: pages = {1,2,3,4,5,6,7,8,9,10}; for each page in pages { entriesPerPage = zoho.crm.getRecords("Accounts",page,200); for each entry in entriesPerPage { … } } Unfortunately, we have too many entries
SendMail in CRM Deluge function rejects a validated email address
In a CRM Deluge function, the email address is considered invalid. Is there another method by which it can be validated? It's unacceptable in my current situation to use either the zoho.loginuserid or adminuserid as the From address.
Sort a list of key-values elements
Dear community, I have the following question. I have list called list_values: list_values = {{"name":'Carl',"age":6},{"name":'Adam',"age":8},{"name":'Bob',"age":9}}; I want to reorder the list values based on the name key of each key-value element, the
How to use hash sha256 in zoho creator?
Hello everyone, I need to ask you about hash function in zoho creator. Because I want to import some data from another website, and in that website, it need to has their signature in SHA256. In PHP, its very easy, you just use the HMAC function: "string hash_hmac ( string $algo , string $data , string $key [, bool $raw_output = false ] )" But its so hard in zoho. Its cost me 1 month to find solution for this. If there is no way to has string by SHA256 in zoho creator, could anyone please give
Need Custom Function that will send an email template/notification to user
We have a custom function that is triggered when a new ticket is created. Inside that custom function we have some conditions that determine next steps. in one of those conditions we want to trigger an email notification to be sent. How do we use Deluge
Deluge and Javascript/Node.JS code examples (and others?) should be added to the API docs instead of just CURL
Hello. While I realize that it's not rocket science to convert from CURL, it would undoubtedly save a lot of time if the code examples for Zoho's own app API documentation also included examples for both Deluge (which I'm kinda surprised isn't there,)
EMAIL TEMPLATES | DELUGE
Good day Zoho Team, I am trying to create a custom function on sending email notification with different conditions, Is it possible to insert the created custom email template to my custom function? The email template contains content with several placeholders.
Help with zoho.crm.getRecords
Dear community, I have one question about a deluge function. I'm using the function zoho.crm.getRecords("Accounts", 0, 200, {"cvid": 3966036000418539959}); To return all the records from my custom view id 3966036000418539959. The issue I'm facing is
Desk Search tickets only returning 10 records
I am attempting to make a schedule to make tasks to review older tickets but it is only getting ten records. The response gives a count of much more then 10. is there a limit to the size of the return I have tried setting the limit parameter higher but
Integration with Google Groups API, and OAuth2
Has anybody successfully created a connection to Google Groups using OAuth2? Had a long session with Zoho Support today, and neither I nor they could work it out. Essentially: - new custom connection to Google Groups, like all connections, requires completion of settings shown in attachments 'Zoho Connection creation' x2 - In the corresponding Google API section ("Google Credentials' attachment), I've created credentials (details of which are inserted above) - When the connection is created, Google
What is the best way to develop in deluge?
Hello fellow developers, I want to ask all of you a question: What is the best way to develop with deluge in a daily basis? I mean. Most of the time I am making tests with functions and with real data, but when I am debugging, a lot of the times nonsense
Deluge Script Converting Time Wrong
Good day everyone. I'm hoping someone can help me solve this problem. With the help of several of you, I created a script that will allow me to convert a date/time field to a written field. It works great but I didn't want the seconds to show so I removed
Get the context ticket ID to move it to a different department using custom functions.
Hi, My goal is to move a ticket from one department to another on a field update, using custom functions. I'm picturing the ticket as an object, so when I have it opened in front of me, and I want to apply the function to it, how do I pass the ticket
Google Drive API integration - request body - invokeurl
Hi, I am accessing Google Drive API (documentation at https://developers.google.com/drive/api/v3/reference/files) through Zoho CRM. This is working fine, using commands like the following, which pull a Google Drive folder reference from the Contact, and returns a list of files inside that folder: gdriveURL = "https://www.googleapis.com/drive/v3/files"; mapParameters.put("q","'" + Contact.get("gdriveextension__Drive_Folder_ID") + "' in parents and (name contains 'foo' or name contains 'bar') and trashed
Get the related subform records
I have a main form called Creative Media Calls in Zoho Creator that has a products/service subform. How can I loop through the related subform records of the products/services. i.e. for each related subform record{ check the service selected } I found how to getAll() the subform records, however I just need the related subform records of the parent form record. Thanks for your help with this, Thomas
Creating Time Based Alerts for Tasks assigned to a ticket
There are a few parts to this question, i am trying to automate some processes and make sure nothing is falling through the cracks for our tickets. Currently we have a workflow rule that when a certain field is updated, it changed the status of the ticket and creates a task assigned to the ticket owner. Question 1 - Under workflows -> Tasks (where i created the task) can i put a token in the Subject field of the task? Currently we have the Task called "Create Proof", so in the task view, there might
Trying to update one record from another
I am using a custom function and going out of my mind - I just don't know why such an ordinary function is so hard and there should be a standard way of doing this I need to get the data from a field in a related record and put it into the same record in another one. In this case for a particular client they want to be able to update Lead filed with the phone number and email address from a contact where the person is already in the CRM lead=input.leadID.toString(); contact=input.contactID.toString();
Retrieving dropdown values in a tabular section
Hi, I would like to retrieve all the values from a dropdown list for a field in a tabular section from the employee form in a deluge script. Any help would be appreciated. Thanks
Sending email alerts based on responses in a form for a schedule
Hi I have 4 fields named below with data type in brackets: 1 Feedback_required? (Yes/No) 2 Date_Feedback_To_Be_received (Date) 3 Feedback_Received? (Yes/No) 4 Feedback_Received_date (Date) I would like this to happen under Schedule possibly done through script: If Feedback_required is Yes and Date_Feedback_To_Be_Received is known, then I would want a alert or email notification to be sent every weekday until Feedback_Received is Yes and a date is entered in Feedback_Received_date. Cheers Casper
Converting XML to JSON
Hi! I need to convert a variable in XML to JSON. Can i do it without using an API on deluge? I looked into the documentation but couldn't get any answers to this. Thank you in advance!
Is there a way to automate adding Client Users to a Project?
I've been struggling to find a solution to this issue in these forums. Is there any way I can automate so that upon Project creation, Client Users are automatically associated from the CRM Contacts module?
How can I set the task layout when creating a project with Deluge
Hi, I am automatically creating a new project in Zoho projects with Deluge. I cannot find any documentation on how to set the task layout, which needs to be set at the project level upon creation, as far as I can tell. I can see the response when the
Error code 7049 - No record available with the specified record ID
Hi, I am working on a data migration, reading the data from the Certifications tabular section from the employee form to insert them in a new form (Certifications2). I created a record in my new form for each employee using the import. My script: ---------------------------------------------------------------------------------------------------------------------------
Zoho Project: Obtain Project Group ID(s)
Hi, I am wrapping up the last of an automated function in Zoho CRM for creating projects from successful potentials. One 'put' that I am not able to complete is with respect to the project group association. I am having trouble completing because I can't locate the group ID values of my existing groups so as to provide the value for that key-pair. Does anyone know of a way to see this information outside of API? I've looked in the Zproject backup, in the browser website address, in the projects
Is there a way to force a write commit?
I have Deluge code, triggered by a workflow, that creates a Workdrive folder structure. There are times when the workflow must be getting triggered in quick succession, because two folders get created. My code properly checks for the existence of the
Any opened Deluge repository ?
I plan to use a bit Deluge for some functions in our Zoho One, I was wondering is there were some open repository of scripts or snippets ? This would be a way for me to start learning :) As for a start, I'd like to get message in my Cliq, when I get an estimate approval request. This is parallel to the email notification, I just want to test with Cliq. Thanks !
Function error "HTTP Status 400 – Bad Request"
I have a function in a workflow that trigger when lead is created, the function is working fine for more than 2 years but recently we're having this issue were it fails and the reason for failure is HTTP Status 400 – Bad Request. However when I execute
Need Help Converting CURL to Deluge
Hi, I am having an issue with converting a CURL command into Deluge. The CURL Command is formatted as follows (token is a bogus string): curl https://{subdomain}.zendesk.com/api/v2/users.json \ -H "Authorization: Bearer 52d7ef4ee01e2c2c75bff572f957cd4f12d6225eee07ea2f01d01a"
File Attachment API does not return a value when there are no attachments
I need to know if a call to: https://www.zohoapis.com/crm/v2/{module_api_name}/{record_id}/Attachments has null results. It appears to return nothing, not even "null." Video explanation here: https://workdrive.zohoexternal.com/external/554971171ccf
Adding multiple rows in worksheet using insertCSV function
Hi I need to add 2 rows in a sheet using insertCSV function. The CSV string looks like "Row1Col1,Row1Col2\nRow2Col1,Row2Col2" When using this with the insert CSV function, there is only one row inserted with the entries as Row1Col1 Row1Col2\nRow2Col1 Row2Col2 Basically the \n is not recognised as a new line character. Where am I going wrong ?
Convert String to Date
Hi There, I am trying to convert a string to a date with MM/dd/yyyy formatting but I cannot get it to work. The field Departure_Date_Website holds the value of: Sep 09, 2024 resp = zoho.crm.getRecordById("Leads", recordid); stringdate = resp.get("Departure_Date_Website");
No Output from Custom Function
Hi Guys, This is my first ever attempt to write in deluge so please go easy. I needed to create a custom function in Zoho Flow - to turn a full name string like "Ian Robert Smith" in to a separate output of First Name and Last Name i.e. "Ian" and "Smith"
Add Owner to deluge-created module record note
Is it possible to include the "owner" aka "creator", of a Note when creating it via delulge? This sets "superadmin" as the Note creator. I need to override it. notemap = Map(); notemap.put("Parent_Id",program_contact_id); notemap.put("Note_Content",program_contact_data.get('Note'));
Deluge functions for Zoho Campaigns
Zoho's website lists Zoho Campaigns as supporting Deluge: https://www.zoho.com/deluge/help/zoho-services-supporting-deluge.html But when I try to call Zoho Campaigns Deluge functions from Zoho CRM under Integrations, I cannot find it in the list of services
Delete Registro no Zoho CRM usando Zoho Deluge
Pessoal, eu estou precisando fazer uma script para apagar milhares de registros Potenciais dentro do meu Zoho CRM, mas não estou conseguindo encontrar a função específica para apagar 1 único registro. deleteResponse = zoho.crm.delRecord("Deals", potencial.get("id"));
Clarification on Workflow and API Limits
Hi Team, Greetings! Are there any specific limits for the workflow, or does it consume API limits? Kindly share your thoughts on this.
What is the format string for toDateTimeString to conver to a CRM date-time field?
This ain't it. toDateTimeString(time,"yyyy-MM-ddThh:mm:ss","CST");
Next Page