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 front of and after the smallest data value (one that I know will never be two lines (or two words)) within the SQL query itself. We have a DEPT column that is an acronym of the departments so for example: SELECT Date, Reservation, Contact, JobTitle,...

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

ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM recordhttps://joellipman.com/articles/crm/zoho/zohoflow-zohosign-retrieve-a-zoho-sign-document-request-and-add-attachments-to-crm-record.html

17 October 2022 admin or ascentcloud admin account) Log in to https://accounts.zoho.com/developerconsole Click on Add Client ID Select "Self Client" Provide the details and register your application Upon successful authentication, you will be provided with Client ID...

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

Mootools - How to contain a menu sidebar between header and footerhttps://joellipman.com/articles/web-development/mootools/mootools-how-to-contain-a-menu-sidebar-between-header-and-footer.html

10 August 2012 - menu_highest_top); if( window.XMLHttpRequest ) { if (document.documentElement.scrollTop > menu_highest_top || self.pageYOffset > menu_highest_top) { if (document.documentElement.scrollTop > match_lowest_y || self.pageYOffset > match_lowest_y) {...

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

Yesterday's time in PHPhttps://joellipman.com/articles/web-development/php/yesterdays-time-in-php.html

30 September 2010 tip or note to self: How to get yesterday's date irrespective of date format or daylight savings time. $today=date("Y-m-d"); $yesterday = date('Y-m-d', mktime(0, 0, 0, date("m") , date("d") - 1, date("Y")));

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

Joes Bug Tracker (JBT)https://joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 works in MS Internet Explorer; any database hacks or FTP file uploads immediately corrupt this component. The component itself is sort of good, but file description has very little space allocated on your website and RocketTheme templates would create a...

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

Getting the mysql where in delimited string to workhttps://joellipman.com/articles/database/mysql/getting-the-mysql-where-in-delimited-string-to-work.html

02 January 2012 0; -- total number of delimiters DECLARE ctr INT DEFAULT 0; -- counter for the loop DECLARE str_len INT; -- string length,self explanatory DECLARE out_str text DEFAULT ''; -- return string holder DECLARE temp_str text DEFAULT ''; -- temporary string...

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

Zoho Creator: Render to PDF with margins and page numbershttps://joellipman.com/articles/crm/zoho/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

07 May 2024 and conditions like every other business. Page of Copyright © My Company Ltd. All Rights Reserved. Additional Notes to Self: Some customers will want a column for VAT/Tax (Display amount and then percentage beneath in smaller) Line Item Totals have...

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

Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://joellipman.com/articles/crm/zoho/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

18 August 2025 } } }) .catch( function( r_Error ){ document.write(JSON.stringify(r_Error)); }); }); ZOHO.embeddedApp.init(); [Note to self] Retrieving the record itself (not needed for this task): ZOHO.embeddedApp.on("PageLoad", function(r_Data) { // get id and module...

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