Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 button. Let's use the example of a credit application you want to send to your customer, and when they complete it, the PDF version gets attached to their contact record... all from one click of a button: Scenario 1: Credit Application: Template exists...

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

ZohoDeluge: eBay marketplace account deletion/closure notificationshttps://joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

13 March 2025 Content-Type header must be set to application/json. The following instructions are on the eBay page but this is the TLDR version: Sign into your developer account: https://developer.ebay.com/signin. Navigate to the Application Keys page:...

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

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

29 May 2025 your own? How? So you will need a webserver of your own running PHP 8. The following PHP script was only tested using PHP version 8.x so I can't say whether it will work for previous versions. I cannot take credit for this script, as I asked OpenAI's...

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

ZCRM Client Script: Correct Decimal Fields OnLoadhttps://joellipman.com/articles/crm/zoho/zcrm-client-script-correct-decimal-fields-onload.html

13 December 2023 of decimals. I didn't need to use this method for my client; just rounding the decimals would suffice but here is my first version of the script: /* ******************************************************************************* Function: - Label:...

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

Installing phpBB3 for Joomla with a RocketTheme templatehttps://joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 up. Go to the phpBB website (www.phpbb.com) and download their latest stable release. At the time of this article, this was version 3.0.5, but RocketTheme are fully aware of this and seem to be committed to keeping their templates compatible with phpBB....

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

Uninstalling AEC Central and installing Community Builderhttps://joellipman.com/articles/cms/joomla/uninstalling-aec-central-and-installing-community-builder.html

20 January 2010 components) 18. Select AcctExp and click on the Uninstall icon. Now install Community Builder 1. Download the latest version from Joomlapolis.com 2. Unzip to a folder 3. Login to your admin panel 4. Go to Extensions > Install/Uninstall 5. Install...

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

Add Image Mouseover effect in AutoHotkey GUIhttps://joellipman.com/articles/automation/autohotkey/add-image-mouseover-effect-in-autohotkey-gui.html

25 January 2010 but for my own program, I put them in folders. Here's the whole code to make a gui with 1 image mouseover: ; ; AutoHotkey Version: 1.x ; Language: English ; Platform: Win9x/NT ; Author: A.N.Other ; ; Script Function: ; Template script (you can customize...

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

Write a Calendar in Autohotkeyhttps://joellipman.com/articles/automation/autohotkey/write-a-calendar-in-autohotkey.html

27 January 2010 an online server (for IT Events during this month) and if it can't download the calendar, it had to display an offline version in the GUI. To display the following code in this website though, I've had to omit a lot of the HTML part. This is the code in...

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

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

03 February 2010 then the website security isn't amazing. I used to have Captcha on my K2 by Joomlaworks but if you did the sound version, it didn't work properly. I found that sometimes the captcha wouldn't even match what you typed and what it displayed!!! I have...

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

Running Internet Explorer 6, 7, 8 as standaloneshttps://joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

18 May 2010 website advising on Run > c:\\download\\ie6setup.exe /c:"ie6wzd.exe /d:1 /s:""#E") If you only want Internet Explorer versions 6 & 7 (Note that installing IE8 will break this) Possibly the easiest thanks to http://browsers.evolt.org/ who have a version...

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

Change the login link in MediaWikihttps://joellipman.com/articles/cms/mediawiki/change-the-login-link-in-mediawiki.html

22 September 2010 use Google because I couldn't find an answer. My situation is this: We have an internal wiki knowledge base using MediaWiki version 1.14. Some articles are available for public, some are restricted to staff and different localgroups. When users click on...

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

Accessing a MySQL Database with Business Intelligence Development Studiohttps://joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 ODBC driver (at time of print v5.1) Visit http://dev.mysql.com/downloads/connector/ Click on "Connector ODBC" Download a version suitable to your system Install it Setup the ODBC Connection Start > Programs > Administrative Tools > Data Sources (ODBC)...

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

SSRS Hide results table if emptyhttps://joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 have called this article "Iteration within SQL Server Reporting Services Business Intelligence Development Studio (BIDS) version 2008 through combining Transact-SQL and MDX expressions" but boy what a mouthful, and it's not really iterating anymore. So...

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

What's the problem? Amusing computer issueshttps://joellipman.com/articles/web-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 to their homepage. The 3rd-party company had obviously designed the template to work in one browser only: Internet Explorer version 7. The marketing web-gurus were simply using different browsers. The project leader was on IE7, while their designer was...

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

Joes Quicklist Weblinks (JQW)https://joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

03 July 2011 like that. I have not got the upgrade server for J16 working yet but soon. Also there's no need to delete a previous version of this module, just download the updated one, and install as per usual. IMPORTANT NOTES: All images in the folder for the...

• 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 Functions, which are designed to make web automation more simple. (original is AHK Basic only, but here is an AutoHotkey_L Version by sinkfaze) Basic Webpage Controls COM Object Reference Last edited by jethrow on Wed Jun 22, 2011 10:18 pm; edited 22...

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

Alternative method of displaying Unicode in Autohotkey GUIhttps://joellipman.com/articles/automation/autohotkey/alternative-method-of-displaying-unicode-in-autohotkey-gui.html

29 September 2011 yes you could just use the Unicode version of Autohotkey. If you're looking for some up and down arrows which is all I wanted, then you don't have to use Unicode and you can use the Chr() function: msgbox % Chr(24) ; upwards arrow msgbox % Chr(25) ;...

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

Basic Oracle Stored Procedure Structurehttps://joellipman.com/articles/database/pl-sql/basic-oracle-stored-procedure-structure.html

16 January 2012 For a basic Oracle function, visit my article Basic Oracle Function Structure. For a more advanced version which uses cursors to work with SSRS, see my article Oracle Stored Procedures in SSRS. What? I asked someone for a simple, easy and basic Oracle...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

No rows returned in Oracle causes SP to failhttps://joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

24 January 2012 line 56 ORA-01403: no data found ORA-06512: at line 1" error Failing part of the stored procedure: -- the version of the first query which would fail the stored procedure SELECT student_accounts.student_id INTO v_STUDENT_REF FROM student_accounts WHERE...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

MySQL: Display Users and Duration in Matrix Timesheethttps://joellipman.com/articles/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

27 April 2012 week per user 3. Combine in a loop to run query against each user. Post-Notes (Update 2012) The performance of the previous version of this query was pretty abysmal and worse if you want to list users who have no associated activities (outer join but...

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