Search - Joel Lipman .Com

1. Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd): / Zoho /; What? A quick article to remind me of the regex to change a date from the format dd/MM/yyyy to yyyy-MM-dd. Why? Irrespective of server, organization or user settings, the date handling can vary. ...; Created on 01 September 2021
2. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... e = v_SignDate.toDate("yyyy-MM-dd"); r_Update = zoho.crm.updateRecord("zohosign__ZohoSign_Documents",v_ZS_DocRecordID,); v_DebugMessage = v_DebugMessage + "ZS Doc Update: " + r_Update + " "; } } // ...; Created on 06 August 2024
3. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... double-check in case books has returned 1st page rather than filtered rows if(m_DataRow.get("SO ID") == v_SalesOrderID) { m_Details = Map(); m_Details.put("po_date",m_DataRow.get("PO Date").toDate().toString("dd-MMM-yyyy")); m_Details.put("po_ref",); m_Details.put("po_status",m_DataRow.get("P ...; Created on 09 July 2024
4. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... datatype v_TimeOffset = (v_LeadCreatedTime.subString(0,10) + " " + v_LeadCreatedTime.subString(11,25)).toString("yyyy-MM-dd HH:mm:ss", v_ThisTimeZone); // // set reminder time (exactly 1 working day ...; Created on 14 May 2024
5. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... = c_Quote.Email; } v_QuoteDate = c_Quote.Modified_Time.toString("dd-MMM-yyyy"); c_AddedBy = Staff[Zoho_Creator_User == zoho.loginuser]; if(c_AddedBy.count() > 0) { v_AddedBy = c_AddedBy.Name; } break; } } %> /* ...; Created on 07 May 2024
6. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... + zoho.currenttime.toString("yyyy-MM-dd HH:mm","Europe/London")); m_WebhookLog.put("Body",m_Payload.get("body")); m_WebhookLog.put("Event_Type","Inventory Update"); m_WebhookLog.put("Source","Shopify"); m_WebhookLog.put("Data_Format","JSON"); r_WebhookL ...; Created on 22 April 2024
7. 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
8. Zoho Deluge: Determine if Daylight Savings are in effect: / Zoho /; ... "GMT"), true, false); info b_IsDSTInEffect; // v_TimeZoneOffset = if(b_IsDSTInEffect, "+01:00", "+00:00"); // // usage v_SendToCRM_DateTime = zoho.currenttime.toString("yyyy-MM-dd'T'HH:mm:ss","Europe/London" ...; Created on 03 July 2023
9. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... enter your own organization ID here for ZohoBooks and ZohoInventory v_BooksOrgID = 12345678901; // // evaluate v_currentDate = zoho.currentdate.toString("yyyy-MM-dd"); v_OrderDate = zoho.currentdate.toString("yyyy-MM-dd"); v_Page ...; Created on 27 April 2023
10. Zoho Deluge: Get All Orders from eBay: / Zoho /; What? Following on from my article: ZohoCRM: Get All eBay Active Listings, this is how to get all the orders from a client's eBay. Why? Our use-case is a data migration from eBay to a fresh instance ...; Created on 29 March 2023
11. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... = zoho.currenttime.toString("yyyy-MM-dd ") + m_ShiftBuildUp.get(v_WorkDay).get("open").leftpad(5).replaceAll(" ", "0") + ":00"; v_FinishTime = zoho.currenttime.toString("yyyy-MM-dd ") + m_ShiftBuildUp.get(v_WorkDay).get("close").leftpad(5).replaceAll(" ...; Created on 28 March 2023
12. 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
13. ZohoBooks: Stripe Terminal Integration: / Zoho /; ... "In Person - Card"); m_CreatePayment.put("amount",v_AmountReceived / 100); m_CreatePayment.put("date",zoho.currentdate.toString("yyyy-MM-dd")); // l_Invoices = List(); m_ThisInvoice = Map(); m_ThisInvoice.put("invoice_id",v_ZB_InvoiceID.toString()); m_ThisInvoice.put("amount_applied",v_AmountRecei ...; Created on 16 March 2023
14. ZohoCRM: Get All eBay Active Listings: / Zoho /; What? Another one of these articles talking about getting all the active product listings from eBay for a specific client. Why? Our use-case scenario here is that we want to get an inventory ...; Created on 01 March 2023
15. 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
16. 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
17. ZohoCRM: Import Attachments: / Zoho /; ... the user who created the attachment. Created Time: This is the created time of your file in the format that your CRM system is using (eg. "dd/MM/yyyy HH:mm:ss") Modified Time: This is the modified time ...; Created on 16 January 2023
18. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... // accommodate for timezone offset v_LocalStartDate.setMinutes(v_LocalStartDate.getMinutes() - v_LocalStartDate.getTimezoneOffset()); // return in yyyy-mm-dd format (on save this will display ...; Created on 09 December 2022
19. Zoho Deluge: Generate a loop or list of any size: / Zoho /; ... my list to populate l_CheckDates = List(); // // loop through generated list and add dates for each index v_Index in l_GeneratedList { if(v_Index>0) { l_CheckDates.add(zoho.currentdate.addDay(v_Index).toString("yyyy-MM-dd")); } } ...; Created on 21 October 2022
20. Zoho Inventory: Mark a package slip as delivered and shipped: / Zoho /; ... != null) { v_ShipmentID = r_PackageSlip.get("package").get("shipment_order").get("shipment_id"); // // if blank then create one if(v_ShipmentID == "") { m_Params = Map(); m_Params.put("date",zoho.currentdate.toString("yyyy-MM-dd")); m_Params.put("delivery_method","My_Own_Drivers"); m_Params.put("delivered_date",zoho.currentdate.toString("yyyy-MM-dd ...; Created on 14 July 2022