Search - Joel Lipman .Com

1. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; ... the week number: c_Order = Order[ID == 123456890123456890]; if(c_Order.Order_Date != null) { v_ThisDate = c_Order.Order_Date.toString("EEEE, 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"); } // ...; Created on 06 July 2023
2. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; ... 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(); m_Criteria.put("date",v_Date); // // ...; Created on 21 March 2023
3. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... 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'"); // // ...; Created on 28 February 2023
4. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... create a list of pages (specifies the number of pages to try) l_Pages = ; 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 ...; Created on 20 February 2023
5. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; What? This is an article documenting the process of publishing a Zoho Inventory image to eBay's Picture Hosting Services (EPS). Why? Because I couldn't find any other article in the whole world ...; Created on 31 March 2022
6. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... into. For this simply append the following: else if(input.Calendar_Day_Select == "<") { // // set selected date field value input.Selected_Date = input.Starting_Date.subDay(7); input.Starting_Date ...; Created on 09 March 2022
7. Zoho Deluge: Calculate start and end of Daylight Savings Time: / Zoho /; ... end dates for each v_DayIndex in { v_CheckDateStart = v_FromMonthDate1.subDay(v_DayIndex); if(v_CheckDateStart.toString("E")=="Sun") { v_DST_StartTime = v_CheckDateStart; ...; Created on 07 December 2021
8. Zoho Deluge: Duplicate/Clone a Record: / Zoho /; ... now override fields specific to the newly cloned/duplicated record m_Clone.put("Invoice_Status","Repeated Invoice"); m_Clone.put("Invoice_Date",zoho.currentdate.toString("yyyy-MM-dd")); m_Clone.put("Due_Date",zoho.currentdate.addMonth(1).toStartOfMonth().subDay(1).toString("yyyy-MM-dd")); // ...; Created on 17 March 2020
9. Zoho Deluge - First Monday of Month or Last Tuesday of Month: / Zoho /; ... = zoho.currentdate.addMonth(1); v_NextMonthDateLast = v_NextMonthDate.toStartOfMonth().subDay(1); if(v_NextMonthDateLast.getDayOfWeek()!=3) { for each v_MyDay in { ...; Created on 27 September 2019