Zoho CRM Client Script: Map Quote to Invoicehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-client-script-map-quote-to-invoice.html

09 October 2025 This is an article to apply an automation that when creating an invoice in CRM from a related quote, it maps in the fields. Why? The process should be that you go to the CRM quote record and click on "Convert" > then select "Invoice", and it should map...

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

Zoho Books: Error 7008: There are no contact persons associated with this Invoicehttps://www.joellipman.com/articles/crm/zoho/zohobooks-error-7008-there-are-no-contact-persons-associated-with-this-invoice.html

07 March 2024 A quick article on how to get around this error. Why? The use-case here is that I am using the send invoice API and I kept getting this error despite including the customer_id and there was a primary contact on the customer record. This is from within...

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

Privacy Policyhttps://www.joellipman.com/static-items/privacy-policy.html

30 May 2009 This privacy policy sets out how Joel Lipman .Com uses and protects any information that you give Joel Lipman .Com when you use this website. Joel Lipman .Com is committed to ensuring that your privacy is protected. Should we ask you to provide certain...

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

AwStats Data Parser (ADP)https://www.joellipman.com/component/content/article/awstats-data-parser-adp.html?catid=40

03 April 2013 has excited them to no end but because the end of the month didn't wait for me to finish the project, I quickly created this program to extract all the data values from an AwStats report. Advanced Web Statistics or AwStats, is a reporting system for...

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

Zoho Creator: Radio group into Calendar Carouselhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-radio-group-into-calendar-carousel.html

09 March 2022 In that a radio group displays the days of the week with arrows allowing the user to select the next or previous week. This is a follow on from my other articles on restyling Creator: Zoho Creator: Change Radio into Tabs and Zoho Creator: Decision Box...

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

Php convert filesizes to bytes kb mb gbhttps://www.joellipman.com/articles/web-development/php/php-convert-filesizes-to-bytes-kb-mb-gb.html

03 January 2013 } else { $bytes = '0 bytes'; } return $bytes; } Inline without a function Source: Joes Brain: http://www.joellipman.com if ($this_file_size >= 1073741824) $this_file_size = number_format($this_file_size / 1073741824, 1) . ' GB'; elseif ($this_file_size...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Terms & Conditionshttps://www.joellipman.com/static-items/terms-conditions.html

30 May 2009 REGISTRATION Joel Lipman .Com reserves the right to change the username you choose upon registration. This is to help other registered users to distinguish between official Joel Lipman .Com website administrators and other registered members. WEBSITE...

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

Zoho Creator: Receive JSON via a Shopify Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-json-via-a-shopify-webhook.html

15 July 2021 This is an article to document how to receive a JSON response from a webhook created in Shopify. See my article: Zoho Deluge: Push Item to Shopify API if you want information on setting up an integration from Zoho Creator to Shopify API. Why? In this...

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

Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://www.joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

25 September 2025 some Zoho ANSI-SQL (in other words, queries that work in Zoho Analytics) as I couldn't find any examples online on how to do this. Why? I've been tasked with generating a radar/spider/web chart based on the results from a survey. Apparently this will be...

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

Joes Bug Tracker (JBT)https://www.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 I'm revisiting this component for the third time (previously known as "downloadtracker" and "joesdownloadtracker"); for ages I have needed a replacement for the download component managers for Joomla! CMS. I've tried all the following for about a year...

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

T-SQL Record Separatorhttps://www.joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 /* Day ---------------- Monday Monday Monday Tuesday Tuesday Wednesday Thursday Thursday Thursday Thursday Friday Friday */ This is actually part of a SQL query (Transact-SQL) used in an Excel file. Some of our end customers are not even computer...

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

Prefix Line Numbers in a Text Filehttps://www.joellipman.com/articles/automation/ms-dos/prefix-line-numbers-to-a-text-file.html

18 July 2012 lines with their respective line number in a text file using a Microsoft Windows Operating System... I've just googled this as I couldn't remember how I did this last time and a number of people showing off their MS-DOS batch skills have proposed stupid...

• Type: Article
• Author: Joel Lipman
• Category: MS-DOS
• Language: *

Android: Keytool and Google Maps displaying greyhttps://www.joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

31 October 2014 The article below serves as a checklist to ensure I don't release an app that only displays maps to myself (again). Why? This took me a while to figure out so hopefully this will help others. How? The gist is that I was using the Test SHA1 when adding...

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

Zoho Deluge - Get Refresh/Access Token API v2https://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

17 July 2019 and access tokens using Zoho Deluge code (so within Zoho Creator, CRM or Books) without XML calls. Why? I find myself using this more and more now that API v1 is on the way out and Zoho Deluge by itself is limited somewhat with regards to functionality...

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

PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://www.joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

12 March 2022 This is a quick article on how I built my 2022 workstation and got 5 monitors working with only 1 graphics card. Why? This took me a good few hours to get working so I thought this article could help others. It's also a chance to show off my build....

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

This file contains HTML or script code that may be erroneously interpreted by a web browserhttps://www.joellipman.com/articles/web-development/html/this-file-contains-html-or-script-code-that-may-be-erroneously-interpreted-by-a-web-browser.html

08 October 2009 The Error: This file contains HTML or script code that may be erroneously interpreted by a web browser This is a common error when uploading files that the MediaWiki system does not allow. By making some minor changes to the MediaWiki LocalSettings.php...

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

Creating a Top 10 chart with less codehttps://www.joellipman.com/articles/web-development/php/creating-a-top-10-chart-with-less-code.html

18 February 2010 I've decided to put something in here as it took me an age to find out how I could do it. This is when using a MySQL query within a PHP script. The process is used often to do a statistics table or top ten chart of your data (eg. movies, music, etc)....

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 Business Intelligence Development Studio (BIDS). Weekdays along the top and then dates inside. Additionally we would like this linked to events in a database. I'm calling this project "Reinventing the Wheel" because the request was a report that was...

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

MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 the title doesn't put you off but after much Googling and Bing-ing, I still couldn't figure out how to do this. Hopefully this article will help you more than my search engine skills do. My Setup Windows XP Workstation...needs to open... Excel 2007 SP2...

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

Joes Search Module (JSM)https://www.joellipman.com/component/content/article/joes-search-module-jsm.html?catid=40

09 March 2015 This article serves as documentation for a Joomla extension I have released which is a copy of the built-in Joomla Search module but with the parameters embedded (set in the administration section). Why? A client has a repository of PDF documents that...

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