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

  1. Zoho Analytics: Determine profits from invoices and purchase ordershttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-determine-profits-from-invoices-and-purchase-orders.html

    Total excl Tax") AS "PO Total excl Tax", SUM(invsopoitm."PO Total incl Tax") AS "PO Total incl Tax", (MAX(if_null(t2."Credit Margin excl Tax", 0)) / MAX(t3."InvCount")) AS "Credit Margin excl Tax", (MAX(if_null(t2."Credit Margin incl Tax", 0)) /...

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

    your staff a ton of time per week! What your staff see: How? So we're going to create a button. Let's use the example of a credit application you want to send to your customer, and when they complete it, the PDF version gets attached to their contact...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  3. Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

    I want our sales team to be able to click on a button off the CRM account record which will call an API returning all the credit information about a company. Unfortunately, if you do this simply using Zoho Deluge in a button, there are no new...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  4. Terms & Conditionshttps://www.joellipman.com/component/content/article/terms-conditions.html?catid=50&Itemid=165

    either version 3 of the License, or (at your option) any later version. You are to maintain copyright information where credit is due. The scripts and programs are distributed in the hope that they will be useful, but WITHOUT ANY WARRANTY; without even...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  5. Joe's Unduplicater (JUD)https://www.joellipman.com/component/content/article/joes-unduplicater.html?catid=53&Itemid=165

    scripts are offered freely and in good faith. Please do not pass this off as your own work or try to sell it without due credit. Check back with us at joellipman.com for updates/fixes. If you want more support/work done to it, you could consider a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  6. Joe's CSV Chart Generator (JCG)https://www.joellipman.com/component/content/article/joellipmans-csv-chart-generator.html?catid=53&Itemid=165

    scripts are offered freely and in good faith. Please do not pass this off as your own work or try to sell it without due credit. Check back with us at joellipman.com for updates/fixes. If you want more support/work done to it, you could consider a...

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

    have Windows XP, it's likely you have it anyway. Open Source: Open to view/modify the source code as long as you attribute credit where it's due. License is GNU General Public License v3 (www.opensource.org/licenses/GPL-3.0). FREE / Gratis Did I not...

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

    PHP script was only tested using PHP version 8.x so I can't say whether it will work for previous versions. I cannot take credit for this script, as I asked OpenAI's ChatGPT to write it initially, and to build upon it as I kept moving the goal posts,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  9. SSIS Skip Rows in Excel Source filehttps://www.joellipman.com/component/content/article/ssis-skip-rows-in-excel-source-file.html?catid=74&Itemid=165

    opinions vary between "Microsoft Certified Professionals", just a piece of paper and proof you're good at theory IMO, no credit for being the tape monkey that does all the actual work.

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  10. Apple Magic Trackpad with Windows 11 Intelhttps://www.joellipman.com/component/content/article/apple-magic-trackpad-with-windows-11-intel.html?catid=80&Itemid=165

    for this was all in one YouTube video by LinxHype (https://www.youtube.com/watch?v=J_z9-rE_6zI) so I don't want to take credit for it. There were other videos using the GitHub repo: GitHub / imbushuo / mac-precision-touchpad but those instructions...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  11. Webdeveloper-Speakhttps://www.joellipman.com/articles/cms/website-development/webdeveloper-speak.html

    another site but I came across it and rather than just add it to my weblinks section, I thought I'd give it a little more credit. "Motive is a web design and development agency based in Wellington, New Zealand providing consultation, website design,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  12. Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://www.joellipman.com/component/content/article/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html?catid=110&Itemid=165

    application, there are no extra options or dialogs to select. The export had to work from this point on. I can't take any credit for the below as it was copied from http://hosteddocs.ittoolbox.com/ST030504.pdf. A "Crystal Decisions" documentation. Blank...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: *
  13. Is it a scam? Gumtree.com's warning signshttps://www.joellipman.com/component/content/article/is-it-a-scam-gumtreecoms-warning-signs.html?catid=116&Itemid=165

    be followed. An email allegedly from «CompanyName» (or another company) asking for your personal details - logins/passwords/credit card details. You get an email that claims to be from «CompanyName» or another company and requests that you reply or...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  14. Zoho Deluge - Regex to Strip all non-numeric charactershttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-regex-to-strip-all-non-numeric-characters.html

    non-numeric characters (all non-digits) from a string. Why? I only want the digits/numbers from a string: v_PaymentTerms = "Credit Note - 30 Days"; // we want the 30 from the above string How? I'm aware of the getAlphaNumeric() function in Zoho and I...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  15. Prices get rounded up in Virtuemarthttps://www.joellipman.com/articles/else/e-commerce/virtuemart/prices-get-rounded-up-in-virtuemart.html

    float/decimal and were rounded up to the nearest integer... At first we thought this was due to installing a Virtuemart UK Credit Card Payment Module (vm-ukcreditcard). A lot of forums were suggesting to change the number_format to convert any number to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Virtuemart
    • Language: *
Results 1 - 15 of 15