Zoho Creator: Receive eBay Order Notifications via Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 of these steps. Once we have an access token, we will check what notifications already exist (if any), and then we will create a function that subscribes the application so that any order is sent to a URL, specifically a CRM REST API function that will...

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

ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.https://www.joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-please-ensure-that-the-shipping_address-has-less-than-100-characters.html

22 September 2021 how to update a Shipping Address for a specific Sales Order in Zoho Books. Why? You might think the following request to create a Sales Order in Zoho Books would be enough: { "date": "2021-09-08", "zcrm_potential_id": "123456789012345678",...

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

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

14 October 2024 type of interface. This time, we're going to repurpose and restyle a radio type field into a color picker. Pre-amble: Create a Zoho Creator form Create a form, I'm calling mine "Color Picker" Add a note field, I've given it the field link name...

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

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

09 October 2025 in the future. At time of print (9th October 2025), for some reason, if you click on the plus icon next to Sales Order (creates a new sales order) on the quote record, the fields auto-map. The client script below does the same for invoice as the quote...

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

ZohoCRM & Xero: Function to pull most recent invoiceshttps://www.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-invoices.html

09 October 2025 Function to get the first page of most recent invoices from Xero and pull them into ZohoCRM Inputs: - Outputs: - Date Created: 2025-10-08 (Joel Lipman) - Initial release Date Modified: 2025-10-13 ( Joel Lipman) - Parsing Xero Dates and Times to include...

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

ZohoCRM & Xero: Function to pull most recent quoteshttps://www.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-quotes.html

13 October 2025 Rates Trigger: Standalone / On-Demand Purpose: Function used to map Xero tax rates to Zoho ones Inputs: - Outputs: - Date Created: 2025-10-13 (Joel Lipman) - Initial release Date Modified: ??? - ??? More Information: Ensure that all possible tax rates...

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

How to redirect the visitor after the contact pagehttps://www.joellipman.com/articles/cms/joomla/how-to-redirect-the-visitor-after-the-contact-page.html

06 September 2009 $contact[0]->id .'&Itemid='. $Itemid ); mosRedirect( 'index.php?option=com_content&task=view&id=28&Itemid=102' ); Create thankyou page and menu item for ID, change this in the code to redirect to the item ID - remove menu item Ultimately this solved the...

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

Mediawiki Extension for Camtasia Studio SWF videoshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

08 October 2009 Camtasia Studio v5.0 For Demonstration Purposes We want to add a video called "EXAMPLE.SWF" to an article Let's begin Create your video in Camtasia Studio and produce the SWF files Finish doing your video Go to File > Produce Video As... > Custom...

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

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

05 January 2011 Click on "Change..." Select "Microsoft ODBC Data Source" > OK Select the data source from the dropdown (the one you just created earlier should be listed) Enter credentials if necessary and click on "Test Connection" Expand the data connection you just...

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

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

28 June 2011 options. Consider this file temporary and if you want to delete/rename this and the images folder, the program will just create another one. Question How does the thumbnail name generating work? Answer: The program loops through the images folder and...

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

Sort order a dropdown list in MS InfoPath without programminghttps://www.joellipman.com/articles/microsoft/infopath/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html

21 July 2011 your datasheet (has a MS Access icon in the top left to remind you what you're getting yourself into) Go to Settings Select Create View Select Datasheet View (you could probably use a "Standard View", I just used the Datasheet one) Give the view a name,...

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

Basic Oracle Function Structurehttps://www.joellipman.com/articles/database/pl-sql/basic-oracle-function-structure.html

15 January 2012 I need to refer to how to create a function in Oracle PL/SQL and sites on the net just attempt to overcomplicate everything and have forgotten how it is to be new to Oracle. I need a function in it's simplest form and if I want to torture my successors,...

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

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

16 January 2012 and then to use this number in a second query which we're hoping will be quicker than a straightforward table join. Syntax CREATE [OR REPLACE] PROCEDURE stored_procedure_name [ (parameter [,parameter]) ] IS | AS [declaration_section] BEGIN...

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

Copy a table with structure and data into a temporary tablehttps://www.joellipman.com/articles/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

03 August 2012 if already exists IF OBJECT_ID ( 'dbo.usp_MakeTableTemp', 'P' ) IS NOT NULL DROP PROCEDURE dbo.usp_MakeTableTemp; GO -- Create Stored Procedure CREATE PROCEDURE dbo.usp_MakeTableTemp @SchemaTableName nvarchar(100) AS BEGIN -- Variables used DECLARE...

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

Stored Procedure to List Distinct Values and Countshttps://www.joellipman.com/articles/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

26 October 2012 How? IF OBJECT_ID('usp_ListDistinctValuesAndCounts', 'P') IS NOT NULL DROP PROCEDURE [usp_ListDistinctValuesAndCounts]; GO CREATE PROCEDURE [usp_ListDistinctValuesAndCounts] ( @p_SearchTable VARCHAR(max), @p_SearchColumns VARCHAR(max), @p_UseCollation...

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

DataTumble - Randomize Data Rowshttps://www.joellipman.com/articles/database/t-sql/datatumble-randomize-data-rows.html

07 December 2012 they'll resolve issues faster than if they were given scrambled data (see my articles on DataJumble and DataScramble). How? CREATE PROCEDURE [Common].[usp_ScrambleMultivalue] ( @TableName VARCHAR(MAX), @ColumnName VARCHAR(MAX), @WhereClause VARCHAR(MAX)...

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

JDatabase: using the Joomla database with exampleshttps://www.joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

27 January 2013 and more organized. Here is a query which shows the building methods: // Get a db connection. $db = JFactory::getDbo(); // Create a new query object. $query = $db->getQuery(true); // build the SQL query $query->select($db->quoteName(array('p.user_id',...

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

Administrator Program Shortcut without Prompthttps://www.joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

25 February 2013 administrators on the workstation, they error incessantly and never manage to do what you want them to do. What? I want to create a desktop shortcut that I can double-click and it will run the above programs in administrator mode without confirmation by...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 to Mixed case" , ComponentType = ComponentType.Transform)] public class MyConvertToProperTransform : PipelineComponent { // Create a variable which is used to identify the data column being processed private int[] inputBufferColumnIdx; // Create...

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

Creating a custom form field type for Joomla XML fieldsethttps://www.joellipman.com/articles/cms/joomla/creating-a-custom-form-field-type-for-joomla-xml-fieldset.html

25 October 2013 for the admin panel, see my article Joomla article modal with clear button for Joomla article selection. How? We have to create a custom form field type. In the following example, I'm going to create a dropdown which selects all projects associated with...

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