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

  1. Zoho CRM/Creator - Common Errors & Gotchashttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-creator-common-errors-gotchas.html

    be applied Following a post similar to the above example by InvokeURL and then getting a JSON response back, the response does not seem to be read as a map: r_Response = invokeurl [ url :v_DataEndpoint type :POST parameters:m_CreateRecord...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  2. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

    Finance". There is a lag/delay in the synchronization of Zoho Books to Zoho CRM and vice-versa. Annoyingly the attachment does not appear to be included in any sync... This method would be enough if the action was instantaneous and the attachments were...

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

    connection name and note down the connection link name. I'm calling mine joel_zoho Authorize it, etc. Make a workflow which does the clever bit in Zoho Creator: Go to Workflow > Form Workflows > New Workflow Choose the form > Run when Created or Edited...

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

    The mandatory field 'Attachment Id' must be mapped: Give a unique value for the column attachment ID (filename column does not need to be unique) and ensure there are no subfolders. Uploaded files does not contain any attachments folder hence...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  5. Zoho Deluge: Proper Case for Nameshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-proper-case-for-names.html

    as duplicates, when actually they are the same entity but may have uppercased a letter in their name while the other entry does not... This article is a start and adaptation of my previous article Convert to Proper Case in T-SQL which I had previously...

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

    "$1", false)); Works a treat at truncating but still does NOT match how ZohoBooks does it. ZohoBooks rounds the .545 to .55 and .544 to .54... so let's abandon the truncating and simply deduct 1/10th of a cent/penny: // ------------------------- // Make...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  7. Could not instantiate mail functionhttps://www.joellipman.com/articles/cms/joomla/could-not-instantiate-mail-function.html

    file. 4) The hostname must resolve. If not, add the required A records to the dns zone such that it does. 5) The directory /etc/virtual/hostname must exist.. (eg: /etc/virtual/server.domain.com). It must not contain any files. 6) Any domains that you...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  8. Compare two databases using T-SQLhttps://www.joellipman.com/articles/else/database/t-sql/compare-two-databases-using-t-sql.html

    databases and you have their full schemas. Use a comparison tool to compare the outputs. Method #2 Enhancing the above which does a little more of the work, requires in the following query for you to replace the terms "myDB1" with the first database...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  9. htaccess Rewrites SEF URL and submits to PHPhttps://www.joellipman.com/articles/cms/website-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

    A quick note on a htaccess rewrite rule I'm liking. What does it do? What I type: http://www.mywebsite.com/blog/videos.html Sends this to server: http://www.mywebsite.com/index.php?myFolder=blog&myFiles=videos How? Options -Indexes +FollowSymlinks...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  10. Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=105&Itemid=165

    Aesthetic tweaks for Joomla v3 admin panel. - Date Uploaded: Mon, 14th Jul 2014 Download 3.1 AdrianaV/Vincent - Enhancement: Does not display more images then are available. - Enhancement: Auto-Check for cURL functions enabled on server. - Fixed Bug:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  11. Regular Expressions in SQLhttps://www.joellipman.com/articles/else/database/regular-expressions-in-sql.html

    '[^a-zA-Z0-9\'']') -- returns all rows where the student surname contains non-alphanumeric characters and does not contain apostrophes -- eg. O'Brien will NOT be returned -- Other REGEXP Functions for Oracle: -- -- REGEXP_REPLACE(country_name, '(.)',...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *
  12. Zoho Cliq: Integrate OpenAI ChatGPT with Conversation Threadshttps://www.joellipman.com/articles/crm/zoho/zoho-other/zoho-cliq-integrate-openai-chatgpt-with-conversation-threads.html

    So it's good for 1 question and 1 answer. What we need is to train it a little a bit like the standard OpenAI Chat website does in terms of context. How? Just a few changes to the previous code of connecting to OpenAI ChatGPT but the exception here is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  13. Disclaimerhttps://www.joellipman.com/component/content/article/disclaimer.html?catid=50&Itemid=165

    of Joel Lipman .Com. We have no control over the nature, content and availability of those sites. The inclusion of any links does not necessarily imply a recommendation or endorse the views expressed within them. Every effort is made to keep the website...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  14. Batch Process to rename multiple files using Windows DOShttps://www.joellipman.com/component/content/article/batch-process-to-rename-multiple-files-using-windows-dos.html?catid=51&Itemid=165

    double-check what you're about to do. Save and Close the notepad file Return to the command prompt and type rename.bat (This does the actual renaming of the files). Type the following DELETE rename.bat (removes it from the users computer) Exit the...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
  15. Joe's Unduplicater (JUD)https://www.joellipman.com/component/content/article/joes-unduplicater.html?catid=53&Itemid=165

    file extensions and file size differences. - Released to the world via http://www.joellipman.com/. OTHER NOTES: This program does not install any files. You can run it off the executable (EXE) within or run the Autohotkey file (AHK) if you have...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  16. Joes Word Cloud (JWC)https://www.joellipman.com/component/content/article/module-joes-word-cloud-jwc.html?catid=53&Itemid=165

    How to Use Install the ZIP using your Joomla! Admin Panel > Extension Manager View the module on your front-end to see if it does what you want it to do. Modify the module parameters as necessary. Setup First of all, you need to make it visible. These 3...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  17. Joes Bug Tracker (JBT)https://www.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=53&Itemid=165

    address?) --- Priority (High, Medium, Low - configurable in settings) --- Impact (free-text message by developers -> who does this affect?) --- Progress Status (acknowledged, testing, qa [=awaiting customer], resolved, postponed) --- Progress Indicator...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  18. Joes Password Analyzer (JPA)https://www.joellipman.com/component/content/article/joes-password-analyzer-jpa.html?catid=53&Itemid=165

    quickly. Companies using certain password systems can even send the login credentials to the remote machine for you, but does this just open another can of worms? The trick in my opinion is a memory aid. How to use Type a word in the input field and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  19. Joes Search Module (JSM)https://www.joellipman.com/component/content/article/joes-search-module-jsm.html?catid=53&Itemid=165

    If there is a demand for it, I would add the category parameter to restrict searches as I see from Google searches that this does not exist as yet. Comments/Questions Please use the comment box below to add any questions (you can even post anonymously)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  20. Zoho Creator: Retrieve record with case-insensitive queryhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-retrieve-record-with-case-insensitive.html

    ------------- MyProduct1 TEST01 Myproduct2 TEST02 myproduct3 TEST03 I'm trying to insert a record for a new product if it doesn't exist in the table but if it does exist then to simply skip adding the product. v_Name = "Myproduct1"; // note the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
Results 21 - 40 of 120