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

  1. Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

    This is a very quick article with examples of managing a multi-user or multi-lookup field in CRM using Zoho Deluge. Why? Sometimes you might need this when data mapping fields from one module to another, sometimes you need to manage existing...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  2. ZohoDeluge: Inserting a new line character in a CSVhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zohodeluge-inserting-a-new-line-character-in-a-csv.html

    // v_CSVFilename = "Test.csv"; f_CSVFile = l_CsvFileRows.toString("\n").toFile(v_CSVFilename); // // sometimes works but sometimes yields: // Me,Myself,I\na,b,c Works on systems where the above doesn't work: l_CsvFileRows = List();...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  3. Zoho People: Get Performance Records over APIhttps://www.joellipman.com/articles/crm/zoho/zoho-people/zoho-people-get-performance-records-over-api.html

    parameter CONFIG is not proper(Has not been sent or is less than required count)"}} Crazy! sometimes the invokeUrl wants its parameters changed using .toString()... sometimes it doesn't, as it did in this case. EXTRA_KEY_FOUND_IN_JSON...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  4. Mouseover Links in AutoHotkeyhttps://www.joellipman.com/component/content/article/mouseover-links-in-autohotkey.html?catid=48&Itemid=165

    find this is remarkably temperamental. If the user is too quick with their mouseovers and mouseouts, then the GUI will sometimes leave the link as blue despite the mouse cursor not being anywhere near it. Proper HTML mouseovers: When I have a more...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  5. A for loop within a for loop in MS-DOShttps://www.joellipman.com/component/content/article/a-for-loop-within-a-for-loop-in-ms-dos.html?catid=51&Itemid=165

    to loop through a directory and then loop through the line it finds. Why? I use another technology for automation but sometimes the simpler solution is the one I make for other people to use. Explaining MS-DOS batch programs is a lot easier and...

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

    "display notification of each error") as these may affect the way the program takes a screenshot (shouldn't but these can sometimes confuse the program) Rant It's flimsy, crude but does what it has to do. The program itself took only about 6 days to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  7. Joes Quicklist Weblinks (JQW)https://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=53&Itemid=165

    (says "FREE" - Tested: Add [http://img.freewebsitethumbnails.com/?u=]) So what to do with all of these? Well sometimes a service can be busy, maybe you're near your limit for FREE thumbnails. No problem! This module only makes a request when you enable...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  8. Joes DNS Correction (JDC)https://www.joellipman.com/component/content/article/joes-dns-correction2.html?catid=53&Itemid=165

    Studio 2008 IDE (Business Intelligence Development Studio - BIDS) along with Microsoft's Team Foundation Server (TFS). Sometimes I'll check out an item from TFS and before I get to update it, my connection will drop and my computer will say that it...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  9. Zoho CRM/Creator - Common Errors & Gotchashttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-creator-common-errors-gotchas.html

    // yields: 123456789012345678 Problem: Inserting a date time string into a date time field in Deluge So annoying but sometimes you want to insert a date/time value into a date/time field and you get the error: v_MyDateTimeString =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  10. Zoho Deluge: Search Records with Special Characters (COQL)https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-search-records-with-special-characters-coql.html

    a value that may contain an ampersand or parenthesis. Why? I wrote this article because some searches will work for me and sometimes it won't. Escaping the ampersand with a backslash or url encoding to %26 wasn't working for me. I spent several hours...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  11. ZohoCRM: Process all records of a modulehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-process-all-records-of-a-module.html

    processing the same record twice. Why? Whether you have a few hundred records, or a few hundred thousand records, we sometimes want to write a function that will check each record and mark it so that the process doesn't repeat on records that have...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  12. Zoho CRM & Zoho Bookings Issue: Full Name appears in Last Name (first name first name last name)https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-zoho-bookings-full-name-appears-in-last-name.html

    to explain why the full name might appear in the last name field in Zoho CRM. Why? We had a customer report the issue that sometimes the full name of a contact was appearing in the last name field and creating a contact called "Firstname Firstname...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  13. Zoho Deluge: a HTML Entity Decoderhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-a-html-entity-decoder.html

    A very quick article to document a HTML Entity decoder in Zoho Creator. Why? Sometimes when receiving data from a third-party, we may receive some strings containing "&" or " " and obviously want to display these as decoded HTML entities. (Zoho if...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  14. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeroshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-regex-rounding-and-or-removing-trailing-zeros.html

    displayed on a template and if they gave 10% discount, it would display as 10.00%. And they need the decimal because sometimes they might offer 12.5%. But when it displays in a template, it isn't that pretty to look at: Instead, could they have 10% to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  15. Zoho Books/Inventory: Trigger a workflow when an invoice has been paidhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-books-inventory-trigger-a-workflow-when-an-invoice-has-been-paid.html

    The customer had added 3 custom fields: Payment Method, Payment Date, and Last Four Digits. They needed these because sometimes their customers needed to know what card they had paid with (if paid by card). The customer wanted payment method and payment...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  16. Zoho Analytics: Determine profits from invoices and purchase ordershttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-determine-profits-from-invoices-and-purchase-orders.html

    Here are some other queries that are required for the above but you may want to use the out-of-the-box modules instead: Sometimes, a salesperson or user might be generating an invoice on behalf of the account manager (person who manages the customer's...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  17. 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

    IDs, Variant IDs, Inventory IDs, Current Selling Price, Inventory Level, and Barcode all match. Our problem is that sometimes more than 100 products are modified in a day... We need to be able to do more than 100 or at least resume from a record... We...

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

    in ZohoCRM. Why? So we have a customer that has some decimal fields on the products module that are calculated and will sometimes return numbers with more than 6 decimal places. As this is more than specified on the ZohoCRM field properties, as soon as...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  19. Zoho Webhooks & Shopify API: Keep Disappearinghttps://www.joellipman.com/articles/else/e-commerce/shopify/zoho-webhooks-shopify-api-automatically-restore.html

    time to store the record but that's it. Processing the record must be done at a later time or in a different process but sometimes it simply will not process it all and respond to Shopify within 1 second. How? So let's begin with the code snippets as...

    • Type: Article
    • Author: Joel Lipman
    • Category: Shopify
    • Language: *
  20. ZohoAnalytics & ZohoBooks: Custom Related List from Analyticshttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohoanalytics-zohobooks-custom-related-list-from-analytics.html

    and a value is by single-quotes. m_Params.put("criteria","\"SO ID\"='" + v_SalesOrderID + "'"); m_Config = Map(); // sometimes parameters need to be a string... but this is working m_Config.put("CONFIG",m_Params); v_Endpoint =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
Results 1 - 20 of 35