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 What? This is a quick article on what should be a simple mathematics equation: Determine the quarter from a given month. Why? Fine if you are determining the quarter by the month and your Fiscal year starts from January, simply divide by 3... How? I'm...

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

How to grow potatoes in potato planter bagshttps://www.joellipman.com/articles/_other-misc/how-to-grow-potatoes-in-potato-planter-bags.html

20 September 2009 I live in a flat but I'm lucky enough to have a balcony which gets some sun. Bought some potato patio planters and found this good video on youtube... {youtube}Q3zoVolI-Sw{/youtube}{youtube}Q3zoVolI-Sw{/youtube}{youtube}Q3zoVolI-Sw{/youtube}

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

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

06 February 2020 What? A quick article on how to debug some errors in Zoho. Why? I wanted a general note to list certain errors that we get when we do certain things in Zoho but didn't want to write a separate page for each minor issue. How? So I'm going to try and list...

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

Zoho Deluge: Associate/Link an Invoice to a Sales Orderhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-associate-link-an-invoice-to-a-sales-order.html

10 March 2020 What? This is an article because there was no documentation that I could find that describes how to do this. When an invoice is created, not by clicking on the "convert sales order to invoice" button, I needed a way to programmatically link the sales...

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

MySQL: Count occurrences of words in a columnhttps://www.joellipman.com/articles/database/mysql/mysql-count-occurrences-of-words-in-a-column.html

12 March 2020 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 of each word in your database column by order of most used...

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

Zoho Deluge: Push Multi-Select Picklist containing Commas from CRM to Creatorhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-push-multi-select-picklist-containing-commas-from-crm-to-creator.html

20 April 2020 What? A very quick article on how to push a multi-select picklist from CRM to Creator. Why? We're trying to create a record in Creator off a button on the CRM Potential/Deal record. The CRM module has a multi-select picklist which will use commas to...

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

Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date Stringhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-convert-xero-date-unix-timestamp-to-standard-date-string.html

04 May 2020 What? So this is a super quick note that I'll probably remember anyway but just in case, I'm writing this article so I don't spend time researching it later. Why? I'm synchronizing Xero Invoices with Zoho CRM Invoices and noticed that Xero stores its...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 in Zoho Creator and nor is List when submitted as a file attachment. sendmail [ from: zoho.adminuserid to: "info@joellipman.com" subject: "Testing an attachment" message: "This is a test" attachments: file: input.my_upload ]; // success! Send mail...

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

AutoHotkey: App GUI Listview to Rename Fileshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

08 July 2020 Applies to: Microsoft Windows 7 Professional - Service Pack 1 AutoHotkey v1.1.33.02 What? So this is the documentation for a snippet of code that will list files of a directory using an AutoHotkey GUI and display what it will name them. The app needs to...

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

Zoho Deluge: Get Image Uploaded in Creator Formhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-image-uploaded-in-creator-form.html

14 July 2020 What? So this is an article to document the methods I use to get an image uploaded in a form to display in a report or on another page. Why? There might be different articles out there and discussion forums that do cover this but it takes me so long to...

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

Windows 10: Shortcut Apps to Settingshttps://www.joellipman.com/articles/microsoft/windows-os/windows-10-shortcut-apps-to-settings.html

30 July 2020 Applies To: Microsoft Windows 10 Pro v10.0.18362 What? This is a list of apps that if run via the run command, or used in a desktop shortcut, or that you want to include in automation software such as AutoHotkey, opens any specific Windows OS settings...

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

AutoHotkey: Get Media Information and Displayhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-get-media-information-and-display.html

07 August 2020 Applies To: Microsoft Windows 7 Professional v6.1.7601 32-bit AutoHotkey v1.1.33.02 What? This is a copied article just to store a permanent reference for if I ever need to build an app similar to the file explorer in the Microsoft Windows OS. Why? I...

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

Zoho Deluge: Search Records with Special Characters (COQL)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

28 August 2020 What? This is an article to remind me how to search for CRM records by a value that may contain an ampersand or parenthesis. Why? I wrote this article because some searches will work for me and sometimes it won't. Escaping the ampersand with a backslash...

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

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

19 October 2020 What? A very quick article as I couldn't find anything on the WWW to document this error. Why? During a data migration, 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...

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

Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Divhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-page-toggle-on-off-switch-hide-display-a-div.html

22 October 2020 What? So this is an article documenting how to create an on/off toggle switch that hides and displays between 2 div layers in a Zoho Creator Page (so not a form or report but a page). Why? This is written at a time when Javascript or interactive pages...

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

Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 What? This is an article documenting how to create a Zoho Creator Widget which includes the Bootstrap and jQuery frameworks as well as other JavaScript functionality. Why? Quite simply that at time of print (2020-10-24), Zoho Creator does not allow you...

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

Zoho Creator: info/alert/modal/popup notification for any userhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

06 November 2020 What? So I thought I'd write a quick article to remind me and to develop a simple notification system that will popup for any user on the submit of a form, or on the click of a button or on the click of a link on a page. Why? Because alert (alert task)...

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

Zoho Creator: Set Up Custom Domain for Customer Portalhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-set-up-custom-domain-for-customer-portal.html

17 November 2020 for a Zoho Creator customer portal. In this example, we are going to use a subdomain of a company which has the domain joellipman.com. Why? This took me a bit of going backwards and forwards to Zoho rather than getting my client to do this. The aim is...

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

Zoho Creator: Button on Report for Merging Multiple Selected Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

06 December 2020 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 all the selected (ticked) records. The example below...

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

Zoho Deluge: Sort a Map by a specific fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-sort-a-map-by-a-specific-field.html

29 January 2021 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 a list of records by their date in descending order. Yes...

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