Search - Joel Lipman .Com

1. Prefix Line Numbers in a Text File: / MS-DOS /; Intro Prefixing lines with their respective line number in a text file using a Microsoft Windows Operating System... I've just googled this as I couldn't remember how I did this last time and a number ...; Created on 18 July 2012
2. Zoho Creator: Input Color Picker: / Zoho /; ... Just for fun The code to display hexadecimal or RGB value in the fields: Created or Edited > On User Input > Color Picker if(!isNull(input.Color_Picker)) { v_HeximalRef = input.Color_Picker.getsuffix("background-color:").getprefix(";"); input.Hexadecimal ...; Created on 14 October 2024
3. 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
4. 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
5. 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
6. 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
7. Zoho Deluge: Proper Case for Names: / Zoho /; ... " :|JOEL|: ", true).proper(); v_FirstName = v_FirstName.replaceAll(" :|joel|: ", "-", true); // // Names starting with Mc, O', D', I' l_ExceptionPrefixes = ; // // deal with double barrelled surnames l_FormattedLastName ...; Created on 13 July 2023
8. 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
9. 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
10. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... shared can be controlled/monitored. Create a CRM Module called "GPT Chats" (singular: GPT Chat) Modify the name field to be an Auto-Number (I'm prefixing mine with CHAT- Add a pick list called ...; Created on 06 March 2023
11. 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
12. 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
13. 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
14. ZohoCRM: Import Attachments: / Zoho /; ... This is a "zcrm_" prefixed ID of the user who owns the attachment. Modified By Id: This is a "zcrm_" prefixed ID of the user who modified the attachment. Created By Id: This is a "zcrm_" prefixed ID of ...; Created on 16 January 2023
15. 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
16. 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
17. 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
18. 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
19. 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
20. 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