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

  1. AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html

    desktop Send, ^#{Right} ; previous desktop Send, ^#{Left} Additional The above example, is if you have 3 monitors. If you only have 2 monitors, then note that right-most will not exist and only left and centre should with the central screen starting at...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  2. Zoho Creator: Retrieve record with case-insensitive queryhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-retrieve-record-with-case-insensitive.html

    startsWith startsWithIgnoreCase used in fuzzy logic searches to broaden the resultset containKey Applies to maps only containValue Applies to maps only Source(s): Zoho Deluge - Functions which return a boolean value Community » Zoho Creator » CASE...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  3. MySQL: Count occurrences of words in a columnhttp://mail.joellipman.com/articles/database/mysql/mysql-count-occurrences-of-words-in-a-column.html

    This is an article to document how to output the most frequently used words in a MySQL database column. How? Note this only applies to MySQL. So the following query will return a count of each word in your database column by order of most used first...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  4. Zoho Creator: Receive JSON via a Shopify Webhookhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-receive-json-via-a-shopify-webhook.html

    JSON Payload [Multi Line] 2. Joel's first Cheat: If your client has ZohoCRM, let's use a CRM REST Function Granted this only works if you have a CRM connected to your Zoho Creator: Log-in to your ZohoCRM Create a Connection Go to Setup > Developer Space...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. Xero API: Send Multiple Invoiceshttp://mail.joellipman.com/articles/crm/xero/xero-send-multiple-invoices.html

    API call? Why? Our use-case is in Zoho Deluge which couldn't generate more than 5 invoices in a scheduled task because Xero only allows 5 concurrent connections at one time... And Zoho was trying to send about 7 at a time (as in schedule created 7 Zoho...

    • Type: Article
    • Author: Joel Lipman
    • Category: Xero
    • Language: *
  6. Zoho CRM: searchRecords with sorted resultshttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-searchrecords-with-sorted-results.html

    Name of the module you want to search. Method #1: zoho.crm.searchRecords() Contrary to the documentation saying there are only the approved and converted values supported in additional parameters, I find the below works in CRM just fine: As of 2025,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  7. Zoho CRM: Manage a subform using Client Scripthttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-manage-a-subform-using-client-script.html

    = ZDK.Page.getField('Currency').getValue(); var v_ConsultantLocation = ZDK.Page.getField('Location').getValue(); // only run the rest if record matches criteria if (v_CurrencyCode == "GBP" && v_ConsultantLocation == "UK") { // get value of trigger field...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  8. ZohoCRM: Import Attachmentshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

    (uppercase A and the word Attachments - no other option). The Attachments folder must contain no subfolders and only unique filenames herein. Perhaps if you were doing this over several imports, you could use the same filenames, I didn't try this,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  9. Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttp://mail.joellipman.com/articles/crm/zoho/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
    • Language: *
  10. ZohoDeluge: Get All eBay Orders Given a From and Till Datehttp://mail.joellipman.com/articles/crm/zoho/zohodeluge-get-all-ebay-orders-given-a-from-and-till-date.html

    added to the same function and that worked at time of print. Note that this uses the old Trading API as the new API is only available in Sandbox??? I won't go into how to generate an Access Token to your client's eBay store as that's covered in my...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  11. ZohoCRM: Using Criteria with Module Record Counthttp://mail.joellipman.com/articles/crm/zoho/zohocrm-using-criteria-with-module-record-count.html

    You can search for a maximum of 10 criteria (with same or different columns) with equals and starts_with conditions. The only operator that is supported for encrypted fields is equals. When you use "equals" for multiple conditions, and if one of your...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  12. ZohoCreator: Basic Widget with Zoho Datahttp://mail.joellipman.com/articles/crm/zoho/zohocreator-basic-widget-with-zoho-data.html

    Zoho Creator: Create a Widget which uses JavaScript back from 2020 with a few adjustments now in 2024. This widget will only work within Zoho Creator. If you want a solution which sits on an external website and which talks to Zoho, then setup an...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  13. Zoho Books / Inventory: Get Item Rate from a Price Book/Listhttp://mail.joellipman.com/articles/crm/zoho/zoho-books-inventory-get-item-rate-from-a-price-book-list.html

    order is created to do some further calculations based on a surcharge rate held in a custom module. The custom module could only be created in Zoho Books at time of print but Zoho Inventory is where our workflow and code is sitting right now. The code...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. Zoho Workdrive: Getting Team Folder IDhttp://mail.joellipman.com/articles/crm/zoho/zoho-workdrive-getting-team-folder-id.html

    = r_WorkdriveFolder.get("id"); // // ====================== // share folder to members woh can access it (read-only) // // list of recipients l_WorkdriveRecipients = {"me@mycompany.com","payroll@mycompany.com"}; // for each v_RecipientEmail in...

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

    v_Frequency = m_Product.get("Frequency"); v_Debug = v_CountTotal + ": " + v_ProductName + ": " + v_Frequency + ":- "; // // only use up more api calls if occurs more than once if(v_Frequency > 1) { // // replace apostrophes with double apostrophe for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  16. ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

    // check source quote is specified var v_QuoteID = ZDK.Page.getField('Converted_From_ID').getValue(); // only make changes to the invoice if 1 of the 2 invoice types selected if ((v_InvoiceType == "Deposit" || v_InvoiceType == "Final Balance") &&...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  17. PHP Script: Make your own Thumbnail Generator via APIhttp://mail.joellipman.com/articles/crm/zoho/php-script-make-your-own-thumbnail-generator-via-api.html

    if you can, why not make 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  18. $_SERVER['http_referer'] returns blank in Internet Explorerhttp://mail.joellipman.com/articles/microsoft/serverhttpreferer-returns-blank-in-internet-explorer.html

    environment variable can be changed by the user anyway but I was using it as an additional validation check. The only solution is to not use it for verification purposes as it will only work in every other browser except Internet Explorer (more...

    • Type: Article
    • Author: Joel Lipman
    • Category: Microsoft
    • Language: en-GB
  19. Joomla banners not rotatinghttp://mail.joellipman.com/articles/cms/joomla/joomla-banners-not-rotating.html

    looking for a solution which doesn't involve installing a 3rd party applicatoin. Unfortunately the Joomla banner module only supports alternating between banners of either the same client OR the same category. The setting is in your Joomla > Module...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  20. Joomla Development: Possible XML Filtershttp://mail.joellipman.com/articles/cms/joomla/joomla-development-possible-xml-filters.html

    WORD Strips anything that is not letters (including numbers) ALNUM Forces the value to be alphanumeric (Letters and numbers only. No special characters) CMD Forces the value to be alphanumeric plus the following three special characters _ (underscore)....

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
Results 81 - 100 of 243

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Please publish modules in offcanvas position.