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 created is required, the following 133 results were found.

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

    application when including CSS opacity] Step 1: Code to complete the radio options This is the code when loading the form: Created or Edited > Load of the Form // // I like defaulting variables v_DefaultColor = "#000000"; // // a color palette...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  2. Zoho CRM: Updating a CRM record Custom Line Items using API v7https://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-updating-a-crm-record-using-api-v7.html

    Purpose: Actions when a quote is modified Inputs: int p_QuoteID - the ID of the CRM Quote Record Outputs: void Date Created: 2024-12-10 (Joel Lipman) - Initial release Date Modified: ??? - ??? More Information: Any information that may help...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  3. Zoho CRM: Remove Duplicate Product Recordshttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-remove-duplicate-product-records.html

    Duplicates Trigger: Standalone Purpose: Used to remove duplicate products from a ZohoCRM instance Inputs: - Outputs: - Date Created: 2025-03-07 (Joel Lipman) - Initial release Date Modified: ??? - ??? More Info: -...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  4. ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoicehttps://joellipman.com/articles/crm/zoho/zoho-books/zohocrm-to-zohobooks-api-half-a-cent-or-penny-off-when-creating-an-invoice.html

    is to deduct the 10th of a cent/penny and as per the documentation for adjustments, we'll run a check after the invoice is created/updated and check that the total matches the CRM grand total and then add the difference as an adjustment with the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  5. Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://joellipman.com/articles/crm/zoho/zoho-analytics/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

    Standalone / On-demand Purpose: Extracting a chart from Zoho Analytics Inputs: The CRM contact record Outputs: - Date Created: 2025-09-25 (Joel Lipman) - Initial release Date Modified: 2025-09-29 (Joel Lipman) - Deletes existing images in the image...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  6. Zoho Survey: Zoho CRM Webhookhttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-survey-zoho-crm-webhook.html

    score and results from Analytics into the corresponding Zoho CRM record. Inputs: String crmAPIRequest Outputs: - Date Created: 2025-09-19 (Joel Lipman) - Initial release - Identifies a survey by email Date Modified: 2025-10-06 (Joel Lipman) - Clients...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  7. ZohoBooks: Broken UK Banking Feedhttps://joellipman.com/articles/crm/zoho/zoho-books/zohobooks-broken-uk-banking-feed.html

    will remain intact, and only new transactions will sync. Caveat(s): Refreshing the feed means that duplicates will be created. You will need to delete the ones manually imported in order for the numbers to be brought in line. Notes and findings:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  8. Change default order of weblinkshttps://joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

    an issue if some of your links have http and some don't description - not recommended! date - the one I use for most recent created - this is also a date formatted field modified - and this is a date formatted field hits - number of times that weblink...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  9. Creating a Profile Plugin for Joomla 1.6https://joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

    (and sync with 3rd party avatar). Not riveting stuff but something that all my clients want. Fortunately for me, I just created one plugin which I can install on any number of Joomla 1.6 sites and it does all this for me... Neat huh? Folder I'm going to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  10. Protecting your Joomla Administrator Sectionhttps://joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

    # change this to the code to match the above PHP script RewriteRule .* - [L,F] How-to-use: Browse to the folder you created in step 1 and this will be your new administrator URL. Caveat: If you login to the administrator section on a shared computer,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  11. Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttps://joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

    the latest Joomla (at time of print this is version 5.2.3) as a ZIP Extracted this to the new 2025 production folder I created earlier Pointed a test.joellipman.com domain to the 2025 folder. Visited the test.joellipman.com to run through the Joomla...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  12. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://joellipman.com/component/content/article/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html?catid=61&Itemid=165

    } else{ $output = $response; } // close first request handler curl_close($ch1); // now let's get the ID of the file we just created // and submit the file metadata $this_response_arr = json_decode($response, true); if(isset($this_response_arr['id'])){...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  13. Mediawiki Extension for Camtasia Studio SWF videoshttps://joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

    flvplayer by Christopher Ottley)', 'url' => 'http://www.joellipman.com/', 'description' => 'Displays videos we have created using Camtasia Studio.' ); $wgExtensionFunctions[] = "wfFlvPlayerExtension"; /* * The FlvPlayer class generates code that embeds...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  14. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/component/content/article/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html?catid=74&Itemid=165

    columns passed into the component // It locates the actual column value (including checking for null) using the index array created in the Pre-Execute public override void ProcessInput(int inputID, PipelineBuffer buffer) { string inputValue; string...

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

    server. We had around 12 lookups to do, so you could do this: But we didn't want to do this. How? As a proof of concept, I created one lookup task that executes a SQL query which returns all the joined tables and displays the decode name. Let's pretend...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  16. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://joellipman.com/component/content/article/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html?catid=75&Itemid=165

    to list all the details. On the last report, the one to execute the stored procedure, we use an account specifically created to run the stored procedure. This requires using 2 data sources in SSRS. A user will specify the student reference in the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  17. SSRS Dropdown parameter cannot be blank!https://joellipman.com/component/content/article/ssrs-dropdown-to-allow-blank-values.html?catid=75&Itemid=165

    I have created an SSRS report which can compare 4 reports side by side and brings up their latest execution times to the nearest millisecond. The report has 4 parameters. Each parameter is a dropdown populated by a list of all available reports. Why? I...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  18. Administrator Program Shortcut without Prompthttps://joellipman.com/component/content/article/administrator-program-shortcut-without-prompt.html?catid=80&Itemid=165

    Additional: You can change the icon for the shortcut using the shortcut properties and browsing to the program it was created to run. Related Link(s): Elevated Program Shortcut without UAC Prompt Avoid UAC prompts by using an elevated program launcher...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  19. Hide a Drive per User in Windows 7https://joellipman.com/component/content/article/hide-a-drive-per-user-in-windows-7.html?catid=80&Itemid=165

    right click on a empty area, click on New > DWORD (32-bit) Value > type NoDrives > Enter. Right click on the DWORD you just created and click on Modify. Type in the drive option hex or decimal number from the list below you want to set as restricted,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  20. T-SQL DateTimestampshttps://joellipman.com/articles/else/database/t-sql/t-sql-datetimestamps.html

    got a list from databases.aspfaq.com but the convert numbers didn't correspond to the output formats. This is my list created within my environment and setup (see above).

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
Results 101 - 120 of 133