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

  1. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://www.joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

    attachments Create an Excel spreadsheet or CSV file with the headers: Ticket ID, Attachment ID, Image URL, Created Time, Modified Time Add a dummy row with data that is expected to be in the rows (ZohoAnalytics may have issues loading a file with only...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  2. MediaWiki: MySQL to extract path to imageshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-mysql-to-extract-path-to-images.html

    MediaWiki CMS system (v1.14). Why? Prior to a migration and just after another change freeze, I had sent all Wiki articles modified since the last export but then needed to send all images that had also been either added/modified since. How? Using...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  3. ZohoCRM GetRelatedRecords INVALID_DATAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-getrelatedrecords-invalid_data.html

    cancel its related sales orders. Inputs: - Outputs: - Date Created: 2025-01-30 (Joel Lipman) - Initial release Date Modified: ??? ??? More Information: Custom View ID: 123456000012345678...

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

    $query->from($db->quoteName('#__users')); $query->where($db->quoteName('user_id') . '=42'); $query->order('date_modified ASC'); -- note the only semi-colon at the end of the statement $query->select($db->quoteName(array('user_id', 'user_name')))...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  5. Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

    Feed for the past day: earthquake.usgs.gov/earthquakes/feed/geojsonp/2.5/day Flight Regulations API v0.9 version 0.9: Last Modified 2014-11-05 12:08:42 ccTLD is assigned from an entry within searched location (db must return at least 1 zone to know what...

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

    = false; Setup a scheduled task in Creator Schedules > New Workflow Choose a Date Field Start Date: select form and choose Modified_Time Run this process on condition "Attached Files in CRM equals false" Execute Workflow "After 2 Minutes" Repeat...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  7. Zoho CRM: Update a custom field in line items / product details using REST API v2.1https://www.joellipman.com/articles/crm/zoho/zoho-crm-update-a-custom-field-in-line-items-product-details.html

    [] } Reading a Response The response on success would be something like: { "data": [ { "code": "SUCCESS", "details": { "Modified_Time": "2021-05-17T11:02:59+01:00", "Modified_By": { "name": "Joel Admin", "id": "123456" }, "Created_Time":...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  8. Zoho Recruit: Rollup Number of Recruit Candidates to CRM Accounthttps://www.joellipman.com/articles/crm/zoho/zoho-recruit-rollup-number-of-recruit-candidates-to-crm-account.html

    to note down some code used in Zoho Recruit. This particular bit of code will run on a workflow when a Candidate is modified, and it tallies all the candidates belonging to the same school and updates some number fields on the matched CRM account. Why?...

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

    person against the record: SELECT DISTINCT c."Customer ID" AS "Customer ID", c."Customer Name" AS "Customer Name", c."Last Modified Time" AS "Customer Last Modified", c."Customer Sub Type" AS "Customer Type", if_null(c."Account Owner", c."Created By")...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  10. ZohoBooks: Stripe Terminal Integrationhttps://www.joellipman.com/articles/crm/zoho/zohobooks-stripe-terminal-integration.html

    Created: 2023-02-24 - Initial release - Reads Books Invoice and sends the amount to the reader for a payment atempt Date Modified: 2023-02-24 (Joel Lipman) - If custom field "Amount To Be Taken" is not greater than zero, then defaults to balance due of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  11. Zoho Deluge: Get All Orders from eBayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-all-orders-from-ebay.html

    Purpose: Queries eBay for all orders for a specified year Date Created: 2023-03-29 (Joel Lipman) - Initial release Date Modified: 2023-03-29 (Joel Lipman) - Added in ability to list errors and query order line item IDs (ErrCode: 21917182) - Modified to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  12. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://www.joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

    Date Created: 2023-12-05 (Joel Lipman) - Initial release - Uploads an image to workdrive and returns the public link Date Modified: ??? - ??? ttps://workdrive.zoho.com/apidocs/v1/filefoldersharing/shareeveryone...

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

    String crmAPIResponse Date Created: 2022-01-17 (Joel Lipman) - Initial release - Forwards webhook to Zoho Creator Date Modified: 2024-04-22 (Joel Lipman) - Minimized amount of processing to simply storing the record in Zoho - Run HMAC SHA 256...

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

    or final balance invoice Inputs: string value Outputs: - Date Created: 2025-03-31 (Joel Lipman) - Initial release Date Modified: ??? - ??? More Information: Any information that may help...

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

    id Inputs: Deal Record ID Outputs: the value of the pipeline Date Created: 2025-05-06 (Joel Lipman) - Initial release Date Modified: ??? - ??? ******************************************************************************* */ v_Pipeline = "";...

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

    from Xero and pull them into ZohoCRM Inputs: - Outputs: - Date Created: 2025-10-08 (Joel Lipman) - Initial release Date Modified: 2025-10-13 ( Joel Lipman) - Parsing Xero Dates and Times to include timezone of Xero instance for accurate time comparisons...

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

    used to map Xero tax rates to Zoho ones Inputs: - Outputs: - Date Created: 2025-10-13 (Joel Lipman) - Initial release Date Modified: ??? - ??? More Information: Ensure that all possible tax rates in Xero match those in Zoho; the output of this function...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  18. Oracle: order by subquery missing right parenthesishttps://www.joellipman.com/articles/database/pl-sql/oracle-order-by-subquery-missing-right-parenthesis.html

    pa where pa.type = 'USER' AND pa.code = 'SPECIAL1' pa.person_reference = ps.person_reference order by pa.last_modified_date desc ) FROM Person_Staff ps -- In oracle, yields "missing parenthesis" error. So you can see my parentheses are fine. Working...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: *
  19. Change default order of weblinkshttps://www.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

    don't description - not recommended! date - the one I use for most recent created - this is also a date formatted field modified - and this is a date formatted field hits - number of times that weblink has been visited state - this is the J16...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  20. Joes Quicklist Weblinks (JQW)https://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

    to generate new thumbnails USED TO BE Administrators or Super Admins/Users. Due to several requests, the module has been modified to accommodate any Joomla! group (specified in the parameters). It is NOT RECOMMENDED to set this to normal users as this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
Results 21 - 40 of 71

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.