Search - Joel Lipman .Com

1. The greatest invention in IT: / IT Support /; Not a useful note and more of a personal opinion then factual, but beyond the inventors of the Internet or any hardware has to be the following notion from IBM: a 1976 research report by Lance A. ...; Created on 13 September 2012
2. 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
3. Zoho Workdrive: Getting Team Folder ID: / Zoho /; ... upload the file to this folder if(v_WorkdriveFolderID != "") { v_PermaLink = ""; // // generate a test CSV v_NewLineChar = hextoText("0A"); l_Csv_File = ; v_UploadFilename = " Test Upload ...; Created on 11 September 2024
4. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... Joel Lipman")) { v_ManagerID = m_User.get("id"); v_ManagerFullName = m_User.get("full_name"); v_ManagerEmail = m_User.get("email"); } } } // // OVERRIDES: for testing purposes if(b_Debug) { v_EngineerFul ...; Created on 06 August 2024
5. Zoho Projects: Get All Events: / Zoho /; ... The above is great on a test system where you don't have many events, but what if this the system has far more than 50 events, past or upcoming? Here's the code to get a single event record by its record ...; Created on 22 July 2024
6. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; ... tests show this only returns the 1 relevant item from a pricebook of many more items l_PriceBookItems = ifnull(r_ThisPriceBook.get("items"),{}); for each m_PriceBookItem in l_PriceBookItems ...; Created on 23 May 2024
7. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... = User Acceptance Testing) to ensure this behaves as expected. So I found another function was being run when a contact record is created and I appended this snippet of code to the end of it. Note tha ...; Created on 14 May 2024
8. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... repeats the header on every page. The key here is the HTML attribute zcpage-headerhtml: My Company Ltd Test Street, Test County TEST1 ZIP1 +44 (0)1234 567890 This email address is being protected from spambots. You need JavaScript enabled to view it. ...; Created on 07 May 2024
9. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; ... function to rule-them-all This code was used for testing, then for correcting any historical records, and then when given just one ticket reference; will create or update the images associated in the ...; Created on 26 January 2024
10. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... to only push valid image file types as files. The report will work for Zoho Users... didn't really test on permissions and sharing the report, I was logged in as the super admin on both ZohoDesk and ZohoAnalytics ...; Created on 05 December 2023
11. ZohoCRM: Using Criteria with Module Record Count: / Zoho /; ... whose Campaign_Name is "CRM" and not records with "Best CRM" or "Latest CRM" in their Campaign_Name fields. When you use parentheses or comma in the value for a criteria, you must escape them using a backslash. ...; Created on 14 November 2023
12. Zoho CRM: ZDK Client Script: Auto-Select Pipeline based on User Department: / Zoho /; ... Pipeline"); } Save and Close Issue(s) Encountered Using the CS IDE Run: This can't run ZDK Apps.CRM.Users (this can't read any module)... Simply save the above code and test it using th ...; Created on 16 October 2023
13. Zoho Creator: Sendmail a list of attachments: / Zoho /; ... to me that perhaps this isn't clearly documented. But there are tips found across the web just not specifically addressing this. How? Here is the code for a test function which downloads 2 files ...; Created on 20 July 2023
14. Zoho CRM: Change System Field Length: / Zoho /; ... the "Lead Conversion Mapping" page, mapping it, and then testing by converting a lead to a deal. Actions Login to ZohoCRM > Setup > Modules and Fields Click on the "Deals" module (or whichever module ...; Created on 19 June 2023
15. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... that shipment is not created. More Info: - API Explorer Test Tool: https://developer.ebay.com/DevZone/build-test/test-tool/default.aspx?index=0&env=production&api=trading - GetMyeBaySelling ...; Created on 27 April 2023
16. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... 21917182) - Modified to check that there are some orders. More Info: - API Explorer Test Tool: https://developer.ebay.com/DevZone/build-test/test-tool/default.aspx?index=0&env=production&api=trading ...; Created on 29 March 2023
17. ZohoBooks: Stripe Terminal Integration: / Zoho /; ... (Joel Lipman) - If custom field "Amount To Be Taken" is not greater than zero, then defaults to balance due of invoice. More Information: TEST PAYMENT SCENARIOS WITH PHYSICAL TEST ...; Created on 16 March 2023
18. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... initialize v_Response = previousParam; m_Response = Map(); m_Response.put("todo","prompt"); l_Messages = List(); // // capture latest message from user v_Message = ifnull(userInput,""); m_Thread ...; Created on 06 March 2023
19. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... Created: 2023-03-01 (Joel Lipman) - Initial release Date Modified: ???? - ??? More Info: - API Explorer Test Tool: https://developer.ebay.com/DevZone/build-test/test-tool/default.aspx?index=0&env=production&api=trading ...; Created on 01 March 2023
20. ZohoDeluge: Inserting a new line character in a CSV: / Zoho /; ... systems: l_CsvFileRows = List(); l_CsvFileRows.add("Me,Myself,I"); l_CsvFileRows.add("a,b,c"); // v_CSVFilename = "Test.csv"; f_CSVFile = l_CsvFileRows.toString("\n").toFile(v_CSVFilename); // // ...; Created on 01 March 2023