Disclaimerhttps://www.joellipman.com/static-items/disclaimer.html

30 May 2009 The information contained in this website is for general information purposes only. The information is provided by Joel Lipman .Com and while we endeavour to keep the information up to date and correct, we make no representations or warranties of any...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-handle-commas-between-quotes-in-a-csv.html

26 August 2021 in between a pair of double-quotes. Why? Our use case is that we were trying to loop through rows of a CSV file which contained addresses which in turn contained commas. Saving this as a CSV and asking Deluge to parse the data in the appropriate columns...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 = $00000400 Const STATE_SYSTEM_BUSY = $00000800 Const STATE_SYSTEM_FLOATING = $00001000 ;// Children "owned" Not "contained" by parent Const STATE_SYSTEM_MARQUEED = $00002000 Const STATE_SYSTEM_ANIMATED = $00004000 Const STATE_SYSTEM_INVISIBLE =...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: *

Fun with DllCall in AutoHotkeyhttps://www.joellipman.com/articles/automation/autohotkey/fun-with-dllcall-in-autohotkey.html

27 September 2011 prompt to write to an extra text file which your program has to read, then this is for you. DllCall will usually run contained in the program and can be hidden from the end-user. The one to rule them all: This is a function I pulled from the Autohotkey...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

SSRS Stop Scrolling Behindhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-stop-scrolling-behind.html

08 April 2014 Development Studio What? I recently revamped our standard report with a new template comprising of a single Tablix which contained the images of the corners and sides of the report. It looked beautiful if simply displayed on a single page (the top half...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

XML Schema Referencehttps://www.joellipman.com/articles/web-development/xml/xml-schema-reference.html

13 August 2014 attributeGroup Defines an attribute group to be used in complex type definitions choice Allows only one of the elements contained in the declaration to be present within the containing element complexContent Defines extensions or restrictions on a...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: en-GB

AutoHotkey: Check Windows Folder Sizeshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-check-windows-folder-sizes.html

28 January 2019 how to write an AutoHotkey program to simply return the folders in the drive and display the size of all the files/folders contained within. How? So I'll be putting this program for download from the download section of this website but I don't expect...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

Expecting ZC_SUBFORM_250 expression found COLLECTIONhttps://www.joellipman.com/articles/crm/zoho/expecting-zc_subform_250-expression-found-collection.html

19 October 2020 I was using a custom function to copy all the data from one app to another. The specific form was for "Leads" which contained a subform with a product line item list. If I run this code, I would get the error: Expecting ZC_SUBFORM_250 expression found...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Manage a subform using Client Scripthttps://www.joellipman.com/articles/crm/zoho/zoho-crm-manage-a-subform-using-client-script.html

09 December 2022 client wanted an automation on-the-fly that when selecting a specific value in a field, a row would be added to a subform contained herein. How? Well I won't go in to detail on how to add a client script, this article is just to show the snippet of code...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *