Zoho CRM & Zoho Inventory: Upload Image to Item Record using Delugehttp://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-inventory-upload-image-to-item-record.html

21 June 2022 A quick article on how to upload an image to the product/item listing in Zoho Inventory. Why? We're enhancing the out-of-the-box integration from eBay to Zoho Inventory bespoke for a customer. We want the photo on eBay to be downloaded and uploaded to...

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

Zoho Inventory: Mark a package slip as delivered and shippedhttp://www.joellipman.com/articles/crm/zoho/zoho-inventory-mark-a-package-slip-as-delivered-and-shipped.html

14 July 2022 A quick article on a code snippet to mark a package as shipped and delivered in Zoho Inventory. Why? As usual, any task like this that takes me longer than an hour, I'd like to document for future use. The use-case is the client has their own delivery...

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

Joel's Reference to MidJourney v4 Promptshttp://www.joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 generator) which the bot can break down into "tokens" and then match with its training data to generate the image. Quick recap on how to first start using the MidJourney Bot Signup to Discord.com Visit Midjourney.com Go to the Midjourney's discord...

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

ZohoAnalytics: Pivot Campaigns vs Contactshttp://www.joellipman.com/articles/crm/zoho/zohoanalytics-pivot-campaigns-vs-contacts.html

20 March 2023 A very quick article of a quick solution but at least a working example of an ANSI-SQL (ZohoSQL) query pivoting campaign results vs contacts. Why? Simply the client wanted a report on customers on each row and then the campaigns as columns. What we...

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

Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSONhttp://www.joellipman.com/articles/crm/zoho/zoho-creator-error-code-2945-extra_key_found_in_json.html

04 October 2023 A quick article on how I resolved this error and how the online forums and documentation did not. Why? I don't often do this to create a Creator record but I'm going to use the shortcode function zoho.creator.createRecord() and wanted to update the...

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

Zoho Deluge: Determine your Statement Execution Limithttp://www.joellipman.com/articles/crm/zoho/zoho-deluge-determine-your-statement-execution-limit.html

31 July 2024 A very quick article on how to check what the statement execution limit is on the Zoho application you are working in. Why? Our use-case is that an application we built in Zoho Creator was hitting statement execution limits and rather than proposing an...

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

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

03 March 2025 A quick article on how to use remove() on a map variable as well as a snippet of code to copy tags from a contact to a deal record. Why? Anything that stumps me for 30 minutes is worth writing a quick article on. In this case, I had a function querying...

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

Select unique values in Microsoft Excel columnhttp://www.joellipman.com/articles/microsoft/excel/select-distinct-values-in-microsoft-excel-column.html

03 July 2012 I'd put a quick note here, I tried a fair few solutions that didn't work and then found this hidden away in a forum: Quick Count =INT(SUMPRODUCT((A3:A1000"")/COUNTIF(A3:A1000,A3:A1000&""))) This returns the number of unique values in the range A3 to...

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

SQL: Use CASE for Relevance columnhttp://www.joellipman.com/articles/database/mysql/sql-use-case-for-relevance-column.html

03 August 2013 So this is a quick note to myself as I was playing with the relevance heuristics of a query. This example adds a column of relevance and sorts the rows accordingly. How? This has to be a real quick one for a dropdown search field which has to find...

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

Zoho Finance Suite Schedule: PATTERN NOT MATCHEDhttp://www.joellipman.com/articles/crm/zoho/zoho-finance-suite-schedule-pattern-not-matched.html

12 June 2023 A super quick article on resolving this issue if it ever appears again. Why? At time of print, this error was happening to schedules in Zoho Books, Zoho Inventory, and Zoho Subscriptions. Unless you can monitor when these type of schedules are failing,...

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

ZohoCRM GetRelatedRecords INVALID_DATAhttp://www.joellipman.com/articles/crm/zoho/zohocrm-getrelatedrecords-invalid_data.html

30 January 2025 What? A ridiculously quick article on resolving a zoho.crm.getRelatedRecords() combined with a zoho.crm.bulkUpdate issue. Why? Trying to be clever and reducing the API calls to go through a few thousand records and to update the related records. I was...

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

Zoho CRM: Updating a CRM record Custom Line Items using API v7http://www.joellipman.com/articles/crm/zoho/zoho-crm-updating-a-crm-record-using-api-v7.html

18 December 2024 What? This is a quick bit of code for my reference so that I don't have to keep finding a function that gives me the syntax of how to either create or update a record using invokeUrl. Why? Because my designers keep including custom fields in their...

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

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

04 February 2025 What? A really quick article on demonstrating a nested try...catch()... statement working in Zoho CRM. Why? To prove a point to ChatGPT who said this was not possible... and to deal with a scenario which exists for a client of mine. The use-case for my...

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

Zoho Creator: isBlank and isNull: Before or After?http://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: *

Sun-Dried Tomato Basil Couscous Recipehttp://www.joellipman.com/articles/_other-misc/sun-dried-tomato-basil-couscous-recipe.html

03 September 2009 I've recently been making couscous a lot and this is the simplest recipe I use on the net. Simple and quick couscous is flavored with sun-dried tomatoes, green onions, and basil. This dish may be served hot or at room temperature. Use store-bought...

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

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

28 January 2010 server (time.windows.com) when connected to the Internet and for some reason it doesn't display the right date/time. The Quick Fix First off, check there aren't any Update for Windows 7 releases at Microsoft's Windows Update The Long Fix Now below are...

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

Anti-Spam override for all submitted datahttp://www.joellipman.com/articles/cms/joomla/anti-spam-override-for-all-submitted-data.html

03 February 2010 = 'component'; include('index.php'); There is some more text but it's in /* lines */ which means these are comments. The quick solution is: $_REQUEST['tmpl'] = 'component'; $offensive_words=array("viagra","cialis","[url=","porn","pfizer"); if...

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

Lazy stats: Yootheme / Gavick Pro / Rocket Theme Comparisonhttp://www.joellipman.com/articles/cms/joomla/lazy-stats-yootheme-and-gavick-pro.html

08 April 2010 you put in". i.e. it's a showroom and you've got to complement the template with your own visuals. Had no trouble with their quickstart installations (site and template and tools) Gavick Pro Gavick.com itself is a nice site with everything working as it...

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

K2 Items disappearhttp://www.joellipman.com/articles/cms/joomla/k2-items-disappear.html

27 August 2010 table and it returned the following error: #145 - Table './jos_k2_items' is marked as crashed and should be repaired The Quick Fix I managed to fix this with this SQL command . Note: you need to be able to run SQL commands against your database. My...

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

UTF8 Unicode PHP MySQL for International Charactershttp://www.joellipman.com/articles/web-development/php/utf8-unicode-php-mysql-for-international-characters.html

22 October 2010 have an effect on the module (such as take away accents and convert to ASCII), they weren't what we were looking for. The quick solution was to make the script run a MySQL command at the start: SET NAMES 'utf8' Now I need to run this command from within...

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