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

  1. Zoho Books: Display Sales Order Shipping Address on Package Sliphttps://joellipman.com/articles/crm/zoho/zoho-books/zoho-books-display-sales-order-shipping-address-on-package-slip.html

    by going to Settings > Preferences > Packing Slip Settings > and Enable "Delivery To": Then change the Shipping Address Format either under "Customers and Vendors" (although this applies to all templates) or under the specific template. I wanted to do...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  2. Zoho Analytics: Setup DataSource via FTP Connectionhttps://joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-setup-datasource-via-ftp-connection.html

    then click on "Next": Step 2 of 2: specify whether first row are headers/column/field names. If necessary, specify the format of the data per column (in this example, I highlight the Date column, it then prompted me what format this is in, eg....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  3. ZohoDeluge: Get All eBay Orders Given a From and Till Datehttps://joellipman.com/articles/crm/zoho/zoho-deluge/zohodeluge-get-all-ebay-orders-given-a-from-and-till-date.html

    query all the orders for yesterday without using the eBay GUI Selling website. I've included the code to parse out the information as well. Why? Because I need this function too often either for debugging/monitoring purposes but it's easier to use an...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  4. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://joellipman.com/component/content/article/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html?catid=129&Itemid=165

    and select "Change Data Type" > select under Data Type: "URL" Right-click on the "Image URL" column again and select "Format Column" > Select under Display As: "Image" You can now specify the size of the image as well (16x16 is a tad small). Caveat(s):...

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

    multiple bookmarks. Why? This use-case is for a customer who simply wanted a quote template to be rendered for PDF or print format. I have another article for a different client who wants a pretty advanced HTML template (well it's a HTML table with...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  6. Zoho Analytics: Create a Monitoring System with Imageshttps://joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-create-a-monitoring-system-with-images.html

    a criteria or a value within a data table. As documented in an earlier article, put the URL of the image, then change it's format to show the image and not the URL text. In this example, we are using images uploaded in the Zoho Analytics image library...

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

    - Initial release Date Modified: 2025-09-29 (Joel Lipman) - Deletes existing images in the image upload field More Information: https://help.zoho.com/portal/en/community/topic/export-zoho-analytics-chart-with-api-in-deluge...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  8. Joomla Component: Set default params on installationhttps://joellipman.com/articles/cms/joomla/joomla-component-set-default-params-on-installation.html

    $query->update($db->quoteName('#__extensions')); $defaults = '{"param1":"value1","param2":"value2"}'; // JSON format for the parameters $query->set($db->quoteName('params') . ' = ' . $db->quote($defaults)); $query->where($db->quoteName('name') . ' = '....

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  9. Administrator Program Shortcut without Prompthttps://joellipman.com/component/content/article/administrator-program-shortcut-without-prompt.html?catid=80&Itemid=165

    as Start a program for Program/Script, Specify the command path which is usually %windir%\System32\cmd.exe Add arguments in format /c start "Task Name" "Full Path of Program", for example: /c start "VisualStudio2010" "C:\Program Files\Microsoft Visual...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  10. SQL Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/else/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

    following screenshot is how your report should look now. Result: You can even run/preview it and you should get the below: Formatting In other words, making it look pretty. I'm doing this now because you may not need parameters or events. The above...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  11. Difference between two dates - the midnight hourhttps://joellipman.com/articles/cms/website-development/difference-between-two-dates-the-midnight-hour.html

    date, when one of the hours is on the other side of the midnight hour... Now bear in mind the below is in European date format Consider the following: Date Customer Time From Time To Hours ---------- --------------- --------------- ----------------...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  12. htaccess Rewrites SEF URL and submits to PHPhttps://joellipman.com/articles/cms/website-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

    Note my redirect for errors. Split the first string "myFolder" with the slash (/) as a delimiter, controlling the syntax/format of your site URLs. For Example http://www.mysite.com/blog/videos/2010/january/21.html // sends...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  13. Add attribute xsl:nil=true on empty elements using XSLThttps://joellipman.com/articles/cms/website-development/xml/xslt/add-attribute-xsl-nil-true-on-empty-elements-using-xslt.html

    on point-to-point conversions and strings but what if the value is blank and I try to convert that date of birth from SQL format (yyyy-mm-dd) to European format (dd/mm/yyyy)? See the following: -- assuming value of DATE_OF_BIRTH is blank or null yields...

    • Type: Article
    • Author: Joel Lipman
    • Category: XML Stylesheet Language Transformations
    • Language: *
  14. Submit form as a server and not the client with cURLhttps://joellipman.com/component/content/article/submit-form-as-a-server-and-not-the-client-with-curl.html?catid=109&Itemid=165

    from the third-party service/server/api Script #1: The HTML form: Sender: Receiver: Script #2: Send to third-party in XML format: (because that's the format they accept) Note that in the following example, the XML is sent as a url encoded value paired...

    • Type: Article
    • Author: Joel Lipman
    • Category: API Miscellaneous
    • Language: *
  15. Excel PivotTable Filter List Orderinghttps://joellipman.com/component/content/article/excel-pivottable-filter-list-ordering.html?catid=110&Itemid=165

    "Head" against wall. Bang "Head" against wall. Alternatively Change the SQL query so that the date returns in yyyy-mm-dd format (eg. 2012-03-04) Reverse Dates Order If you have a date filter list and want it sorted in descending order, I would recommend...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  16. Licence GNU/GPLhttps://joellipman.com/component/content/article/licence-gnugpl.html?catid=50&Itemid=165

    or non-consumer uses, unless such uses represent the only significant mode of use of the product. “Installation Information” for a User Product means any methods, procedures, authorization keys, or other information required to install and execute...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  17. MS-DOS: Copy folders without overwriting fileshttps://joellipman.com/component/content/article/ms-dos-copy-folders-without-overwriting-files.html?catid=51&Itemid=165

    c:\Destpath\*.* -- since January 1st 2010 XCOPY /E /D:01-01-2010 c:\Sourcepath\*.* c:\Destpath\*.* // D: is in mm-dd-yyyy format This will copy any files modified since January 1st 2010. If the destination file does not exist, it will copy the original...

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

    files (all legitimately :) and stored them in my music folder. I then run my MP3 software to convert all the files into MP3 format and store these in another folder. I needed a program to: Check the final folder for all the MP3 filenames Check the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  19. Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=53&Itemid=165

    initially takes a picture and saves this as an image file called "lastscreenshot.bmp". It then converts this image into the format with the quality/size that is set in the program options. Consider this file temporary and if you want to delete/rename...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  20. Zoho Deluge - Get English Ordinalhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-english-ordinal.html

    = if(v_ThisDayDateLastChar 20),"st,nd,rd".toList().get(v_ThisDayDateLastChar-1),"th"); // full formal date v_ContractDateFormatted = v_NextRenewalDate.toString("EEEE, d") + v_EnglishOrdinal + " of " + v_NextRenewalDate.toString("MMMM, yyyy"); info...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
Results 41 - 60 of 101