Zoho Deluge: Calculate start and end of Daylight Savings Time https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-calculate-start-and-end-of-daylight-savings-time.html
07 December 2021
First Sunday in November at 2:00 // // Starts Second Sunday in March at 2:00 v_FirstMonthDate = toTime(zoho.currentdate.toString("yyyy") + "-03-08 02:00:00"); // // Ends First Sunday in November at 2:00 v_LastMonthDate =...
Type: Article
Author: Joel Lipman
Category: Zoho Deluge
Language: *
Zoho Deluge - Get English Ordinal https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-english-ordinal.html
08 November 2018
This is how I was doing it previously. // get the date (eg. 1, 2, 3,... 29, 30, 31) This_Day_Date = My_Date_Field.toString("d"); // determine English ordinal English_Ordinal = "th "; if(This_Day_Date == "1" || This_Day_Date == "21" || This_Day_Date ==...
Type: Article
Author: Joel Lipman
Category: Zoho Deluge
Language: *
ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoice https://www.joellipman.com/articles/crm/zoho/zoho-books/zohocrm-to-zohobooks-api-half-a-cent-or-penny-off-when-creating-an-invoice.html
20 March 2025
rounding v_Rounded = v_Rate.round(2); info "a) " + v_Rounded; // Yields: 12345.55 // Regexed v_RegexedNumber = v_Rate.toString().replaceAll("^(\\d+\\.\\d{2})\\d*$", "$1"); info "b) " + v_RegexedNumber; // Yields: 12345.54 // 2 characters after period...
Type: Article
Author: Joel Lipman
Category: Zoho Books
Language: *
Zoho Deluge: Today, Tomorrow, Day After but Skip Sunday https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-today,-tomorrow,-day-after-but-skip-sunday.html
02 November 2021
v_NextDay = v_NextDay.addDay(1); } // if(v_NextDay.getDayOfWeek()==1) { v_NextDay = v_NextDay.addDay(1); } info v_Today.toString("EEEE dd-MMM-yy"); info v_Tomorrow.toString("EEEE dd-MMM-yy"); info v_NextDay.toString("EEEE dd-MMM-yy"); // // yields: //...
Type: Article
Author: Joel Lipman
Category: Zoho Deluge
Language: *
ZohoCRM & Xero: Function to pull most recent invoices https://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-invoices.html
09 October 2025
HH:mm:ss",v_XeroTimeZone); m_UpsertCrmInvoice.put("Invoice_Date",d_XeroInvoiceDate.toString("yyyy-MM-dd")); v_XeroInvoiceDueDate = m_ThisInvoice.get("DueDate"); d_XeroInvoiceDueDate =...
Type: Article
Author: Joel Lipman
Category: Zoho CRM
Language: *
ZohoCRM & Xero: Function to pull most recent quotes https://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-quotes.html
13 October 2025
m_ZohoTaxRatesByRate.put(m_TaxRate.get("value").toDecimal().round(3).toString(),m_TaxRate.get("id")); } } info m_ZohoTaxRatesByName; info m_ZohoTaxRatesByRate; // // do Xero stuff if(v_AccessToken != "") { m_Header = Map();...
Type: Article
Author: Joel Lipman
Category: Zoho CRM
Language: *
Zoho Deluge - First Monday of Month or Last Tuesday of Month https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-first-monday-of-month-or-last-tuesday-of-month.html
27 September 2019
break; } } // if last Tuesday is before today if(v_NextMonthTuesday.toDate() 0) { v_DayIndex = 2; } else if(v_InputSwitch.toString().indexOf("Tuesday") > 0) { v_DayIndex = 3; } else if(v_InputSwitch.toString().indexOf("Wednesday") > 0) { v_DayIndex = 4;...
Type: Article
Author: Joel Lipman
Category: Zoho Deluge
Language: en-GB
Zoho Creator: Receive eBay Order Notifications via Webhook https://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-receive-ebay-order-notifications-via-webhook.html
20 September 2021
// // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("",""); // // send the request XML as a string r_ResponseXML = invokeurl [ url...
Type: Article
Author: Joel Lipman
Category: Zoho Creator
Language: *
Zoho Deluge and Wordpress/WooCommerce API: Get All Products https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-and-wordpress-woocommerce-api-get-all-products.html
15 April 2024
100 categories so let's start counting r_Categories = invokeurl [ url: v_EndpointCategories + "?" + l_ConnectionParams.toString("&") + "&" + l_PaginationParams.toString("&") type: GET ]; v_TotalProducts = 0; v_TotalCategories =...
Type: Article
Author: Joel Lipman
Category: Zoho Deluge
Language: *
Zoho Deluge: Get the Week Number if Week starts on a Monday https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-the-week-number-if-week-starts-on-a-monday.html
06 July 2023
all the orders of a specific week... Just to confuse everyone in the world, the day index for a Sunday is 7 (ie. myDate.toString("u") returns 7) and the week commences on a Sunday (ie. myDate.toStartOfWeek("EEEE") returns Sunday). In other words, the...
Type: Article
Author: Joel Lipman
Category: Zoho Deluge
Language: *
Zoho Deluge: Loop through 30 Minute Slots https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-loop-through-list.html
30 November 2018
rid of all picklist options clear Time_field; // begin populating options thisStartHour = thisServiceRecord.Opening_Time.toString("HH"); thisClosingHour = thisServiceRecord.Closing_Time.toString("HH"); hourString =...
Type: Article
Author: Joel Lipman
Category: Zoho Deluge
Language: *
Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books https://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html
15 May 2020
+ "." + v_FieldName); l_BuildUrl.add("download"); l_BuildUrl.add(v_PermalinkCode); v_DownloadUrl = l_BuildUrl.toString("/"); v_FileDownloadUrl = v_DownloadUrl + "?filepath=/" + v_FileInternalName; // // yields something like //...
Type: Article
Author: Joel Lipman
Category: Zoho Books
Language: *
Zoho Projects: Add a Time Log to an Issue using Deluge https://www.joellipman.com/articles/crm/zoho/zoho-projects/zoho-projects-add-a-time-log-to-an-issue-using-deluge.html
30 April 2021
v_TimeHour + ":" + v_TimeMinutes; // // build map m_CreateTimeLog = Map(); m_CreateTimeLog.put("date",v_StartTime.toDate().toString("MM-dd-yyyy")); m_CreateTimeLog.put("bill_status",v_Billable); m_CreateTimeLog.put("hours",v_HoursHHmm);...
Type: Article
Author: Joel Lipman
Category: Zoho Projects
Language: *
Zoho Creator: Public URL of an Image field / Upload to Shopify API https://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html
17 October 2021
v_Filename); m_Params.put("image", m_SubParams); // v_Endpoint = v_ShopifyURL + "/admin/api/" + v_ShopifyApiVersion.toString() + "/products/" + v_ShopifyProductID + "/images.json"; r_UploadPhoto = invokeurl [ url :v_Endpoint type :POST headers:m_Header...
Type: Article
Author: Joel Lipman
Category: Zoho Creator
Language: *
Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL) https://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html
14 February 2022
// // set endpoint to retrieve 5 products v_Endpoint = "https://" + v_ShopID + "/admin/api/" + v_ShopifyApiVersion.toString() + "/products.json?limit=5"; // // curl (zoho invoke) request r_GetProduct = invokeurl [ url :v_Endpoint type :GET...
Type: Article
Author: Joel Lipman
Category: Zoho Creator
Language: *
Zoho Creator: Radio group into Calendar Carousel https://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-radio-group-into-calendar-carousel.html
09 March 2022
for each index v_DateIndex in {1,2,3,4,5,6,7} { input.Calendar_Day_Select:ui.add(zoho.currentdate.addDay(v_DateIndex).toString("EEEE") + "" + zoho.currentdate.addDay(v_DateIndex).toString("d") + "" +...
Type: Article
Author: Joel Lipman
Category: Zoho Creator
Language: *
Zoho Inventory: Mark a package slip as delivered and shipped https://www.joellipman.com/articles/crm/zoho/zoho-inventory/zoho-inventory-mark-a-package-slip-as-delivered-and-shipped.html
14 July 2022
!= "") { v_PackageID = input.Zoho_Package_ID; r_PackageSlip = zoho.inventory.getRecordsByID("packages",v_BooksOrgID.toString(),v_PackageID,"ab_inventory"); if(r_PackageSlip.get("package") != null) { if(r_PackageSlip.get("package").get("salesorder_id")...
Type: Article
Author: Joel Lipman
Category: Zoho Inventory
Language: *
Zoho Webhooks & Shopify API: Keep Disappearing https://www.joellipman.com/articles/else/e-commerce/shopify/zoho-webhooks-shopify-api-automatically-restore.html
22 April 2024
m_CreateRecord = Map(); m_CreateRecord.put("Event_Type","Order Update"); m_CreateRecord.put("JSON_Payload",m_Payload.toString()); r_CreateRecord =...
Type: Article
Author: Joel Lipman
Category: Shopify
Language: *
Zoho Workdrive: Getting Team Folder ID https://www.joellipman.com/articles/crm/zoho/zoho-workdrive/zoho-workdrive-getting-team-folder-id.html
11 September 2024
// create sub folder v_ParentFolderID = "{parent_id}"; v_WorkdriveFolderID = ""; v_WorkingFolderName = zoho.currentdate.toString("yyyy"); if(!m_SubfolderNames.keys().contains(v_WorkingFolderName)) { m_Attr = Map(); m_Attr.put("name",...
Type: Article
Author: Joel Lipman
Category: Zoho Workdrive
Language: *
Zoho Deluge - Get Full Day Name https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-full-day-name.html
08 November 2018
This is a very quick note with the code to retrieve the full day name from a date (eg. "Monday"). Why? If I use the toString() function to get the day, it only returns the first 3 letters of the day (eg. "Mon"). My_Date = today; Day_Name =...
Type: Article
Author: Joel Lipman
Category: Zoho Deluge
Language: *