Users Module List in Deluge
Hello everyone, I am using deluge function for to get users list. I can take all user list but I need to specific field For example : GetUser.get("status"); status field but it is not working. Result null Do you have any idea? Note: you can see result of code from screenshot GetLead = zoho.crm.getRecordById("Leads",LeadID); PersonelID = GetLead.get("Owner").get("id"); GetUser = zoho.crm.getRecordById("users",PersonelID); status = GetUser.get("status"); info status ;
Create entry in Custom Module when creating Deal & Populate Lookup fields
I have a custom Module titled "Agreements" which is CustomModule10 Whenever I create a Deal I want an Agreements module entry created and pre populated with information from the Deal. 3 Lookup Fields are in CustomModule10 Contact Deal Account
Problem at the time of copying data from Parent Module to chiled one
Hello I have customized the default function "Mass update of Child Contacts" to copy some fields from Parent Module Leads to child Module Message. We have an structure where one Lead (Email, type) may have many messages, one per (email,Type) combination is contacting us. I am trying to move some details from Lead to the message, so we can generate some automation based on those fields. But I am getting below error: 'TEXT' can not be cast to '[BIGINT]' for the function 'get'at lineNumber 14 The code
Counting the completed tasks for a contact
Hi Community. We use tasks to track our emails, calls and voice messages. We are putting together a prospecting process that is based on a 90 day cycle of 8 outreaches. After the 90 days we take 60 days off and start the 90 day cycle again. Currently i need to look through all the activities for the contact, eliminate the completed tasks older than 90 days and add up the recent activity. Is there is a easier more automated way to do this? I know that i can run a report but I would like to
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
Datetime and timezone not being changed in function
Hi, I have a datetime field that I'm storing in one of my custom modules. In a custom function, I take that datetime (called tourDate) and try to convert it a String in the US/Central timezone (looked like it comes into the function as a UTC datetime since it shows as 5 hours ahead of me after formatting) like below: tourDate = tourDate.toString("yyyy-MM-dd hh:mm:ss a z","America/Chicago"); I'm noticing two problems after doing that. First, a tourDate that I schedule in my module as May 20, 2019
Automatically Change Deal Name upon creation
I'm looking to automatically update the Deal Name to be called "Deal Name + Custom Auto Populated Number" I'm new to ZOHO, but after reading a few articles I thought this would do it: mp=map(); mp.put("Deal_Name",name); update=zoho.crm.updateRecord("Deals",name, mp); info mp; info update; Update Arguments for name="custom auto number" ------------------- I'm probably pretty far off as I can't get it to do anything. Help would be very appreciated. Thanks.
Run custom button on multiple stores.
Hello, I am trying to make a custom button that can run on multiple records. I am using a custom function. The problem is that instead of running the function on each store, it is passing all the stores into one function. For example if I have a parameter in the function for the storeId when click the button it will pass all the store Id's that I have selected into one parameter in form 330xxxxxxxxxxxx40|||330xxxxxxxxxxxx21|||330xxxxxxxxxxxx30. I tried to replace the ' ||| ' separator it gives me
Only Retrieving the first Record from zoho.crm.getRelatedRecords()
Hello I have been coding for some years but am new to Deluge. I need to get the IDs of every Store that is related to a Deal. "Stores" Is a custom Module and is a RELATED LIST in Deals. When I use run.. storeData_list = zoho.crm.getRelatedRecords("Stores","Deals",330XXXXXXXXXXXX); info storeData_list; I get... {"$approval":{"delegate":false,"approve":false,"reject":false,"resubmit":false},"Owner":{"name":"Jxxxxx Waxxxx","id":"33XXXXXXXX"},"Modified_Time":"2019-08-13T14:36:09-05:00","$currency_symbol":"$","Created_Time":"2019-08-13T14:36:09-05:00","$review_process":null,"$editable":true,"Deals":{"name":"Dexxxx","id":"33xxxxxxxxxxxxx001"},"Stores":{"name":"Roxxxx
postUrl with authorisation
Hi I am attempting to integrate Zoho CRM with Signable but need to know if the postUrl function has sufficient functionality to achieve this. Here is some PHP cURL code which performs a very simple task (retrieving all contacts) successfully. How would this be entered into the postUrl function? Specifically, how do I pass the api key and password? Here is my code. <?php // Initialize cURL $ch = curl_init(); $url = 'https://api.signable.co.uk/v1/contacts?offset=0&limit=10'; // Set URL on which
Script Popup
When managing Leads in Z CRM, when employee answers a phone call or calls a lead, would like for a predefined script to pop up that is populated with the Lead's name. Suggestions? JLW
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
Convert to JSON format
How can i convert following to json format using deluge, i have debugged a bit found that i need to replace ],[ with , (comma), but i have no success. [{ "name": "Ron", "email": "ron@test.com" }, { "name": "Jaby", "email": "jaby@test.com" }],[{ "name": "Karen", "email": "karen@test.com" }, { "name": "Clowy", "email": "clowy@test.com" }]
Sending an automated email with quote line items
Hi there, I would like to send an email with the quote product line items within the actual email, and I would like this to be automated. Is this possible? Surely there is a custom function we can write here? Thanks Michelle
assign based on office hours
can i assign a ticket based on office hours? if ticket arrived during office hours, assign to TEAM 1, if ticket arrived outside office hours, assign to TEAM 2?
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
Our return in functions in buttons give white window
Starting yesterday our returns in functions in buttons are giving a white window. Do anyone knows if something has to change now with the API 2.0? Here is the piece of code: if ( input.proy == "" ) { return "Message 1"; } else { return "Message 2"; }
Deluge script to record level sharing
Hi, how can we check to whom a specific record is shared? and how can we record level share a specific record? Example: USER X owns "ACCOUNT A"s record, and all "ACCOUNT A" Potentials (we do this thru a custom function that puts potentials owner = account owner)... USER X shares "ACCOUNT A" and POTENTIAL 1 with USER Y.... When USER Y creates a new "ACCOUNT A" potential... the system creates it but USER Y is not able to see it, because USER X becomes the record owner (again thru our custom function)
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();
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