Assuming following is required, the following 283 results were found.
-
v2. How? Note that this is using Zoho Deluge and not another server-side script such as PHP to send the requests via API. Following standard OAuth 2.0 procedures, we will get a Code to generate a Refresh token, once we have a Refresh token we will...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
HH:mm:ss", "Europe/London"); Additional The reverse (date string to unix seconds) can be done using either of the following: v_MyDate = "2020-04-01 12:34:56"; v_UnixSeconds = v_MyDate.toTime().toLong(); info v_UnixSeconds; // or v_UnixSeconds =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
or creator.cs.zohohost.eu depending on the value obtained step 1c above. Add another CNAME record with the following: name as .myparentdomain.com ("code" is 6-character code obtained in step 1c above) If allowed set the TTL (time to live) to 300 Set the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
some code to me on sorting a map variable in Zoho Deluge, specifically Zoho Creator. Why? I do this a lot but in the following example, I want to sort a list of records by their date in descending order. Yes this functionality exists in reports but I...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
As you may already know, when you queried CRM for that field, you received a JSON response somewhat similar to the following: // this is sample JSON with replaced IDs "My_CRM_File": [ { "extn": "pdf", "is_Preview_Available": true, "download_Url":...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
zoho.crm.getRecords then press Enter (DO NOT START TYPING FOR A MODULE NAME - LET THE SYSTEM POPUP YOUR OPTIONS AS PER THE FOLLOWING SCREENSHOT - USE ARROW KEYS OR MOUSE): As you can see from the screenshot above, there are modules concatenated with one...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
name "Account"; Then I have a workflow on user input of the field to save this directly to the record; You would think the following would work: r_Details = myForm[ID == 1234567890123456789]; r_Details.Account = input.Account; But it will return the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
with the field link name as "Save_and_Close" (the field link name is important for the next step: CSS styling): Apply the following styling (this will depend on the theme you are using): .zc-Save_and_Close-group .decision-box-field label{ display:none...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
m_Params.toString() connection: "joels_coql_connection" ]; // // output info r_Coql; But this returns something like the following (I've reduced the 200 records to about 6 of them): { "data": [ { "Currency": "EUR", "id": "123456789000000001" }, {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
the scopes: WorkDrive.files.ALL, WorkDrive.workspace.ALL Click on Create and Connect > Accept Get the Template ID The following snippet is a separate function to run (standalone) and will return to you the templates and the field references: r_Templates...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
error and what to look for. Why? I was writing a function with perhaps too many for each loops within a for loop. How? The following is 1 fix for the error: Execution Failed UnPredictable exception, Invalid statement found Line:(20) I cannot guarantee...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
our CRM. We're meant to do 40 hours, not just for Management, but for deducting from project and support bundles. How? The following snippet of code is on a CRM schedule set to run every Friday at 08:00 in the morning and will create a task if time...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
say whether Daylight Savings Time is in effect for this timezone or not. So let's pretend we have a creator form wth the following fields: TZ Database Name (single-line) UTC Offset (single-line) UTC DST Offset (single-line) DST In Effect (boolean) With...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
for invoices and contacts. Category: Standalone Click on Create Give it the parameter: crmAPIRequest (string) Dump in the following code: // enter the webhooks key for your app (in Xero under Manage App > Webhooks) v_Webhook_Key =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
a certain point but didn't round up the numbers, in other words, it didn't remove the unnecessary zeros. Note that in the following regex, and if using Zoho Creator, you need to replace the double-backslash with a single backslash: v_Test1 = 12.300;...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
info "Response of attempt to upload to Zoho Inventory:"; info r_UploadPhoto; You should get a response similar to the following: {"code":0,"message":"We've updated the item image. Nice one, by the way!"} Update 2024: Following Books Domain Upgrade // //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
ZDK.Page.getField('Deployment_Rate_Log').setValue(json_Parsed); } // don't save record? return false; Note(s) Using the following line returns all subform rows, even deleted ones, which is why we didn't use this command in the system. But keeping it for...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
to the form whenever it is created or edited, on load of the form; I call mine "OnLoad". For Deluge Script, add the following: // // CSS overrides v_CssNotes = ""; // // this line hides the delete/cross icon next to each row v_CssNotes = v_CssNotes +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
asked that the address on the CRM record 'pulls through'. Sending the address in the same request however gives me the following error: { "code": 15, "message": "Please ensure that the billing_address has less than 100 characters." } How? So the quick...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
+ v_ImageURL; } } } return v_ImageURL; Function: fn_Settings_EmailSignatures Important: the following code will overwrite ALL signatures in the CRM. The email signature it will overwrite is the one held in ZohoCRM > Setup > Channels > Email > Email...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *