Search - Joel Lipman .Com

1. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... "T"," ",true).getPrefix("+").toTime().toString("dd-MMM-yyyy HH:mm","Europe/London")); } if(!isNull(r_RecordDetails.get("Service_End_Time"))) { m_Data.put("Service_End_Time",r_RecordDetails.get("Service_End_Time").replaceAll ...; Created on 06 August 2024
2. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... e order")) { v_PO_Ref = "PO-" + m_Comment.get("description").getSuffix("PO-").trim().getPrefix(" "); m_Details = Map(); m_Details.put("po_ref",); m_Details.put("po_date",zoho.currentdate.toString("dd-MMM-yyyy")); m_Details.put("last_modified",zoho.currentdate.toString("dd-MMM-yy ...; Created on 09 July 2024
3. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... product photo c_Product = Products[ID == c_Quote.Product]; if(c_Product.count() > 0) { v_ProductPhotoFile = c_Model.Product.getSuffix("http").getPrefix("\"").getSuffix("/image/"); v_ProductPhotoURL ...; Created on 07 May 2024
4. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; ... = v_ImageSrc.getPrefix("\""); if(!isBlank(v_ImageSrc)) { // use a try...catch as some file types may cause this to partially fail try { v_CountNew = v_CountNew + 1; f_DownloadFile ...; Created on 26 January 2024
5. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; What? This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records... Why? ...; Created on 27 April 2023
6. 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
7. 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
8. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; What? An article on how I can query all the orders for yesterday without using the eBay GUI Selling website. I've included the code to parse out the information as well. Why? Because I need this ...; Created on 28 February 2023
9. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... = "\"" + v_ProductHandle + "\""; } v_Shopify_Created = v_ProductCreated.getPrefix("Z").replaceAll("T"," "); v_Shopify_PublishedStr = if(!isNull(v_ProductPublished),v_ProductPublished,v_Shopify_Created); v_Shopify_Published ...; Created on 20 February 2023
10. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
11. Zoho CRM & Deluge: Adding 10 minutes to a CRM Date Time field: / Zoho /; ... r_LeadDetails.get("Created_Time").toString("yyyy-MM-dd"); // // parse time into HH:mm:ss v_LeadCreatedTime = r_LeadDetails.get("Created_Time").getSuffix("T").getPrefix("+"); // // combine into a sql format ...; Created on 11 November 2021
12. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... = ; c_Document = My_Form[ID == 1234567890]; // // for image field type v_PhotoFull = ifnull(c_Document.My_Photo,""); v_PhotoWithExt = v_PhotoFull.getSuffix("/image/").getPrefix("\""); v_PhotoFileExtension ...; Created on 17 October 2021
13. Zoho Creator / eBay: Get all Active Products: / Zoho /; What? This is an article to document a function used in Zoho Creator to retrieve the Product IDs of all the active products in a client's eBay store. Why? The use-case was that I wanted to retrieve ...; Created on 13 October 2021
14. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... tidy up the response so we can executeXPath x_Response = r_ResponseXML.executeXPath("/*/*").toXmlList(); for each x_Node in x_Response { if(x_Node.contains("").getPrefix(" 0) { v_AccessToke ...; Created on 20 September 2021
15. Zoho Deluge: Push a value to a datetime field in CRM: / Zoho /; ... would be: v_CrmTime = "2021-01-01T01:23:45+01:00"; v_CreatorTime = v_CrmTime.getPrefix("T") + " " + v_CrmTime.getPrefix("+").getSuffix("T"); info v_CreatorTime.toTime(); // yields 01-Jan-2021 01:2 ...; Created on 10 September 2021
16. Zoho Deluge: Zoho Bookings Get Available Slots: / Zoho /; ... && !isNull(r_AvailableSlot)) { v_HourCheck = r_AvailableSlot.getPrefix(":").toLong(); if(v_HourCheck < 12) { input.Morning:ui.add(r_AvailableSlot); v_CountMorning = v_CountMorning ...; Created on 23 June 2021
17. Zoho Deluge: Sort a Map by a specific field: / Zoho /; ... date format), arrange so it can be sorted alphabetically in reverse order v_DatePart = v_SortingKey.getPrefix("T").toDate().toString("yyyy-MM-dd"); v_TimePart = v_SortingKey.getSuffix("T").getPrefix("+").subString(0,5); v_SqlDateTime ...; Created on 29 January 2021
18. Zoho Deluge: Get Image Uploaded in Creator Form: / Zoho /; ... com.cn (China), ... v_TLD = "eu"; // my creator form f_MyImages = MyImages[Name == "Logo"]; v_Filename = f_MyImages.MyImage.getSuffix("/image/").getPrefix("\""); // specify publish key of published ...; Created on 14 July 2020