ZohoCRM: ZDK Client Script to retrieve Contact Emailhttps://joellipman.com/articles/crm/zoho/zohocrm-zdk-client-script-to-retrieve-contact-email.html

20 July 2022 ZDK.UI.freeze(false); // return false to prevent saving of record return false; Caveat(s) This only happens if the record is being edited (as in user clicked on "Edit") rather than the inline edits that can be done (eg. user clicked on field in view...

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

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

14 February 2019 by gathering and remembering information about your preferences. We use traffic log cookies to identify which pages are being used. This helps us analyze data about webpage traffic and improve our website in order to tailor it to customer needs. We only...

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

Disclaimerhttps://joellipman.com/static-items/disclaimer.html

30 May 2009 up and running smoothly. However, Joel Lipman .Com takes no responsibility for, and will not be liable for, the website being temporarily unavailable due to technical issues beyond our control.

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

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

30 May 2009 by gathering and remembering information about your preferences. We use traffic log cookies to identify which pages are being used. This helps us analyse data about webpage traffic and improve our website in order to tailor it to customer needs. We only...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• 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 (personally it was because Microsoft released an optional windows update that fixed my issue. check that this issue isn't being caused by any Windows 7 desktop gadgets. Quit/close all desktop gadgets except the CPU monitor and your analogue clock. Make...

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

Remove write-protect from USB pen in Windowshttps://joellipman.com/articles/microsoft/windows-os/remove-write-protect-from-pen-in-windows.html

13 April 2010 32Gb USB Pretec Pen (as advertised by Gadget Show on Five.tv). Turns out this is an incredibly fragile pen. If files are being written to it and it gets nudged, this will corrupt the pen. BTW I don't use the "remove device safely" rubbish as my old pen...

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

Webdeveloper-Speakhttps://joellipman.com/articles/web-development/webdeveloper-speak.html

13 July 2010 The part of a webpage that is visible in the web browser window when the page first loads is described as being ‘above-the-fold’. "belt-and-suspenders" Just like the UK's idiom "belt-and-braces", ‘Belt-and-suspenders’ describes an approach to web design...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

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

22 October 2010 is loaded before... not sure but for some reason the above command set names 'utf8' is obviously not run prior to the module being displayed.

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

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

14 January 2011 on the "[Order]" cell and select "Add Group" then click on "Parent Group..." as shown. Week grouping expression: you're being asked to Group by, so we click on the "fx" button to enter the below expression: Delete Order Column: Ok the expression and...

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

Migrate Joomla! 1.5.x to 2.5.x+https://joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 or 3.0.x. 2012-07-25: Fixed bug in older versions of MySQL reserved word "name". 2012-07-24: Fixed bug of new admin not being allowed into admin panel. 2012-03-25: Changed instructions regarding changing table prefixes. 2012-03-21: Added "Update 2012"...

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

Alternate row background colour in Reporting Serviceshttps://joellipman.com/articles/microsoft/ssrs/alternate-row-background-colour-in-reporting-services.html

04 February 2011 be white (=#ffffff) in row 1 (odd row numbers) and a very light grey (=#eeeeee) in row 2 (even row numbers). The first row being of all rows in the dataset and not for a particular drill-down item. It will alternate between the two for the rest of the...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

Creating a Profile Plugin for Joomla 1.6https://joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

27 April 2011 each of these folders in case "directory listing" gets enabled on your server.I'm going to refer to the files to create as being in this folder. ./profile5/profile5.php User - Profile - JoelLipman.Com Joel Lipman April 2011 (C) 2011 JoelLipman.Com. All...

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

Could not instantiate mail functionhttps://joellipman.com/articles/cms/joomla/could-not-instantiate-mail-function.html

09 May 2011 some useful guidelines for these kind of issues: How to setup the Mail System 1) hostname must not match any domain that is being used on the system. Example, if you have a domain called domain.com and you want to recieve mail on user@domain.com, you...

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

Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 empty that folder after a batch process but no, the program doesn't care. Question How can this be 100% FREE? Answer: I'm being asked why not charge for this. First of all it's incredibly difficult to charge for a program that integrates other people's...

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

Basic Webpage Controls with JavaScript / COMhttps://joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 Attribute You can also use the objects name or ID. For example, the 1st forms name is SearchForm, with its 1st elements name being search_keywords. The following javascript fed throught the address bar would produce the same results: Code: javascript:...

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

SSRS Parameters in Oracle Stored Procedurehttps://joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 Not proceeding with this as there may be a better way. In addition, SSRS was complaining about assignment targets not being valid (despite knowing what they are). Searches that got me nowhere Well not entirely true, there were solutions and tidbits but...

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

Joes Network Transmission Detector (JTD)https://joellipman.com/component/content/article/joes-network-transmission-detector-jtd.html?catid=40

29 September 2011 network traffic, this program adds NOTHING to the network traffic, and therefore is a much better measure of what data is being received/sent from your workstation. Download Available for download for FREE as OpenSource. Portable so no...

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

Stop Excel Row Height Self-Adjust on Refreshhttps://joellipman.com/articles/microsoft/excel/stop-excel-row-height-self-adjust-on-refresh.html

30 September 2011 for again but get me nothing stop row height change on refresh data excel 2007 excel row height refresh data row height being reset on refresh excel disable readjusting row height on data refresh

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

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

11 October 2011 today and the next 6 days. Note how I can't use normal dates because the database wasn't designed with timestamps (despite being a timetabling and room booking system). But I do get given a weekday and the start date of the week... WITH tblDifference AS...

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

MySQL last year week month day trend periodshttps://joellipman.com/articles/database/mysql/mysql-last-year-week-month-day-trend.html

31 October 2011 and counts activated accounts for the past day, week, month and year (the below examples count all accounts irrespective of being activated or not). It needs to pick up trends as well and compare for example todays, with yesterdays up to the same hour....

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