Zoho Deluge: Get the Week Number if Week starts on a Mondayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-the-week-number-if-week-starts-on-a-monday.html

06 July 2023 dd-MMM-yyyy u w"); v_ThisWeek = if(c_Order.Order_Date.toString("u").toLong()==7,c_Order.Order_Date.subDay(1),c_Order.Order_Date).toString("w"); } // Monday, 26-Jun-2023 1 26 // yields: 26 // // Sunday, 02-Jul-2023 7 27 // yields: 26 // // Monday,...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Radio group into Calendar Carouselhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-radio-group-into-calendar-carousel.html

09 March 2022 if(input.Calendar_Day_Select == "<") { // // set selected date field value input.Selected_Date = input.Starting_Date.subDay(7); input.Starting_Date = input.Starting_Date.subDay(7); // // set the values for the calendar select field clear...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

20 February 2023 = {1,2,3}; for each v_Page in l_Pages { if(b_HasNextPage) { // // query using GraphQL v_UpdatedSince = zoho.currentdate.subDay(1).toString("yyyy-MM-dd'T'00:00:00+0000"); if(v_Page == 1) { v_GraphQl = "{ productVariants(first: " + v_PerPage + ", query:...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge - First Monday of Month or Last Tuesday of Monthhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-first-monday-of-month-or-last-tuesday-of-month.html

27 September 2019 Tuesday of Month") { v_NextMonthDate = zoho.currentdate.addMonth(1); v_NextMonthDateLast = v_NextMonthDate.toStartOfMonth().subDay(1); if(v_NextMonthDateLast.getDayOfWeek()!=3) { for each v_MyDay in {1,2,3,4,5,6,7,8} { v_NextMonthDateLast =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

ZohoDeluge: Get All eBay Orders Given a From and Till Datehttps://www.joellipman.com/articles/crm/zoho/zohodeluge-get-all-ebay-orders-given-a-from-and-till-date.html

28 February 2023 */ // // evaluate (specify here your dates [time set to midnight]) v_timeFrom = zoho.currenttime.subDay(0).toString("yyyy-MM-dd'T'00:00:00.000'Z'"); v_timeTill = zoho.currenttime.addDay(1).toString("yyyy-MM-dd'T'00:00:00.000'Z'"); // // get access token...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoDeluge: Check Shipment Status via DHL APIhttps://www.joellipman.com/articles/crm/zoho/zohodeluge-check-shipment-status-via-dhl-api.html

21 March 2023 through for each index v_Index in l_GeneratedList { // output to developer for debug purposes v_Date = zoho.currentdate.subDay(v_Index).toString("yyyy-MM-dd"); info v_Date; // // set criteria of what shipment orders to retrieve m_Criteria = Map();...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *