Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

19 September 2021 = "Title: " + input.Title; Method #1: (do not use) Previously I have tried adding a field called "DateTime form was loaded" which would have the currenttime when the form was loaded. Then I would tell Audit_Change to only trigger the workflow if it had...

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

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

28 June 2011 had a limit to its "FREE" services. There are websites that do this for me? Yay! for free as well, as long as my page isn't loaded more than 100,000 times a month. I don't understand, one website visitor can generate 1000 hits, so thereafter I have to...

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

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

22 October 2010 anyway. Cause: Q. Why does this work for Joomla! articles and not for this module? A. Think this is because that module is loaded before... not sure but for some reason the above command set names 'utf8' is obviously not run prior to the module being...

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

SQL Queries for Statisticshttp://mail.joellipman.com/articles/database/mysql/sql-queries-for-statistics.html

13 December 2010 is a MediaWiki CMS which is used for the official Bournemouth University Knowledge Base. The skin itself is the index page loaded for any page in the Wiki system. It logs the IP address (VisitorIP), the URL (VisitorURL) entered via the browser useragent...

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

Background Gradient Disappears on Long Pageshttp://mail.joellipman.com/articles/web-development/css/background-disappears-on-long-pages.html

20 November 2012 a long page, it would initially display properly but then the white background would disappear when the page finally loaded. How? The root cause was because the template I was using was not actually specifying "white" as the contents background-color...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Hide a Drive per User in Windows 7http://mail.joellipman.com/articles/microsoft/windows-os/hide-a-drive-per-user-in-windows-7.html

28 March 2014 to the list above) CRITICAL STEP: Once you've saved this value, navigate back up to HKEY_USERS, select the Foo key you loaded, and then click File > Unload Hive > Yes (prompt). Close the registry editor, then restart the computer. Notes: Guest account...

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

Google Authentication - OAuth 2.0 using PHP/cURLhttp://mail.joellipman.com/articles/google/google-authentication-oauth-2-0-using-php-curl.html

31 October 2018 lists the functions necessary to process Google Authentication using OAuth2.0. These functions allow a script to simply be loaded and to either create a token file, or use the existing one as long as it hasn't expired. Update 2019 This script requires a...

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

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

14 October 2024 + ""; input.Note_ColorPicker_Css = v_CssStyle_Popup; } If a record is stored with its Hexadecimal value, when the record is loaded up (existing record), it will have the color already displayed in the button: Source(s): Joel Lipman - Zoho Creator: Radio...

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

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

29 May 2025 a dropdown menu of a JavaScript widget. When the user first loads up the webpage containing the widget, 10k images are downloaded. I have put in a lazy loading process where it will load the first few images and as the user scrolls down the dropdown,...

• 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 description. I said "Sets the subject/name of the invoice to TBC when first created. Maps values from the related quote if loaded from somewhere other than converting quote to invoice.". Note that I have a workflow that when saved, uses an auto-number...

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

SSRS No Delay for First Report of the Dayhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-no-delay-for-first-report-of-the-day.html

11 April 2014 day, it would take an additional 60 seconds to get with it and display the report. Any subsequent running of the report loaded it almost immediately. How? There are a few options out there but this one made a noticeable difference. Applicable to the...

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