Search - Joel Lipman .Com

1. Zoho CRM: Change System Field Length: / Zoho /; ... record to an opportunity (or Deal) record. If you are using custom fields, then just ensure that the data type and field lengths match. In this case, they are system fields for the Postal Code which ...; Created on 19 June 2023
2. ZCRM Client Script: Correct Decimal Fields OnLoad: / Zoho /; ... var fn_CountDecimals = function(value) { if (Math.floor(value) !== value) return value.toString().split(".")[1].length || 0; return 0; } // get the value from ...; Created on 13 December 2023
3. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... = List(); for each m_User in r_Users.get("users") { v_CurrentSignature = ifnull(m_User.get("signature"),""); // // criteria, only update signatures which aren't done? //if(v_CurrentSignature.length( ...; Created on 05 December 2023
4. 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
5. 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
6. 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
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 Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... at 1/10th the cost of text-davinci-003) gpt-4 gpt-4-32k (up to 4x the context length) Source(s): OpenAI - Documentation - API Reference - Making Requests OpenAI Account - API keys OpenAI ...; Created on 13 February 2023
10. ZohoCRM: Import Attachments: / Zoho /; ... static MD5_DIGEST_LENGTH := 16 hModule := DllCall("LoadLibrary", "Str", "advapi32.dll", "Ptr") , VarSetCapacity(MD5_CTX, 104, 0), DllCall("advapi32\MD5Init", "Ptr", &MD5_CTX) , DllCall("advapi32\MD5Update", ...; Created on 16 January 2023
11. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... we don't want based on criteria l_NewSubformRows = new Array(); for (i = 0; i < l_existingSubformRows.length; i++) { // check row hasn't already been entered, here we are using the start ...; Created on 09 December 2022
12. Zoho Deluge: Generate a loop or list of any size: / Zoho /; What? This is an article on a trick I picked up from one of our interviewees as well as apparently in one of the Zoho documentation manuals. It uses leftpad to create a string of a length, converts ...; Created on 21 October 2022
13. 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
14. 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
15. 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
16. AutoHotkey: Get Media Information and Display: / AutoHotkey /; ... Return } SplitPath, sFile, _FileExt, _Dir, _Ext, _File, _Drv If ( p[p.length()] = "xInfo" ) ; Last parameter is xInfo { p.Pop() ...; Created on 07 August 2020
17. MySQL: Count occurrences of words in a column: / MySQL /; ... have added a WHERE clause which omits words less than 5 characters in length, and some other words not to count. I have added the ORDER BY to give me the highest count first in descending order. I ...; Created on 12 March 2020
18. Zoho Deluge - Pad with leading Zeros: / Zoho /; ... So going through the forums you may find the following example: string padWithLeadingZeros(int finalStringLength, int startingNumber) { return leftpad(toString(input.startingNumber), input.finalStringLength).replaceAll(" ...; Created on 07 February 2020
19. Autohotkey - Chrome Profiles in Alphabetical Order: / AutoHotkey /; ... FileRead, OutputContent, %PreferenceFile% NameStart := InStr(OutputContent, """name"":""")+8 NameEnd := InStr(OutputContent, """", false, NameStart+1) NameLength := NameEnd - NameStart ...; Created on 07 January 2020
20. Zoho Deluge - Generate 5 Letter Booking Retrieval Code: / Zoho /; ... generateRetrievalCode() { // init v_Output = ""; l_Output = List:String(); l_Alphabet = ; v_StrLength = 5; // everyday I'm shufflin l_OutputShuffled = List(); ...; Created on 09 May 2019