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

  1. A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/cms/website-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

    up the DataChange Out Rule (DOR) This is where we can link to other entities and create the rules on changes to the relevant fields Run DOR from the menu system Enter a DOR code (we kept this the same as the the XET and EOR codes) Specify the Message...

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

    COM_SEARCH_NEWEST_FIRST COM_SEARCH_OLDEST_FIRST COM_SEARCH_MOST_POPULAR COM_SEARCH_ALPHABETICAL JCATEGORY COM_SEARCH_MOST_RELEVANT « Show Me » To add it to the frontend as option in advanced search: FUNCTIONALITY...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  3. GDPR Privacy Policyhttps://www.joellipman.com/component/content/article/gdpr-privacy-policy.html?catid=50&Itemid=165

    • Type: Article
    • Category: Static Items
    • Language: *
  4. Licence GNU/GPLhttps://www.joellipman.com/component/content/article/licence-gnugpl.html?catid=50&Itemid=165

    you also meet all of these conditions: a) The work must carry prominent notices stating that you modified it, and giving a relevant date. b) The work must carry prominent notices stating that it is released under this License and any conditions added...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  5. 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

    and products module. A multi-user lookup will tend to have something like "ModuleName_X_Users". Find records relevant to this module: l_LinkedRecords = zoho.crm.searchRecords("Opportunities_X_Products","(Opportunity:equals:" + v_DealID + ")"); Find...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  6. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng)https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-deluge-get-timezone-based-on-geocoded-address-lat-lng.html

    The added feature is that we are going to loop through picklist options (500 timezones) in CRM to select the most relevant one. If all this fails, then it defaults to a module called "States" which stores a default timezone and can be searched for with...

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

    To create an analytics table from a query, we do the following: Login to Zoho Analytics, and choose a workspace with the relevant data (in this case Zoho Books Analytics workspace) In the left sidebar, select "Data Sources" then click on the "Add Data...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  8. Zoho CRM Client Script: Map Quote to Invoicehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-client-script-map-quote-to-invoice.html

    this invoice var o_LinkedDeal = ZDK.Page.getField('Deal_Name__s'); // if linked deal is blank, then see if we can find a relevant deal if (o_LinkedDeal.getValue() == null) { // if deal on the quote is not blank, then let's associate that one to this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  9. Privacy Policyhttps://www.joellipman.com/component/content/article/privacy-policy.html?catid=50&Itemid=165

    information including email address demographic information such as postcode, preferences and interests other information relevant to customer surveys and/or offers What we do with the information we gather We require this information to understand your...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: en-GB
  10. Zoho Templates - Font size is inexplicably tinyhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-templates-font-size-is-inexplicably-tiny.html

    were red herrings as I have other templates that work fine. How? The error is one of those that you wouldn't consider relevant in this case, after all, all styling was removed... Here are two screenshots to demonstrate the issue: Screenshot #1: This...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  11. Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

    or URL of the image. Why? I've got some other articles on handling images in Zoho Creator (see "Sources" below), the most relevant one being my article Zoho Deluge: Get Image Uploaded in Creator Form which has one method of getting a public link. My...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  12. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

    headers:m_Header ]; info r_GetProduct; Awesome! Now for the primary objective of this task, which was to recover the relevant product based on any given Product SKU. Making the above into a function as well as returning the inventory item ID and the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  13. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM recordhttps://www.joellipman.com/component/content/article/zohoflow-zohosign-retrieve-a-zoho-sign-document-request-and-add-attachments-to-crm-record.html?catid=138&Itemid=165

    It then retrieves the Deal Reference (entered by an office signee) on the ZohoSign document and searches for the relevant Deal record in CRM. Why? A client wants that when this field is entered and the document signed and returned, it attached the...

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

    ...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  15. ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

    This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records... Why? I'm storing this here as a reference and taking the bits that I...

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

    [ url : v_PriceBookEndpoint type :GET parameters: m_Params connection:"zbooks" ]; // // tests show this only returns the 1 relevant item from a pricebook of many more items l_PriceBookItems = ifnull(r_ThisPriceBook.get("items"),{}); for each...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  17. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

    already but we don't expect staff to go to another app to check on this and would rather see it directly in ZohoCRM on the relevant record. So the more observant among you will have noted that I'm recording the module name and module record ID on the...

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

    (ie. "seamless integration because our setup is perfect and well thought through" not - note the DBMS is not hugely relevant for the purposes of this article). The end-user must be able to search on EITHER the student's username or the student's ID (2...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  19. Getting the mysql where in delimited string to workhttps://www.joellipman.com/articles/else/database/mysql/getting-the-mysql-where-in-delimited-string-to-work.html

    I have a mySQL database table of room assets that has a field containing the ID numbers of images relevant to this room. The Problem? When I select specifying the statement "WHERE IN (c.RoomImages)", this is interpreted as a string and when converted to...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  20. Delete related records from multiple tableshttps://www.joellipman.com/articles/else/database/mysql/delete-related-records-from-multiple-tables.html

    '2013-02-01 00:00:00' -- Deletes all sessions dated after February 1st 2013 -- and all related records (linked by ID) in relevant tables. Delete from specific tables but not all Simply don't refer to the table after the DELETE clause. Rather...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
Results 1 - 20 of 25