Zoho

Zoho Deluge - Get distance between two coordinates

: Category: Zoho; 11 June 2019; Hits: 14927

What?
A quick article to document how to calculate the distance "as the crow files" between two coordinates given the latitude and longitude of each.

Why?
Well, you can pay for a good Google solution that will distance following roads and the such but.. the following is free albeit as-the-crow flies.

This makes use of an undocumented function in Zoho which is acos or inverse cosine. Just lifted from the JavaScript library figuring if it supports cos() then try this standard function. Note this has only been tested in Zoho Creator rather than Zoho CRM.

How?
This function returns the distance as the crow flies.

: Category: Zoho; 09 May 2019; Hits: 21899

What?
This is a quick article on how to generate a 5 letter code from several functions: one which returns 5 randomly selected characters and another two which convert a number to 5 letters.

Why?
Zoho doesn't have a function to generate random numbers or strings. There are workarounds however.

How?

: Category: Zoho; 08 April 2019; Hits: 17885

What?
This is a quick article on different ways to get the current user ID in Zoho through code.

How?
I'm not a fan of method #1 but I only started developing in Zoho recently when API v1 was already being deprecated (end of life at the end of this year). So I'm familiar with the methods in API v2 or just using newer functions.

: Category: Zoho; 25 March 2019; Hits: 16772

What
A quick post on how I managed to build a regex to extract all non-numeric characters (all non-digits) from a string.

Why?
I only want the digits/numbers from a string:

v_PaymentTerms = "Credit Note - 30 Days";

// we want the 30 from the above string

How?

: Category: Zoho; 31 May 2019; Hits: 41853

What
A more comprehensive post on some other regex (regular expressions) to format values in Zoho.

How?

: Category: Zoho; 22 February 2019; Hits: 23102

What?
This is an article resolving an issue where a template will shrink all the text when in PDF preview.

Why?
Ok doesn't need a song and dance about it, but I went home yesterday downtrodden by an issue which I'd been working on for most of the day where I would remove all the styling and the text would still appear small. Sure I resized the text to about 46pt and everything was over 3000px in width but this is not good for a final solution. I thought maybe there was a setting for the default font size or where I've accidentally zoomed out in the browser... but these were red herrings as I have other templates that work fine.

How?
The error is one of those that you wouldn't consider relevant in this case, after all, all styling was removed... Here are two screenshots to demonstrate the issue:

: Category: Zoho; 18 February 2019; Hits: 22754

What?
This is an article documenting how to update Creator from a workflow written in a Deluge Script held in ZohoCRM.

Why?
I've also started this article to document an issue we encountered where our code was as per the documentation provided, and the responses returned as successful, but the target fields did not update. This was as a result after changing the owner of the Creator app to another person and adding our previous Super Admin account as a "Developer".

How?
I'm going to demo two methods here using the <connection_link>

: Category: Zoho; 30 January 2019; Hits: 22222

What?
This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet of code below is using the functions to read data from Zoho CRM and to write data back to the system.

Why?
I've rewritten this code a few times and want to store the finalized version (following updates) making it as generic as I can in order to apply it to any client.

How?
Firstly, you will need to browse to https://accounts.zoho.eu/developerconsole and register your new app (or the one you will have completed once copying the below scripts).