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 email addresses as the recipients: A sample code snippet: For the below, I have a connection to ZohoBooks from ZohoCreator called "zbooks". It has fullaccess as a scope but I'm sure you can lock it down to just the scopes you need. void...

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

Zoho Creator: Input Color Pickerhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-input-color-picker.html

14 October 2024 mine "Color Picker" Add a note field, I've given it the field link name "Note_ColorPicker_Css" Add a radio field type, I've called it "Color Picker" Add a single line text field, I'm calling it "Hexadecimal" [Key field that will be used by the...

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

Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-using-remove-key-on-a-map.html

03 March 2025 thought I was adding the map with the ID removed back into a list. The map itself was null. How? We are using an API action called "Add_Tags". I'm going to get the tags of the contact record using an invokeurl because shortcode only gives me name and...

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

ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttps://www.joellipman.com/articles/crm/zoho/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

01 April 2025 type if (v_InvoiceType == "Final Balance") { v_DepositAmount = -Math.abs(v_DepositAmount); } // insert a product line item called "Deposit" var o_NewLineItem = {}; // the record ID of the product "Deposit" is inserted into Product_Name...

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

ZohoCRM / Client Script / Canvas: Hide Tab based on Pipelinehttps://www.joellipman.com/articles/crm/zoho/zohocrm-client-script-canvas-hide-tab-based-on-pipeline.html

06 May 2025 ID. Finally, we'll have client script execute this function, then show/hide tabs based on the value. Assuming I have a tab called "Sales Pipeline", and "Hire Pipeline": Go to the deal record and scroll to bottom where you can see an "Edit" button for...

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

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

29 May 2025 thumbnailer.php into a web-accessible directory on your server (for example, public_html/api/thumbnailer.php). It will be called as a JSON API over GET and does not render a webpage. Create Storage Folders In the same directory, create two writable...

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

After installing rokstories, get invalid argument 106https://www.joellipman.com/articles/cms/joomla/after-installing-rokstories-get-invalid-argument-106.html

14 January 2010 I did this just to follow along with the solution. You need to make a menuitem to just one of the articles. I have a menu called "unused menuitems" (named unusedmenu), which isn't displayed anywhere on my site. I'm guessing the reference in the database...

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

MyALN.bournemouth.ac.ukhttps://www.joellipman.com/component/content/article/myalnbournemouthacuk.html?catid=33

07 September 2010 MyALN is a web-project where the original developer ended their support for the site. I was called in to fix several underlying issues and integrate it into the university systems. The Additional Learning Needs team at Bournemouth University use their...

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

Frontpage Item Orderinghttps://www.joellipman.com/articles/cms/joomla/frontpage-item-ordering.html

16 September 2010 the menu manager > main menu > menu item section of your Joomla! Admin Panel. Certain Advanced Parameters in your Menu Item called "Home" must be set correctly for the article ordering you set in your Front Page Manager to take effect. To set them, do...

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

The Sandpithttps://www.joellipman.com/graphic-design/the-sandpit.html

26 September 2010 I saw this on BBC News Click and was really impressed. It's an effect called "time-lapse tilt shift photography" where everything is made to look smaller than it actually is. As an update Mar 2011, I just watched Gulliver's Travels (2010) and it looks...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

Regular Expressions in SQLhttps://www.joellipman.com/articles/database/regular-expressions-in-sql.html

09 January 2014 use regular expressions within SQL statements: How? For the following examples, I am pretending to select rows from a table called `STUDENTS`. Oracle PL/SQL Looking for abnormal data, note the circumflex to exclude the clean alphanumeric rows: SELECT *...

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

VBScript to retrieve Windows Product Keyhttps://www.joellipman.com/articles/microsoft/windows-os/vbscript-to-retrieve-windows-product-key.html

23 September 2015 one). How? I'm going to use my trusty notepad program, copy the following code to it, and run it: Create a notepad file called read_product_id.vbs Copy the following code to the file: Set wshShell = CreateObject("Wscript.Shell") MsgBox...

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

JComments errors in PHP 7: plgContentJComments and JCommentsACLhttps://www.joellipman.com/articles/cms/joomla/jcomments-errors-in-php-7.html

13 March 2020 During a site upgrade, the commenting extension for Joomla called JComments would return errors when using PHP version 7. This is a quick article to document what needed doing to fix the errors. How? First some errors: ERROR: plgContentJComments...

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

Joomla: Remove IDs from URLs for out-of-the-box SEFhttps://www.joellipman.com/articles/cms/joomla/joomla-remove-ids-from-urls.html

14 March 2020 languages) Select the "Integration" tab Change the “URL Routing” option from Legacy to Modern A further option will appear called "Remove IDs from URLs, set to "Yes" Click on "Save" and you are done.

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