Assuming zoho is required, the following 213 results were found.
-
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...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
This is an article documenting how to send a Zoho Deluge Map request to an API which is expecting nested/2d/multi-dimensonal arrays. In the example below, we are posting to a PHP script for testing but I have since sent something similar to an API...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
one of the column values into the target How? So this is my plan: Setup a connector to CRM with the scopes ZohoCRM.coql.READ and ZohoCRM.modules.ALL Build up a SQL query, or more specifically, a COQL - CRM Object Query Language Try using distinct on a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
API which returns a timezone. Why? Our use-case is that we have a field called "Customer's Time Zone" on the lead record in ZohoCRM. It should be auto-populated... How? As mentioned, we're going to use the address on the Lead record; use Zoho's GeoCode...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an order record in Zoho Creator. We did the same for when Shopify would process an order. You can see my following articles for more information on...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Following on my article of creating a task using Zoho Deluge and scheduling a call using Zoho Deluge, here's an article on creating a Meeting or an Event using Zoho Deluge. Why? Because at time of print, I couldn't find that much information on how to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
because I spent so long trying different snippets of code to enable tracking when using Deluge code to create an item in Zoho Inventory: Why? Who uses ZohoInventory for anything else than tracking stock...? How? So the quick answer is one missing...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
seemed to do the same thing but unnecessarily moved the pointer to the start of the week. It could also error eventually if Zoho made it possible to change the start of the week (this is in ZohoCreator; I'm aware that some of Zoho Apps do allow this) in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
This is an article to document how we created a button off a Bill record in ZohoBooks which generates a text file to be sent to a bank and downloads it to the staff member's workstation. Why? Why is this a challenge? The file contains bank details and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
A collection of code snippets I seem to be regularly using to generate a dynamic map of system values held in a ZohoBooks instance. Why? Rather than hard-coding and having a ton of if..then statements, I can feed these maps a textual value and it...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
A quick article on how to get the pricebook entry using Zoho Deluge for a specific product in your ZohoBooks or ZohoInventory instance. Why? This took me the best part of an hour to determine by going through forum posts from 7 years to 2 years ago. The...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
I couldn't find anything that documented this with a working example. Why? The use-case here is that we want to make a ZohoCreator page display events for this month from ZohoProjects. How? The bit that stumped me was making a call to the Events...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *
-
A very quick article on how to check what the statement execution limit is on the Zoho application you are working in. Why? Our use-case is that an application we built in Zoho Creator was hitting statement execution limits and rather than proposing an...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
An article on adding an accept and decline button on the estimate (aka Quote) notification template within ZohoBooks. Why? The use-case is simply that my client wants to make it easier for their customers to accept or decline a quote. Sure there's a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
I didn't realize I needed: How to address the above error and how to update a Shipping Address for a specific Sales Order in Zoho Books. Why? You might think the following request to create a Sales Order in Zoho Books would be enough: { "date":...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
What? A quick follow-on article to my previous article on Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo. Why? Connecting to OpenAI ChatGPT is all very well and good, but this forgets what you were talking about after each chat. So it's good for 1...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
template to it: The Solution After removing all styling, taking away classes and ID fields that might have been reserved for Zoho rendering (which did nothing to fix this problem), I found the cause of all the pain. I was setting a cover page (as per...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
overall Tax on this record (where p_QuoteID is the ID of the quote): // init Map m_UpdateQuote = Map(); // r_QuoteDetails = zoho.crm.getRecordById("Quotes", p_QuoteID); v_SubTotal = r_QuoteDetails.get("Sub_Total").toDecimal() * 0.2; v_GrandTotal =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
and someone may want to open this in Google Sheets or Microsoft Excel: // // init l_NewCSVrows = List(); v_ThisEventTime = zoho.currenttime; // // loop through dataset for each r_Event in zoho.crm.getRecords("Events", 1, 200,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
a subform and rows while you are creating a record containing the subform. Why? The use case here is for a Quote Builder in Zoho Creator: Create a quote record and include a subform containing the line items. You may have tried code where you add a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *