Advanced Search

Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming description is required, the following 68 results were found.

  1. Alternative method of displaying Unicode in Autohotkey GUIhttps://www.joellipman.com/component/content/article/alternative-method-of-displaying-unicode-in-autohotkey-gui.html?catid=48&Itemid=165

    Chr(a_index) . "`n",ascii-chartable.txt A bunch of others that may work: Some others that may work: Dec Hex Unicode Char Description ------- ------- ------- ------- --------------------------------------- 128 80 U+00C7 Ç latin capital letter c with...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  2. AutoHotkey: App GUI Listview to Rename Fileshttps://www.joellipman.com/component/content/article/autohotkey-app-gui-listview-to-rename-files.html?catid=48&Itemid=165

    of the files. ; ; Language: English ; Platform: Microsoft Windows 7 Professional ; AutoHotkey: v1.33.02 ; Author: - ; Description: This program will remove the word EDIT and words containing an underscore (eg. 01_23) ; and then add an increment to the...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  3. Zoho Creator: Button on Report for Merging Multiple Selected Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

    v_LineItem_Name = r_QuoteDetails.Product_Name; v_LineItem_Desc = r_QuoteDetails.Product_Description; v_LineItem_Price = r_QuoteDetails.Product_List_Price; v_LineItem_Quantity = r_QuoteDetails.Product_Quantity; v_LineItem_TaxAmount =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  4. ZohoCRM & Xero Real-Time Invoices: Receive Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-real-time-invoices-receive-webhook.html

    CRM > Setup > Functions > New Function Function Name: fn_API_ReceiveXeroWebhook Display Name: FN - Xero - Receive Webhook Description: Function used to receive webhooks from Xero and parse these into data for invoices and contacts. Category: Standalone...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  5. Zoho Analytics: Setup DataSource via FTP Connectionhttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-setup-datasource-via-ftp-connection.html

    a single FTP option displayed to you: Step 1 of 2: Give the datasource the table name it will have in Zoho Analytics, a description and then enter in the FTP details as per your configuration, then click on "Next": Step 2 of 2: specify whether first row...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  6. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile)https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-using-a-function-for-validation-rules.html

    a function name, eg. "fn_Validation_LeadStatusChange", a display name, eg. "Fn - Validation - Lead Status Change", and a description... You will be presented with a deluge IDE editor. I'm putting in the following code: /*...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  7. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

    staff use to store details about a product, and then to push that product out to their Shopify store with a pre-built description, tags and inventory details. This means the app needs to be able to sync all of its products, customers, and orders with...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  8. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://www.joellipman.com/articles/else/e-commerce/ebay/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

    it a name and such, I'm doing the following Function Name: fn_eBay_UploadPhoto Display Name: Fn - eBay - Upload Photo Description: What it says on the tin Category: Standalone Click on Create Give it the parameter/argument p_InventoryitemID as an...

    • Type: Article
    • Author: Joel Lipman
    • Category: Ebay
    • Language: *
  9. ZohoCRM: Import Attachmentshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-import-attachments.html

    files to unique filenames. ; ; Language: English ; Platform: Microsoft Windows 11 ; Author: Joel Lipman ; Version: 1.0 ; Description: This program will generate a clean Attachments.zip and its Attachments.csv to upload to Zoho. v_ChangeLogText = ( Date...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  10. Zoho CRM: ZDK Client Script: Auto-Select Pipeline based on User Departmenthttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-zdk-client-script-auto-select-pipeline-based-on-user-department.html

    Clicking on the "New Script" button in the top right. For this demo, we give it the name "On Deal Creation" and in the description I've commented that this will select a pipeline based on the user's department. Category is "Module", Page is "Create...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  11. ZCRM Client Script: Correct Decimal Fields OnLoadhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zcrm-client-script-correct-decimal-fields-onload.html

    Login to ZohoCRM as a system administrator Give it a name, I'm calling mine "Products - Correct Decimals" Give it a description, I'm giving it the one I have in the function header below Category is "Module" Page is "Edit Page (Standard)" Module is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  12. Zoho Creator: Get Images in Report to be Exported to PDFhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-get-images-in-report-to-be-exported-to-pdf.html

    to a Zoho Creator form. The ticket form has the ticket reference, product information, factory/supplier, the fault/description, and a subform to a form called "Documents" linked by a bi-directional ticket lookup. The document form is a subform derived...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  13. Zoho Analytics & Zoho People: Monitor DataSource Sync https://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-zoho-people-monitor-datasource-sync.html

    click on "Scheduler" Click on the "Add Scheduler" button Complete the "Scheduler" header information such as the name, description, start date/time, frequency, and timezone. While you're here, click on "Connections" at the top of the IDE (where you...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  14. Importing Joomla articles to WordPress postshttps://www.joellipman.com/articles/cms/wordpress/importing-joomla-articles-to-wordpress-posts.html

    'term_taxonomy_id', (a.id + @CountCategoriesAlreadyEntered) 'term_id', 'category' AS 'taxonomy', a.description 'description', 0 'parent', (SELECT COUNT(c.id) FROM my_joomla_db.jos_content c WHERE c.catid=a.id) 'count' FROM my_joomla_db.jos_categories a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Wordpress
    • Language: en-GB
  15. Unix Date Format Specifiershttps://www.joellipman.com/component/content/article/unix-date-format-specifiers.html?catid=63&Itemid=165

    for "Unix". This was easier. Source: Wikipedia: Date (Unix) Format specifiers (format string starts with +) Specifier Description Values/Example Day %a weekday, abbreviated Mon %A weekday, full Monday %d day of the month (dd), zero padded 04 %e day of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Linux
    • Language: *
  16. SSIS Convert a string into a datehttps://www.joellipman.com/component/content/article/ssis-convert-a-string-into-a-date.html?catid=74&Itemid=165

    + "/" + SUBSTRING((DT_STR,8,1252)StartDate,3,2) + "/" + SUBSTRING((DT_STR,8,1252)StartDate,5,4)) Error: Description: "Invalid character value for cast specification". Exceptions for text file where I needed two derived column tasks, the first checks if...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  17. SSIS Multiple Lookups in onehttps://www.joellipman.com/component/content/article/ssis-multiple-lookups-in-one.html?catid=74&Itemid=165

    in SSIS. For any SSIS developer trying to create packages that need to decode a number of values into their full name/description (eg. "M" to "Male", "Prof" to "Professor"). Why? Our extract phase in the SSIS package takes data from a source database...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  18. Search a database with SOUNDEXhttps://www.joellipman.com/articles/else/database/search-a-database-with-soundex.html

    ** Author: Joel Lipman ** ** Created On: 12 October 2012 ** ** Revision: v1.2 ** ** Description: Script to create a SQL query which searches a database with SOUNDEX (detects typos). ** ** ** ** Usage: ** ** Step #1: EXEC...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  19. Search a database for a value and count matching rowshttps://www.joellipman.com/articles/else/database/search-a-database-for-a-value-and-count-matching-rows.html

    ** Author: Joel Lipman ** ** Created On: 29 October 2012 ** ** Revision: v1.0 ** ** Description: Stored Procedure to return counts of records per staging database ** ** table that contains a specific value. ** ** NOTE: This script can be run separate to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  20. Stored Procedure to List Distinct Values and Countshttps://www.joellipman.com/articles/else/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

    ** Author: Joel Lipman ** ** Created On: 26 October 2012 ** ** Revision: v1.0 ** ** Description: Stored Procedure to list distinct values and counts (defaults to case and accent-sensitive). ** ** ** ** Usage: ** ** EXEC [usp_ListDistinctValuesAndCounts]...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
Results 41 - 60 of 68