Zoho Projects: Get All Eventshttp://mail.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: *

Zoho CRM: Remove Duplicate Product Recordshttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-remove-duplicate-product-records.html

07 March 2025 An article on removing duplicate products within ZohoCRM. Why? Product duplicates are a common issue during development, especially when we have products imported via a feed or API or simply by staff and their spreadsheets. There is a deduplication...

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

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

06 May 2025 A quick article with snippets of code to hide and show certain tabs on a deal record based on the pipeline. Why? A request from a customer asked if a tab specific to the pipeline selected can be shown while others hidden. Standard tabs such as Notes,...

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

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

09 October 2025 then I'll just put the client script I used to map over all the applicable field values from the quote to the invoice within ZohoCRM. Set up the Client Script Login to ZohoCRM > Setup (cog icon next to profile photo) > Developer Hub > Client Script >...

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

Restoring your WYSIWYG editor after upgrading Joomlahttp://mail.joellipman.com/articles/cms/joomla/restoring-your-wysiwyg-editor-after-upgrading-joomla.html

15 September 2009 its number of buttons and I couldn't add code snippets... The Fix Just installed JoomlaFCK WYSIWYG Editor, an editor I use with my day job's MediaWiki software and it's pretty amazing. Incredibly cross-browser compatible with some MS Office 2007 styling...

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

Splatter Logohttp://mail.joellipman.com/graphic-design/splatter-logo.html

30 September 2009 as floating, leave the selection on Create a new layer beneath Go to Selection > Modify > Expand > 10 px Fill this selection with another color (in the example below: dark grey) Add the brush with the same color to that layer...

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

Add default to a picture buttonhttp://mail.joellipman.com/articles/automation/autohotkey/add-default-to-a-picture-button.html

10 November 2009 you can apply a transparency and then capture special mouse events to emulate the mouseover and mouseout effects of a button with an image as a background. I couldn't get any of these working and they looked more confusing then anything else. My...

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

MediaWiki: MySQL to extract path to imageshttp://mail.joellipman.com/articles/cms/mediawiki/mediawiki-mysql-to-extract-path-to-images.html

06 December 2011 1, 2)) AS img_path, CONCAT(SUBSTR(MD5(img_name), 1, 1), '/', SUBSTR(MD5(img_name), 1, 2), '/', img_name) AS img_path_with_file from wikimedia_image -- where -- SUBSTRING(img_timestamp, 1, 8)>=20110922 ORDER BY img_timestamp DESC Note that I've commented...

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

MySQL day of week ending on Fridayhttp://mail.joellipman.com/articles/database/mysql/mysql-day-of-week-ending-on-friday.html

26 April 2012 below shows how to do this for when the week ends on Friday. Assuming it starts on the previous Saturday. Why? Problems with MySQL weeks always starting on Sunday means this isn't very useful. I have another system which starts on Monday and ends on the...

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

UNC Paths in Sharepoint 2007 linkshttp://mail.joellipman.com/articles/microsoft/sharepoint/unc-paths-in-sharepoint-2007-links.html

08 November 2012 to Microsoft Office Sharepoint 2007 What? I've been tasked with adding links to files located on some network shares. I want to use UNC paths such as \\myServer\myShare\myFile.doc. I could map the UNC path to a drive letter and then link to it (eg....

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

MySQL: Find all non-alphanumeric rowshttp://mail.joellipman.com/articles/database/mysql/mysql-find-all-non-alphanumeric-rows.html

09 September 2013 Quick note on how to do this. I was tasked with cleaning up an english database by replacing all special alphabets (ë to e) and non-alphanumeric symbols with URL friendly characters. How? -- return all records that contain non-alphanumeric characters...

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

A for loop within a for loop in MS-DOShttp://mail.joellipman.com/articles/automation/ms-dos/a-for-loop-within-a-for-loop-in-ms-dos.html

03 October 2013 my all-in-one GUI applications. How? Note: we're using the code in a DOS Batch program so our variables have to be prefixed with a double-percent rather than just the one: -- the following loops through directory for any file beginning with Reference...

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

SSRS Change Background Color of Imagehttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-change-background-color-of-image.html

08 April 2014 an image which has transparent areas, ie. has one color which will be transparent, the transparent pixels will be colored in with the page background color. Why? I want an image to display per row as a status marker for 3 different types of results:...

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

Make bootstrap carousel responsive to swipehttp://mail.joellipman.com/articles/web-development/bootstrap/make-bootstrap-carousel-responsive-to-swipe.html

14 December 2016 A quick reminder on how to make the carousel in bootstrap compatible with touch devices like smartphones and tablets. Why? Feed back was that the user was unimpressed with the image slideshow. You have to tap on the left and right symbols... How? Some...

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

Zoho Deluge - MD5 functionhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-md5-function.html

19 November 2018 defeat the objective of an Etag). How? Well I was going to document writing a Creator function but found a shortcut playing with the base64encode function: v_Etag = zoho.encryption.base64encode(v_Combined_Fields); // returns error Error on Execution...

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

Zoho Deluge - Regex to Strip all non-numeric charactershttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-regex-to-strip-all-non-numeric-characters.html

25 March 2019 we want the 30 from the above string How? I'm aware of the getAlphaNumeric() function in Zoho and I can remove the letters with removeAllAlpha(): v_PaymentTermsAlphaNum = v_PaymentTerms.getAlphaNumeric(); // yields CreditNote30Days vPaymentTermsNum =...

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

Copyrighthttp://mail.joellipman.com/static-items/copyright.html

30 May 2009 parties for their personal use, but only if you acknowledge the website as the source of the material You may not, except with our express written permission, distribute or commercially exploit the content. Nor may you transmit it or store it in any...

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

Add the website name to the page title in Joomla!http://mail.joellipman.com/articles/cms/joomla/add-the-website-name-to-the-page-title.html

06 September 2009 that I've noted down below. Specific Joomla Template Providers Everytime I update this article, Joomla seems to come out with a new version. If you have installed Joomla 2.5, this is now a setting in the global configuration... The only problem is that...

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

Applying a button and centering it in the RocketTheme Affinity templatehttp://mail.joellipman.com/articles/cms/joomla/applying-a-button-and-centering-it-in-the-rockettheme-affinity-template.html

15 September 2009 a lot more to do than just that. Instructions Open the templates/rt_affinity_j15/index.php Look at the last few lines with the original code (below) For this website template: I've added the module-dark classes. Specified float:none to get rid of...

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

Counting the occurence of a word within a string: Benchmarkhttp://mail.joellipman.com/articles/web-development/php/counting-the-occurence-of-a-word-within-a-string-benchmark.html

06 September 2009 Storyteller" went and carried out a benchmark test on the most popular ways of counting the occurrence of a specific word within a string of text. Source: http://hasin.wordpress.com/2007/04/30/c … functions And the result is First Run Count by...

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