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

  1. Zoho Books / Inventory: Get Item Rate from a Price Book/Listhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-books-inventory-get-item-rate-from-a-price-book-list.html

    price book rate post saving a record in Zoho Deluge would fail because it was making too many function statements. How? I have this code triggered in a workflow when the sales order is created to do some further calculations based on a surcharge rate...

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

    custom related list in ZohoBooks, and a reminder on how to read a table from ZohoAnalytics. Why? My use-case here is that we have a client who uses their purchase orders and sales orders as part of a logistics solution where items are purchased from a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  3. Zoho Projects: Get All Eventshttps://www.joellipman.com/articles/crm/zoho/zoho-projects/zoho-projects-get-all-events.html

    my parameters; the key item to remember is that status is a mandatory field and it can either be "closed" or "open". If you have used ZohoCRM then this is obvious; if you haven't then it may be difficult to work this out. Put simply, "Closed" are events...

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

    What? This is a quick bit of code for my reference so that I don't have to keep finding a function that gives me the syntax of how to either create or update a record using invokeUrl. Why? Because my designers keep including custom fields in their...

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

    duplicate products within ZohoCRM. Why? Product duplicates are a common issue during development, especially when we have products imported via a feed or API or simply by staff and their spreadsheets. There is a deduplication feature for leads and...

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

    me a while to write and I would like to use it as a reference for when I forget how to do this. The use-case here is that we have a dropdown/picklist on a CRM invoice record that has the options of "Deposit" and "Final Balance". This rewrites the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  7. ZohoCRM / Client Script / Canvas: Hide Tab based on Pipelinehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-client-script-canvas-hide-tab-based-on-pipeline.html

    that can be executed by the client script which returns the value of the Pipeline given a deal record ID. Finally, we'll have client script execute this function, then show/hide tabs based on the value. Assuming I have a tab called "Sales Pipeline", and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  8. PHP Script: Make your own Thumbnail Generator via APIhttps://www.joellipman.com/articles/cms/website-development/php/php-script-make-your-own-thumbnail-generator-via-api.html

    an image URL and which both generates and outputs a thumbnail image and makes it downloadable via URL. Why? Performance. I have a client with about 10k images of products that they want to appear in a dropdown menu of a JavaScript widget. When the user...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  9. Zoho Survey: Zoho CRM Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-survey-zoho-crm-webhook.html

    article in this series Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pages which may have grown a little but just wanted to record how to receive a Zoho Survey response in a Zoho CRM REST API function. Why? As above,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  10. ZohoCRM & Xero: Function to pull most recent quoteshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-quotes.html

    + " and Updated " + v_Count_Updated + " from " + v_Count_FoundInXero; } return v_OutputMessage; } Caveat(s): Tax rates have to have the same name in both CRM and Xero The code above is for EU / UK clients only (change the TLD as applicable) The code...

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

    Availability Permission Issue: Are we logged in to Zoho Books as the super admin? Most likely yes and the client would have already checked this. Did this ever work before? Kinda pointless question but needs to be asked just in case this was never meant...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  12. Community Builder in Joomla Vulnerabilityhttps://www.joellipman.com/articles/cms/joomla/community-builder-in-joomla-vulnerability.html

    forum (source: http://forum.joomla.org/viewtopic.php?t=84436) . In fact, there are quite a few vulnerabilities my scanners have picked up on and so I'll be posting solutions for those who need to keep Community Builder as their user manager. There are...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  13. Anti-Spam override for all submitted datahttps://www.joellipman.com/articles/cms/joomla/anti-spam-override-for-all-submitted-data.html

    all your forms need extra plugins and captchas (such as JezRecaptcha), then the website security isn't amazing. I used to have Captcha on my K2 by Joomlaworks but if you did the sound version, it didn't work properly. I found that sometimes the captcha...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  14. Upgrading a Joomla 1.5 module to Joomla 2.5https://www.joellipman.com/articles/cms/joomla/upgrade-a-joomla-1-5-module-to-joomla-1-6.html

    So this is a note to myself so that I have a checklist and can quickly update any extensions designed for Joomla 1.5.x and make these compatible with Joomla 2.5.x websites. In the past, I have only ever changed the words to but for more stability, there...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  15. JDatabase: using the Joomla database with exampleshttps://www.joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

    the Joomla classes but this is just a quick note for myself as a reference sheet. Plus the official documentation don't have enough examples in my view. Source: http://docs.joomla.org/ for v1.5.x and for v2.5.x This article applies to Joomla 1.5.x,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  16. Improve Default Joomla Search https://www.joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

    works. The default is to sort the results by popularity (hits) or by most recently added (depending on your version) which I have never seen in any other system. I've googled and binged but could not find anything that documents how to bring it into...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  17. Creating a custom form field type for Joomla XML fieldsethttps://www.joellipman.com/articles/cms/joomla/creating-a-custom-form-field-type-for-joomla-xml-fieldset.html

    I'm writing a Joomla 2.5.x component for logging time and projects and need a dropdown to have selectable options restricted to the logged-in user. This is specified in the XML file of the custom Joomla component and needs some SQL dependent on some...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  18. ReCaptcha alternative: Integrate PlayThru in JComments 2.3 for Joomla 2.5https://www.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-for-joomla.html

    Why? The kCaptcha used by the jComments extension is easily automated and no longer blocks spam comments. How? So I have come up with what I consider a pretty stable solution. I adapted it from various legacy solutions when using Google's ReCaptcha....

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  19. ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2https://www.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-3-0-for-joomla-3-2.html

    spam comments. Google's ReCaptcha is overrun by click farms and is unable to authenticate engaging visitors. How? So I have come up with what I consider a pretty stable solution. I adapted it from various legacy solutions when using Google's ReCaptcha....

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  20. Warning: Save failed. Another menu item has the same aliashttps://www.joellipman.com/articles/cms/joomla/warning-save-failed-another-menu-item-has-the-same-alias.html

    and remove expired menu items) A good database administrator who is comfortable with making changes to the database Why? We have a page describing the company that we would want entitled "about" or "about-us" but these were already created along the way...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
Results 161 - 180 of 416