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

  1. Zoho Analytics: Create a Monitoring System with Imageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-create-a-monitoring-system-with-images.html

    into the system stored on your device. A URL (as in an image hosted on another website) can be used so you might skip the first section here where I demonstrate how to upload photos to be hosted by the Zoho Analytics app. Uploading the images to be...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  2. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://www.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

    The scopes I chose were to do with getting a working example rather than the recommended scope, though you may only need the first (untested): https://www.googleapis.com/auth/drive.file https://www.googleapis.com/auth/userinfo.email...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  3. Change default order of weblinkshttps://www.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

    a weblinks category. The issue is that suppose a menuitem links to a category of weblinks, the default sort order (as in the first time you view the page) is the order in the admin panel (not even by most recent). I'm going to show you how to do this by...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  4. Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

    but still can't find a good way to upgrade my site from Joomla version 1.5 to 1.6 so as usual I find myself writing the first migration script. Why use a script? Well apps like jUpgrade didn't work for me. This is how to manually migrate using a MySQL...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  5. SSRS Querying on either of 2 Parametershttps://www.joellipman.com/component/content/article/ssrs-querying-on-either-of-2-parameters.html?catid=75&Itemid=165

    Then I want the ID parameter ("@StudentReference") to populate itself if it is left blank when the report is executed. So my first dataset has to include the Username check as well (…WHERE StudentID=@StudentReference OR StudentName=@StudentADAccount)....

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  6. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://www.joellipman.com/component/content/article/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html?catid=45&Itemid=165

    a chance to show off my build. Although not high budget like lots of YouTubers I drew inspiration and advice from, it's my first build in a long time. It's always been a dream of mine (see my pinterest) to build a nicer looking computer and I was given...

    • Type: Article
    • Author: Joel Lipman
    • Category: Articles
    • Language: *
  7. Forum Ruleshttps://www.joellipman.com/component/content/article/forum-rules.html?catid=50&Itemid=165

    it. Cheating the censor system is against the rules. If you break one of these rules, the following penalties will apply (first time, second time, third time...) with the exception of breaking the rule "No Hacking" which immediately results in a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  8. Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=53&Itemid=165

    I never email for personal details, passwords etc so if something comes from my site it should only be if you contacted me first :c) FAQs Question What's the "lastscreenshot.bmp" image for? Answer: The program initially takes a picture and saves this as...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  9. Zoho Deluge: Setup an API Connection for InvokeURLhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-setup-an-api-connection-for-invokeurl.html

    "joelconnector" ]; How? So in the following example, we are going to setup a connection in Zoho Books on an EU datacenter: First determine what datacenter your client is using Register the App Setup the Connector How do I determine what datacenter to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  10. Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-create-a-widget-which-uses-javascript.html

    of Zoho Widgets as a daunting task. But after doing some, I realize this is actually very quick to do and much easier than first thought. The article below documents how to create your first widget in a MacOS environment. I aim to create a WindowsPC...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  11. Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://www.joellipman.com/articles/crm/zoho/zoho-people/zoho-people-reject-an-application-for-leave-in-deluge.html

    solution, which was not to try to update the form at all but instead to prevent the user from applying for leave in the first place: Create a validation custom function: Login to ZohoPeople as an admin, Go to Settings > Customization > Forms > Leave...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  12. Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

    lot of fields in the mix. How? I'm using this article to go through various methods I tried to prevent this from happening: First - Off: The one workflow to rule them all In the first instance, we don't want large amounts of code to be copied and pasted...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  13. Zoho Creator/Deluge: UnPredictable exception, Invalid statement foundhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-deluge-unpredictable-exception,-invalid-statement-found.html

    these for each r_Record in l_AllRecords { // set an if condition if(r_Record.Type == "Subform1") { // loop through the first subform of this record for each r_SubformRow in r_Record.mySubform1 { v_StartTime = r_SubformRow.Start_Time; } } // set an else...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  14. Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

    An article to resolve my frustration in being able to ONLY retrieve the first 100 products using GraphQL, so page 1 of Shopify products. Why? Our use-case is that we retrieve the 100 most recently modified products at the end of each day and run some...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  15. Zoho Creator: Input Color Pickerhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-input-color-picker.html

    0 0 0 !important;}"; v_CssStyle = v_CssStyle + ".zc-Color_Picker .choice-table-row{float:left;display:none;}"; // first row is slightly different v_CssStyle = v_CssStyle + ".zc-Color_Picker div:nth-child(-n+30) span label...

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

    the older one (referred to as keep ID). Another point is that this is using COQL to sort the records and tries to keep the first version of the record (sorted by ID ascending) and will attempt to delete the other records which match on product name. I...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  17. SSRS External Images don't displayhttps://www.joellipman.com/component/content/article/ssrs-external-images-dont-display.html?catid=75&Itemid=165

    are not using one of your Intranet computers or user accounts (eg. try Local Admin Account on Computername as domain). The first two of the above worked for us, which indicated an issue with the credentials we were using to access the the photos, so:...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  18. Convert to Proper Case in T-SQLhttps://www.joellipman.com/articles/else/database/t-sql/convert-to-proper-case-in-t-sql.html

    C#. This version is entirely using T-SQL and we're going to use a function so no dynamic SQL (execute, evaluate). Method #1: First version This was my first attempt based on snippets around the web. This one has two sections, the first part capitalizes...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  19. Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/component/content/article/basic-webpage-controls-with-javascript-com.html?catid=48&Itemid=165

    Explorer, but JavaScript can be used with most Web Browsers) The guidelines for "translating" JavaScript can be found in the first post of the COM Standard Library thread (for AHK Basic). Color Legend wrote: Javascript: dark blue AutoHotkey_L: black AHK...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  20. Prefix Line Numbers in a Text Filehttps://www.joellipman.com/component/content/article/prefix-line-numbers-to-a-text-file.html?catid=51&Itemid=165

    document and then needing lines prefixed so that I can explain the code. What? Change contents of "original_file.txt" The first line of my code The second line of my code The third line of my code To "results_file.txt" 1: The first line of my code 2:...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: *
Results 21 - 40 of 215