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.

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?

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.

Zoho Creator - Integration with Shopify Checkout/Storefront API

What?
This is a not so quick article on how to build up a checkout cart page with Zoho Creator which directs the customer to a Shopify payment page.

Why?
I didn't find anything on the web via Google or Bing that clearly explained how to connect to Shopify API and build the checkout page without making my app into a Sales Channel.

How?
The trick is to actually ignore the Checkout API and the standard error(s) while trying to create a checkout with a storefront access token:
[API] Invalid key or access token (unrecognized login or wrong password)
or how about:
[API] This action requires merchant approval for write_checkouts scope.

Further to this, an order is created when a draft order accepts payment!


Related Articles

Joes Revolver Map

Joes Word Cloud

file   solution   name   display   find   date   windows   table   parameter   mysql   list   version   code   content   where   script   site   would   using   user   system   first   source   note   program   license   error   database   page   report   example   value   data   files   added   server   used   copy   joomla   select   work   google   could   need   search   following   zoho   time   website   uploaded   JoelLipman.Com

Accreditation

Badge - Certified Zoho Creator Associate
Badge - Certified Zoho Creator Associate

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin - Valid till 8 May 2022 3QnhmaBX7LQSRsC9hh6Je9rGQKEGNQNfPb
© 2021 Joel Lipman .com. All Rights Reserved.