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

  1. Zoho Deluge: Calculate start and end of Daylight Savings Timehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-calculate-start-and-end-of-daylight-savings-time.html

    An article to document how I calculated the start and end dates of when Daylight Savings Time is in effect. Why? Admittedly, most of Zoho apps have this built-in but here's some snippets of code in case you need them. How? I will use this to amend and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  2. ZohoCRM: Template: not being able to edit a text boxhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-template-not-being-able-to-edit-a-text-box.html

    a bit of an odd article with not 100% certainty on what the cause/outcome would be for your case but worked for us. This documents the steps taken to edit/modify the header on a sales order inventory template. Why? A client raised an issue that they had...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  3. 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: *
  4. Zoho CRM: searchRecords with sorted resultshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-searchrecords-with-sorted-results.html

    This is an article to document how to use the searchRecords function in CRM and to sort the results response. Why? This is unclear and not always working as coded below since each system (CRM, Creator, Books) seems to interpret this sorting feature...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  5. Zoho Inventory: Mark a package slip as delivered and shippedhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory/zoho-inventory-mark-a-package-slip-as-delivered-and-shipped.html

    shipped and delivered in Zoho Inventory. Why? As usual, any task like this that takes me longer than an hour, I'd like to document for future use. The use-case is the client has their own delivery drivers and want them to mark a sales order & package as...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Inventory
    • Language: *
  6. Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

    There are already articles out there that document this but I use this more and more and would rather just find it on my site than going through multiple bookmarks. Why? This use-case is for a customer who simply wanted a quote template to be rendered...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • 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

    A quick article to document 2 features in deluge code: a 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  8. Zoho Workdrive: Getting Team Folder IDhttps://www.joellipman.com/articles/crm/zoho/zoho-workdrive/zoho-workdrive-getting-team-folder-id.html

    This is an article to document how to get your team folder ID, retrieve information about it, and upload to it via the API. Why? The documentation is there but making sense of it, is somewhat difficult, at least for me. How? So when I was trying this, I...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Workdrive
    • Language: *
  9. Zoho Deluge: Convert Hex to RGBhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-convert-hex-to-rgb.html

    A quick article to document a Zoho Deluge function converting a hexadecimal color reference to a Red Green Blue value (RGB). Why? It's likely that Zoho will avail their color picker at some point as an input but at the time of print, this hasn't...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  10. Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

    ]; info r_UpdateContact; // // now need to query to get the preview URLs needed to merge images into writer documents v_PreviewID = ""; r_ContactDetailsAgain = invokeurl [ url :v_Endpoint3 type :GET connection:"zcrm" ]; l_ResponseData =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  11. Zoho Deluge - MD5 functionhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-md5-function.html

    article on how to create a MD5 function for an ETag in Zoho Deluge as I expected it would be. At time of print, the Zoho documentation (and Google search results) make no mention of using MD5 in an encryption task. Why? I'm trying to create an ETag for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  12. 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

    name in the description field How? Because my head is a little fried, I'm putting the two functions I used here and I'll document further if I remember. Note that the pre-amble is to generate a Xero access token which I documented in another article -...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  13. Applying a button and centering it in the RocketTheme Affinity templatehttps://www.joellipman.com/articles/cms/joomla/applying-a-button-and-centering-it-in-the-rockettheme-affinity-template.html

    This took me a while to do so I thought I'd document it for future reference. The Issue See the restore default setting link at the bottom of this page in the footer? I wanted to put one of the styled buttons behind it but then found that there's a lot...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  14. Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

    I went through rocketheme's instructions once and it didn't work. I then carried out all the changes going up and down the document, double-checking I had done everything their instructions said. For demonstration purposes: I am installing phpBB3 on a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  15. Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

    This is an article to document the migration of a Joomla! CMS running version 2.5.11 to an instance of Joomla! CMS version 3.4.1. I would consider the below instructions an ALPHA version as it is considered unstable for official use... Saying that this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  16. MacOs: Transcribe Training Video using OpenAI Whisperhttps://www.joellipman.com/component/content/article/macos-transcribe-training-video-using-openai-whisper.html?catid=60&Itemid=165

    Just noted this down in case I need to do it again. This article documents how to take a 5.5 hour video (MP4) and have it transcribed by a locally installed AI on a MacOS (running Sequoia 15.1.1). Why? Needed for training videos as a follow-on from my...

    • Type: Article
    • Author: Joel Lipman
    • Category: Apple
    • Language: *
  17. Android Java: Remove first two entries from Google News feed in SimpleRssReaderhttps://www.joellipman.com/articles/else/app-dev/android-os/android-java-remove-first-two-entries-from-google-news-feed-in-simplerssreader.html

    I adapted this to read a google news rss feed and the first two entries are " - Google News", everytime. This article documents what I did to fix it. How? Basic to some but I'm new to the game. I'm trying to remove the first two entries from a news feed...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  18. URL passed settings in Reporting Serviceshttps://www.joellipman.com/component/content/article/url-passed-settings-in-reporting-services.html?catid=75&Itemid=165

    &rc:Zoom=100% Note: Where 100% can be page width in percent or whole page. To show/hide the document map (default is true) http:///ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render &rc:DocMap=True Specify a...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  19. Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/component/content/article/returning-oracle-stored-procedure-resultset-in-ssrs.html?catid=75&Itemid=165

    (SSRS). Well "non-productive" more than "fun" as most of the examples on the net are either half-complete or partially documented. So here goes... Using Business Intelligence Development Studio v2008 (BIDS) SQL Server Reporting Services v2008 R2 (SSRS)...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  20. MySQL: Count occurrences of words in a columnhttps://www.joellipman.com/articles/else/database/mysql/mysql-count-occurrences-of-words-in-a-column.html

    This is an article to document how to output the most frequently used words in a MySQL database column. How? Note this only applies to MySQL. So the following query will return a count of each word in your database column by order of most used first...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
Results 41 - 60 of 69