Search - Joel Lipman .Com

1. Zoho Deluge: Convert Hex to RGB: / Zoho /; What? A quick article to document a Zoho Deluge function converting a hexadecimal color reference to a Red Green Blue value (RGB). Why? It's likely that Zoho will avail their color picker at some ...; Created on 11 October 2024
2. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... t = v_SignType; // // Specify template ID // check URL for mail merge template: https://writer.zoho.eu/writer/open/ 0) { v_Filename = v_Filename.subString(0,v_Filename.lastIndexOf(".")); } r_ZS_Download.setFileName(v_Filena ...; Created on 06 August 2024
3. 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
4. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... grade v_ConditionChar = ifnull(c_Quote.Grade_Condition,"C").subString(0,1); v_ConditionDisp = if(v_ConditionChar == "N","New",v_ConditionChar + " Grade"); v_ItemDescDisp = v_ItemDescDisp + "" ...; Created on 07 May 2024
5. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; ... = ifnull(c_Document.File_field,""); // // used for blocking certain file extensions (not used in this function) v_DocExtension = v_DocFileName.subString(v_DocFileName.lastIndexOf(".") ...; Created on 26 January 2024
6. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... = ifnull(p_DownloadImageUrl,"https://joellipman.com/tmp/icon_linkedin.jpg"); v_FileName = v_ImageToDownload.subString(v_ImageToDownload.lastIndexOf("/") + 1); // // get file object f_File = invokeurl [ url ...; Created on 05 December 2023
7. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... ifnull(r_ContactDetails.get("Mobile"),r_ContactDetails.get("Phone")); } // // ---------------------- QUOTE DATES ---------------------- m_CreateEstimate.put("date",r_QuoteDetails.get("Created_Time").subString(0,10)); if(!isnull(r_QuoteDetails.get("Valid_Till"))) { m_CreateEstimate.put("expiry_date",r_QuoteDetails.get("Valid_Till").subString(0,10)); } // // ...; Created on 18 September 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 /; ... from eBay:"; //info x_ResponseBody; // // get pagination results from the first iteration/page if(v_Page == 1) { // // get page results x_PaginationResult = x_ResponseBody.subStrin ...; Created on 29 March 2023
10. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... ChatGPT")) { // // store user input to a CRM record m_Create = Map(); v_Title = if(v_UserMessage.length()>40, v_UserMessage.subString(0,40) + "...", v_UserMessage); m_Create.put("Title", v_Title); m_Create.put("Content" ...; 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 CRM: Manage a subform using Client Script: / Zoho /; ... // other fields to fill in for this subform row v_RateCardDisp = v_RateCard.indexOf(" (")>0 ? v_RateCard.substring(0, v_RateCard.indexOf(" (")) : v_RateCard; json_Arg.Rate_Change_Notes = v_RateCardDisp; ...; Created on 09 December 2022
14. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; ... added row in that subform (on user input). This sets the document name for display later: if(!isnull(row.Document_File)) { v_FileDetected = row.Document_File; if(v_FileDetected.contains("_")) { v_SubstringStart ...; Created on 11 March 2022
15. Zoho Creator: eBay: Get Item Transaction: / Zoho /; What? This is the function to get the line item order/transaction from eBay if you give it the eBay Item ID as a parameter. Why? Mostly for debugging but here's the code that will quickly get ...; Created on 22 January 2022
16. 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
17. Zoho Creator/Deluge: Calculating with Timezone Offset: / Zoho /; ... = "(+01:00) Europe/Luxembourg"; v_CustomerOffset = "+01:00"; // // calculate GMT v_CustomerPlusMinus = v_CustomerOffset.subString(0,1); v_CustomerHours = v_CustomerOffset.subString(1,3).toLong(); v_CustomerMinutes ...; Created on 07 December 2021
18. Zoho CRM: Schedule a Task: Timesheet Reminder: / Zoho /; What? A quick article to demonstrate code that creates a task in CRM based on the time logged against an Event/Meeting. Why? As developers, we're keep account of our time and we are currently ...; Created on 02 December 2021
19. Zoho CRM & Deluge: Adding 10 minutes to a CRM Date Time field: / Zoho /; ... timezone, add 10 minutes, re-assemble it in a format that CRM likes, and update the field: // // parse date into yyyy-MM-dd (using subString - reliable) v_LeadCreatedDate = r_LeadDetails.get("Created_Time").subString(0,4) ...; Created on 11 November 2021
20. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... = v_PhotoWithExt.subString(v_PhotoWithExt.lastIndexOf(".") + 1).toLowerCase(); // if(l_CompatiblePhotoExtensions.containsIgnoreCase(v_PhotoFileExtension)) { v_ThisPhotoSrc = "https://creator.zoho.com/file/appowner/appname/My_Form_Report/" ...; Created on 17 October 2021