Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://joellipman.com/articles/crm/zoho/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

18 August 2025 It was partly written by referring to documentation and using CoPilot or OpenAI ChatGPT for parsing the return value of the function (note that I have SCRIPT within the BODY tags and not in the HEAD): Loading... Please Wait... console.clear();...

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

Add "Command prompt from here" to right-click context menuhttps://joellipman.com/articles/microsoft/windows-os/add-command-prompt-from-here-to-right-click-context-menu.html

27 January 2010 For the Action type what ever you want the context menu to display, I use Command prompt from here For the Application value type c:\windows\system32\cmd.exe (this will be different on winnt, browse if unsure to your cmd.exe program) Click on OK > OK >...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Oracle SQL - Convert given list (CSV) into Rowshttps://joellipman.com/articles/database/pl-sql/oracle-sql-convert-given-list-csv-into-rows.html

30 August 2011 Taken from the Oracle forums @ https://forums.oracle.com/forums/thread.jspa?messageID=6861756 Situation I have one column of values that I've suffixed a comma to but I want to display this as a rows in a table. This is for Oracle PL/SQL. My List: 1, 2,...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Convert Decimal (Person Days) to Time in Excelhttps://joellipman.com/articles/microsoft/excel/convert-decimal-person-days-to-time-in-excel.html

13 February 2013 How? The answer was always going to be a convoluted formula just to convert it into minutes and then format the resulting value into a custom format of [h]:mm:ss -- Aim / Objective: ColumnA ColumnB ColumnC ---------- ---------- ----------- Task 1 0.14...

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

Trim in T-SQL and SSIShttps://joellipman.com/articles/microsoft/ssis/trim-in-t-sql-and-ssis.html

14 May 2013 LOWER( REPLACE( REPLACE( REPLACE( myString, "\x0009", "" ), "\x000A", "" ), "\x000D", "" ) ) ) Using it to compare to a value? There are cases in T-SQL where the trim is unecessary and a similar equation can be written: Table: DMExtractEmployeeTable ID...

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

Disable User Registration in Joomla 1.5 - Configuration Filehttps://joellipman.com/articles/cms/joomla/disable-user-registration-in-joomla-1-5-configuration-file.html

08 October 2013 (or "#__components" where "#_" is the site table prefix. default is "jos"). Open the row where name="User Manager" Set the value under params for AllowUserRegistration allowUserRegistration=0 to disable it. allowUserRegistration=1 to enable it. Not...

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

SSRS Border Problemhttps://joellipman.com/articles/microsoft/ssrs/ssrs-border-problem.html

20 January 2014 This selects all cells. Now open the "Properties" pane, find the "BorderStyle" and type the word "None" next to it (as its value). Press the "Enter" key if you need to. You are now free to apply normal borders to each specific cell.

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

CSV Chart Generatorhttps://joellipman.com/component/content/article/csv-chart-generator.html?catid=40

04 September 2015 intended to chart EventViewer "Security" logs but I quickly found that I could make it group and chart any Comma Separated Value file.

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Zoho Deluge - Get Full Day Namehttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-full-day-name.html

08 November 2018 = My_Date.toString("EEEE"); // returns "Monday" Method #1: We're going to populate two arrays / lists; retrieve the index value; and use this in the second array as follows: // lists Day_Names =...

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

Zoho Deluge - MD5 functionhttps://joellipman.com/articles/crm/zoho/zoho-deluge-md5-function.html

19 November 2018 // returns error Error on Execution Execution Failed Due to invalid expressions insert statement is terminated Line:(102) Value of the field Etag length should be lesser than or equal to MaxLength 255. Line:(132) It's not in the documentation but...

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

Zoho Deluge: Generate and Send a CSV via Emailhttps://joellipman.com/articles/crm/zoho/zoho-deluge-generate-and-send-a-csv-via-email.html

16 June 2021 How? Rather than just babble on about it, here's the code, replace what you need just noting that I'm enclosing each value with double-quotes because the values might have commas and someone may want to open this in Google Sheets or Microsoft Excel: //...

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