Search - Joel Lipman .Com

1. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; What? This article serves as a best practice and reminder to myself on how to stop endless loops from happening in Creator and crashing the application. This is more for complex Creator forms which ...; Created on 19 September 2021
2. ZohoCRM: Using Criteria with Module Record Count: / Zoho /; ... Not sure about the rest of you, but I've been using this for pagination purposes and for the system to work out how many pages or loops in total it would need to do. How? Here's a couple of working ...; Created on 14 November 2023
3. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... on the employee record So now we just need to append the following code which loops through the map / associative array we just created and shove this onto every employee's record. My employee recor ...; Created on 28 March 2023
4. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... - Trigger: Standalone function triggered on execute Purpose: Loops through all candidates and creates records referring to the Candidate Ref and Job Opening Date Created: 2023-02-02 ...; Created on 08 February 2023
5. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... are zeros... But I'm keen on avoiding using loops where possible so we don't breach a statement execution limit in the Zoho app function. How? If we're not going to use loops, then the next best thing ...; Created on 08 February 2022
6. Zoho Creator/Deluge: UnPredictable exception, Invalid statement found: / Zoho /; What? Just a quick article if you get the above error and what to look for. Why? I was writing a function with perhaps too many for each loops within a for loop. How? The following is 1 ...; Created on 17 November 2021
7. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... the function I came up with. It loops through a maximum of 2500 products sorted in order of ID ascending (starting with ID=0) retrieving 250 per call and using since_id to not list the same one twice ...; Created on 12 October 2021
8. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... the following code which generates a sample CSV and then loops through storing each row as a data record and outputting it to screen: // generate a sample CSV file v_DataCSV = "1,Joel Lipman,Kings ...; Created on 26 August 2021
9. ZohoCRM: Process all records of a module: / Zoho /; ... Reactivate any workflows you deactivated in step 1. Sample Code Consider the following standalone function which loops through every contact and deletes the duplicate lead (if a lead exists with ...; Created on 24 August 2021
10. Zoho Deluge: Sort a Map by a specific field: / Zoho /; What? This is a quick article to template some code to me on sorting a map variable in Zoho Deluge, specifically Zoho Creator. Why? I do this a lot but in the following example, I want to sort ...; Created on 29 January 2021
11. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; What? The aim of this article is to document how you can display a Creator report to the user, that they can select (tickbox) multiple records in that report, and then have a button that loops through ...; Created on 06 December 2020
12. AutoHotkey: Check Windows Folder Sizes: / AutoHotkey /; ... Subroutine: LoopThrough: loops through folders and counts file sizes (including subfolders) LoopThrough: SB_SetText("Reading current directory...") vTotalSize = 0 Loop, Files, %MyBaseDir%\*, F { ...; Created on 28 January 2019
13. Import Excel CSV file as JavaScript array: / Excel /; ... contents - Loops through each row and splits by commas (not within quotes) - Sorts the final array by a object label function populate_array_from_csv(this_file){ // using deprecated ...; Created on 05 October 2015
14. Migrating from Joomla 2.5.x to 3.4.x: / Joomla /; ... E a.`fieldtochange` LIKE '%stringtofind%' Watch out for any recursive loops. Disclaimer: As I use this on more websites, I will update this article accordingly. At the time of print, I ha ...; Created on 12 September 2015
15. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... buffer it loops through each of the input columns passed into the component // It locates the actual column value (including checking for null) using the index array created in the Pre-Execute ...; Created on 04 October 2013
16. A for loop within a for loop in MS-DOS: / MS-DOS /; ... the following loops through directory for any file beginning with Reference FOR %%A IN ('DIR InitializingFile*') DO ECHO %%A -- yields: InitializingFile_123.csv InitializingFile_456.csv -- the ...; Created on 03 October 2013
17. T-SQL Record Separator: / Transact-SQL /; I have googled, binged and asked but to no avail. Some self-proclaimed IT experts in forums said "why would you want to do that?". Unhelpful Bellends. It's a bit like asking me "Why can't I turn on ...; Created on 11 October 2011
18. Joes FREE Website Thumbnailer (JWT): / Product Documentation /; ... one. Question How does the thumbnail name generating work? Answer: The program loops through the images folder and finds a name that isn't taken (something like "000065.bmp"). It won't overwrite existing ...; Created on 28 June 2011