Search - Joel Lipman .Com

1. ZohoCRM: Using Criteria with Module Record Count: / Zoho /; What? An example of code using the new API call "Module Record Count" with some criteria. Why? At time of print, I couldn't find an example of how to use this API call with search filters or criteria. ...; Created on 14 November 2023
2. Zoho Recruit: Rollup Number of Recruit Candidates to CRM Account: / Zoho /; ... to the same school and updates some number fields on the matched CRM account. Why? For reporting purposes. Although Zoho Analytics can use data imported from both ZohoCRM and ZohoRecruit, it was ...; Created on 19 October 2022
3. MySQL: Count occurrences of words in a column: / MySQL /; What? This is an article to document how to output the most frequently used words in a MySQL database column. How? Note this only applies to MySQL. So the following query will return a count ...; Created on 12 March 2020
4. Zoho Deluge - Counting in a Map dataType: / Zoho /; What? A quick article on how to count within a map. I didn't have too much difficulty getting this to work and I'm not sure if there are better ways of counting so I'm documenting it to see if I can refine ...; Created on 02 September 2019
5. Zoho Deluge - Get User Timezone, Country and Location: / Zoho /; What? A quick article just as a note to get the users country information from a third-party API based on the given IP address. How? Well this is just a list of free 3rd-party APIs and the below ...; Created on 03 June 2019
6. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; What? This is an article explaining the code needed to write a PHP script which generates an access token for a service account which in turn is used to list files in a team's Google Drive. This is ...; Created on 02 February 2019
7. SELECT COUNT(DISTINCT name) FROM table: / Joomla /; ... statement. Why? The MySQL statement SELECT COUNT(DISTINCT name) FROM table is valid but I get what you mean and it's sometimes difficult to explain why you want to use it. How? Method #1: Add ...; Created on 24 September 2015
8. AHK Countdown Tooltip: / AutoHotkey /; Applies to: Microsoft Windows 7 Enterprise AutoHotkey (see code for AHK version) What? Someone suggested an app that counts the days I have left serving my notice. I thought I'd go one better ...; Created on 17 July 2014
9. Autohotkey Count Number of Files/Folders in a Directory: / AutoHotkey /; ... UserFolder := RegExReplace( MyInputField, "\\$") ; gets rid of trailing slash if required -- Method #1 count := 0 Loop, %UserFolder%\*.*, 0, 1 count++ -- note for future use: ; if A_LoopFileAttrib ...; Created on 04 June 2013
10. Country Lookup by IP address CSV: / MySQL /; ... allocated country. Our use here was to create a refreshable country by IP address list that we can use when parsing our website logs to check where visitors were from. Note: we also use and love ...; Created on 17 March 2013
11. Search a database for a value and count matching rows: / Databases /; What? We have a datawarehouse and we want to be able to count all the records in any table of the database that match on a particular warehouse load. This is a column value where the column is called ...; Created on 05 November 2012
12. Stored Procedure to List Distinct Values and Counts: / Transact-SQL /; ... columns. How? IF OBJECT_ID('usp_ListDistinctValuesAndCounts', 'P') IS NOT NULL DROP PROCEDURE [usp_ListDistinctValuesAndCounts]; GO CREATE PROCEDURE [usp_ListDistinctValuesAndCounts] ( ...; Created on 26 October 2012
13. Counting the occurence of a word within a string: Benchmark: / Personal Home Page /; I added this article because when I was only trying to look up how to do this, this nut "the Storyteller" went and carried out a benchmark test on the most popular ways of counting the occurrence ...; Created on 06 September 2009
14. Zoho CRM: Updating a CRM record Custom Line Items using API v7: / Zoho /; ... apply changes to any of the line items l_NewLineItems = List(); if(!isNull(m_RecordData.get("id"))) { for each m_LineItem in m_RecordData.get("Quoted_Items") { m_NewLineItem = Map(); m_NewLineItem.put("id",m_LineItem.get("id")); m_NewLineItem.put("Description",m_LineItem.get("Description")); m_NewLineItem.put("Discount",m_LineItem.get("Discount")); m_NewLineItem.put("CUSTOM_FIELD_1",m_LineItem.get("CUSTOM_FIELD_1")); m_NewLineItem.put("CUSTOM_FIELD_2",m_LineItem.get("CUSTOM_FIELD_2")); m_NewLineItem.put("Product_Name",m_LineItem.get("Product_Name")); m_NewLineItem.put("Quantity",m_LineItem.get("Quantity")); m_NewLineItem.put("List_Price",m_LineItem.get("List_Price")); l_NewLineItems.add(m_NewLineItem); } } } // // ...; Created on 18 December 2024
15. Zoho Workdrive: Getting Team Folder ID: / Zoho /; ... Upload Error(s) Encountered: When updating members to a workdrive, I was getting errors such as 2945 Invalid JSON 2945 Invalid JSON for each v_RecipientEmail in l_WorkdriveRecipients ...; Created on 11 September 2024
16. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... Created: 2024-08-06 (Joel Lipman) - Initial release - Tidied up, removed commented code - Added Email and Account mapping to ZohoSign Document record Date ...; Created on 06 August 2024
17. Zoho Deluge: Determine your Statement Execution Limit: / Zoho /; ... v_Iteration; } // yields an incremental count from 0 to 4999 Statement Execution Limit is 10000 If the below runs successfully, then the limit is at least 10'000: // v_Counter = 0; l_Loop ...; Created on 31 July 2024
18. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... 'https://analytics.zoho.eu/clientapi/imageLibrary/fetchImage?ZDBFILEID=12345000034567890&ZSOID=20240725001' ) ) AS "Status" FROM "Accounts" ORDER BY "Modified Time" DESC /**** Pseudo: Select Modified ...; Created on 25 July 2024
19. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... = v_Message + "No Datasource Information! Either the data source synchronization has been switched off or there is an error with a connection account between Zoho People and Zoho Analytics. "; } v_Message ...; Created on 02 July 2024
20. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; What? A quick article on how to get the pricebook entry using Zoho Deluge for a specific product in your ZohoBooks or ZohoInventory instance. Why? This took me the best part of an hour to determine ...; Created on 23 May 2024