ReCaptcha disappears from Joomla 2.5 Registrationhttps://www.joellipman.com/articles/cms/joomla/recaptcha-disappears-from-joomla-2-5-registration.html

24 November 2013 form... There are two solutions I have found that fix the problem: Method #1 I prefer this method as it changes less code and is more likely to be supported in a Joomla update. Open the file /plugins/captcha/recaptcha/recaptcha.php and find the...

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

Sort an associative array by values in Javascripthttps://www.joellipman.com/articles/web-development/js/sort-an-associative-array-by-values-in-javascript.html

29 September 2015 An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's not an...

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

Zoho Templates - Font size is inexplicably tinyhttps://www.joellipman.com/articles/crm/zoho/zoho-templates-font-size-is-inexplicably-tiny.html

22 February 2019 Here are two screenshots to demonstrate the issue: Screenshot #1: This screenshot is of the PDF preview of my HTML code where I've had to set the font size to 46pt throughout the template: Screenshot #2: This screenshot is of the PDF preview of my HTML...

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

Zoho Deluge - Determine Quarter from Date with Fiscal Yearhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-determine-quarter-from-date-with-fiscal-year.html

31 January 2020 year starts from January, simply divide by 3... How? I'm showing this in Zoho Deluge but the logic can be adapted to other code. You will need this snippet of code for the examples below: l_Months = {1,2,3,4,5,6,7,8,9,10,11,12}; l_MonthNames =...

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

Zoho CRM/Creator - Common Errors & Gotchashttps://www.joellipman.com/articles/crm/zoho/zoho-crm-creator-common-errors-gotchas.html

06 February 2020 ZohoCRM.settings.ALL ZohoCRM.users.ALL or to be safe ZohoCRM.modules.ALL ZohoCRM.settings.READ ZohoCRM.users.READ Problem: Code 37: The HTTP method PUT is not allowed for the requested resource This was an issue where I was trying to push a Zoho Creator...

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

Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

28 April 2021 = "(field0:equals:" + v_UserID + ")"; l_SearchResults = zoho.crm.searchRecords("Vendors_X_Users",v_SearchCriteria); Code to Add a value to a multi-lookup (on Create Record): // sample code when creating a record in a module that contains a lookup...

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

Zoho CRM & Creator: Download attachment and upload to Creator file fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-creator-download-attachment-and-upload-to-creator-file-field.html

11 March 2022 Document (the file upload field) Downloaded (a picklist with the options "Downloaded" and "Pending Upload") Here's the code for the parent form to download the attachments and upload them to the Creator "Document" form: // // get attachments...

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

Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://www.joellipman.com/articles/crm/zoho/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

13 February 2023 A quick article on my adaptation of some code posted by Poorvik Palanikumar on the Zoho Community Forums to connect a ZohoCliq to the OpenAI API and ChatGPT... Note that I have another article for those who want to integrate ChatGPT with ZohoZIA. Why?...

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

ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://www.joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

05 December 2023 A quick article with the code to download image attachments from a Zoho Ticket and then to upload the attachment to Zoho Analytics. Why? First of all, we couldn't find how to sync attachments from ZohoDesk to ZohoAnalytics using the integration. Other...

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

ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

14 May 2024 A workflow notify by email didn't give the option to remind daily... only weekly or monthly. Spent a while trying not to use code but here we are. Code is our friend. How? So we'll run a workflow that triggers on the creation of a lead and runs a...

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

Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 the part of adding the various field placeholders onto the template document; every time. What if I told you we can code a single button on the record which does all of that for you; with only you needing to approve the document before it gets sent to...

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

Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Templatehttps://www.joellipman.com/articles/crm/zoho/zoho-books-estimates-quotes-accept-decline-buttons-on-template.html

04 November 2024 app for a webhook response, would result in the end customer suddenly downloading a JSON file. Looked a bit suspicious. The code below opens a new tab in their web-browser displaying a plain output message. How? So there are 2 caveats to this solution:...

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

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

18 August 2025 cd to the new project name To give permissions to write sudo chmod -R 777 . open the newly created widget.html file in your code editor add the code as per the below generic script when done, save 'widget.html' then return to terminal and type zet...

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

Zoho Deluge: Convert Map to URL Parametershttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-convert-map-to-url-parameters.html

09 March 2020 m_Payload.put("redirect_uri","https://www.joellipman.com"); m_Payload.put("response_type","code"); m_Payload.put("scope","my_api_scopes"); m_Payload.put("prompt","login"); Great! What follows is the code I'm using to convert this: v_Endpoint =...

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

Zoho Creator: isBlank and isNull: Before or After?https://www.joellipman.com/articles/crm/zoho/zoho-creator-isblank-and-isnull-before-or-after.html

10 February 2025 A really quick article to test when to use isNull and isBlank. Why? So I've noticed that looking at people's Zoho Deluge code, there will often be a check on a null before or after the variable: if(v_Test.isBlank()) {... } VS if(isBlank(v_Test)) {......

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

Write a Calendar in Autohotkeyhttps://www.joellipman.com/articles/automation/autohotkey/write-a-calendar-in-autohotkey.html

27 January 2010 this in a program using the qHTM.dll (to include HTML in an autohotkey GUI), the calendar will be in a HTML-autohotkey mixed code. Obviously just omit the HTML rubbish if you want to create a calendar using just autohotkey syntax. Actually, the...

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

SSRS Zero Paddinghttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-zero-padding.html

10 November 2011 as "-201". As I wanted a link so that the user can just click on this link and it would take them to http://ora-00201.ora-code.com/. The Padding Found this in a forum so thought I'd better make a note: Right("00000" & Fields!ERROR_CODE.Value.ToString,...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

SSIS Convert a string into a datehttps://www.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 status value 2 and status text "The value could not be converted because of a potential loss of data.". Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "Extract dates from string dates" (3614)" failed because error code...

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

AHK Countdown Tooltiphttps://www.joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 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 and have it calculate to the nearest second. I call this latest app...

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

AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html

18 July 2019 multiple desktops. How? The following example is assuming you have 3 monitors and 3 desktops. I'm going to cover the basic code to: 1) get all monitors, 2) open an app on a specified monitor, 3) switch to another desktop. Count Monitors and Check it can...

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