Zoho Books: Error 7008: There are no contact persons associated with this Invoicehttps://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: *

ZohoCreator: Basic Widget with Zoho Datahttps://joellipman.com/articles/crm/zoho/zohocreator-basic-widget-with-zoho-data.html

14 March 2024 version of a JS widget used for a customer and before I added all the layers of complexity, I want to have here an example that demonstrates a basic search on a table of data and returns one record as a result. The use-case here is that we are enhancing...

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

Zoho Projects: Get All Eventshttps://joellipman.com/articles/crm/zoho/zoho-projects-get-all-events.html

22 July 2024 A quick article because I couldn't find anything that documented this with a working example. Why? The use-case here is that we want to make a ZohoCreator page display events for this month from ZohoProjects. How? The bit that stumped me was making a...

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

ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoicehttps://joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-api-half-a-cent-or-penny-off-when-creating-an-invoice.html

20 March 2025 A frustrated article about an issue that took me a fair few hours to resolve. So I'm putting it here as I thought I covered this previously but couldn't find it on my website. This was previously titled something along the lines of truncating to 2...

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

PHP Script: Make your own Thumbnail Generator via APIhttps://joellipman.com/articles/crm/zoho/php-script-make-your-own-thumbnail-generator-via-api.html

29 May 2025 Looking for an online tool that will take an image and make a thumbnail copy? This article is for me if I ever want to recreate an online tool capable of receiving an image URL and which both generates and outputs a thumbnail image and makes it...

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

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

04 September 2015 dubbed EventViewer Chart Generator. As the name suggests, I was looking for a free program that can take an exported CSV list from a standard MS Windows eventlog or eventviewer log and generate a chart from the data. What my program does is convert all...

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

Zoho Deluge: Nested Catch Statementshttps://joellipman.com/articles/crm/zoho/zoho-deluge-nested-catch-statements.html

04 February 2025 who said this was not possible... and to deal with a scenario which exists for a client of mine. The use-case for my Cx is that they need documents converted from HTML to PDF — as in we send it a bit of code in HTML and we want a PDF file returned. I...

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

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

30 May 2009 or suitability of the information and materials found or offered on this website for any particular purpose. You acknowledge that such information and materials may contain inaccuracies or errors and we expressly exclude liability for any such...

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

Using a HTML form and PHP to upload a filehttps://joellipman.com/articles/web-development/php/using-a-html-form-and-php-to-upload-a-file.html

17 September 2009 this. This example applies to a Linux Apache MySQL PHP (LAMP) environment. The Solution 1. The first thing to do is check that your HTML form is setup to do this:...... The form above will post to itself but more importantly is the...

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

Using MetaMod to hide buttons from logged in usershttps://joellipman.com/articles/cms/joomla/using-metamod-to-hide-buttons-from-logged-in-users.html

22 September 2009 It's been difficult to find an easy solution to hide menu items from registered users. Finally, I found a solution that works 100% for me using the MetaMod tool without using any template hacks. The instructions on the metamod page are very vague so I...

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

Mediawiki Extension for Camtasia Studio SWF videoshttps://joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

08 October 2009 Camtasia Studio SWF files in it's articles. Why Camtasia when there are other free options? We tried lots of FLV players that were usually branded or not free. These were awkward to configure a full screen button on the controls and do basic...

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

Windows 7: System Clock is constantly going out of synchttps://joellipman.com/articles/microsoft/windows-os/windows-7-system-clock-is-constantly-going-out-of-sync.html

28 January 2010 The Issue People have reported that although they have manually set the date/time on their computer, this gets changed by the windows time server (time.windows.com) when connected to the Internet and for some reason it doesn't display the right...

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

Windows 7 Aero Featureshttps://joellipman.com/articles/microsoft/windows-os/windows-7-aero-features.html

27 April 2010 Thought I'd put something here as a lot of my clients and friends are all surprised by the Aero features and weren't aware that these existed in Windows Vista (and originally from Linux variants). Sometimes you may only have partial Aero effects. This...

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

RokDownloads Manager does not list fileshttps://joellipman.com/articles/cms/joomla/rokdownloads-manager-does-not-list-files.html

28 October 2010 this isn't a problem for those that don't use RokDownloads. The other day, I logged in to upload some new files and manage some of my downloadable files... Only to find that the Rokdownloads manager would not list any of my files!?! I am in the middle...

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

SSRS Hide results table if emptyhttps://joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 but boy what a mouthful, and it's not really iterating anymore. So it's "SSRS Hide results table if empty" though I will add that if you wanted to put a message instead of hiding the table then following the below will also let you do this...

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

SSRS Redirect after a report is runhttps://joellipman.com/articles/microsoft/ssrs/ssrs-redirect-after-a-report-is-run.html

12 August 2011 reference or name and if there is only 1 result in the results page, then we want it to redirect to the details report for that student automatically. How? So there are various solutions out there, here's an overview of some: Method #1 Create one report...

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

How to Display Report Execution Time in SSRS (milliseconds)https://joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

17 November 2011 solution as well so who copied off who is not my concern as this is not the solution to our problem. This is the solution that I initially used but my end-users were asking why is it always 0 seconds. This was because we were using the following MDX...

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

Performance Report - Background colors based on dataset valueshttps://joellipman.com/articles/microsoft/ssrs/green-red-background-colors-based-on-dataset-values.html

02 December 2011 SELECT Name, ItemID FROM Catalog WHERE Type = 2 ORDER BY Name If you want to use these datasets, parameter options should be that the Name is the "Label" and ItemID is the "Value", just in case you didn't pick up on this. If no type is specified...

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

Inline Labels in Form Fields using Javascripthttps://joellipman.com/articles/web-development/js/inline-labels-in-form-fields-using-javascript.html

21 August 2012 This is to describe how to change the value of a field of a form from it's default when it is clicked on so that it auto-clears and changes to how it normally works. Example? Note the value in the below field. Now click on it and it disappears, allowing...

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

Search a database with SOUNDEXhttps://joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 Data Consistency. I was tasked with finding variations of our default values. End-users were complaining that some default values get listed twice because their system was case-sensitive despite the collation of the SQL Server being case-insensitive....

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