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

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

    out-of-the-box PNL report that comes with Zoho Books. We needed a dataset that took into account "Delivery" as a separate line item on the purchase order. I'm writing this article as it had gone through several partners before us and even Zoho...

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

    This is a quick article documenting how to update custom fields in a line items or product details section of a transactional module such as Quotes, Sales Orders or Invoices using code: Zoho Deluge. Why? At time of print, Zoho had recently introduced...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  3. Prefix Line Numbers in a Text Filehttps://joellipman.com/articles/automation/ms-dos/prefix-line-numbers-to-a-text-file.html

    Prefixing lines with their respective line number in a text file using a Microsoft Windows Operating System... I've just googled this as I couldn't remember how I did this last time and a number of people showing off their MS-DOS batch skills have...

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

    all the keys in a Zoho Creator form (I call mine "API Integration") ready with the following fields: Connection Name (Single Line) Dev ID (Single Line) Client ID (Single Line) Shop ID (Single Line) Client Secret (Single Line) Location ID (Single Line)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. Zoho CRM: Updating a CRM record Custom Line Items using API v7https://joellipman.com/articles/crm/zoho/zoho-crm-updating-a-crm-record-using-api-v7.html

    or update a record using invokeUrl. Why? Because my designers keep including custom fields in their transactional modules line items (quotes, sales orders, invoices, purchase orders). The only way to update these are by using the API and deluge function...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  6. Zoho Deluge: Associate/Link an Invoice to a Sales Orderhttps://joellipman.com/articles/crm/zoho/zoho-deluge-associate-link-an-invoice-to-a-sales-order.html

    the same time. How? Through sweat and perseverance. The trick is to update both the sales order id and to update the invoice line items with their respective sales order item id value. For our client's purpose, we are running a custom function off the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  7. Regular Expression Basic Usage Exampleshttps://joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

    a repeated string without knowing the actual string ahead of time. For example, the regular expression: ^(.*)\1$ matches a line consisting of two adjacent appearances of the same string. Escape Character Use the escape character '\' to search for a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  8. Zoho Deluge - Modify the product line items in an invoice modulehttps://joellipman.com/articles/crm/zoho/zoho-deluge-modify-the-product-line-items-in-an-invoice-module.html

    field of an invoice record seems straightforward but it isn't. Undocumented, the trick is to remove the existing ID of the line item and posting the map back to the record. In the following example, we are swapping out the product "123456789012345678"...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  9. Zoho CRM: Template: Empty Space between Header and Line Itemshttps://joellipman.com/articles/crm/zoho/zoho-crm-template-empty-space-between-header-and-line-items.html

    A very quick article on how to deal with an issue where a CRM template has been used and where the table of line items appears on a separate page (and to remind me of the CSS to fix this). Why? By default / out-of-the-box / vanilla, in a Zoho CRM...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  10. ZohoDeluge: Inserting a new line character in a CSVhttps://joellipman.com/articles/crm/zoho/zohodeluge-inserting-a-new-line-character-in-a-csv.html

    A super quick article on something that almost deserves its own article: using new lines in ZohoDeluge. Why? My use-case here is that I was generating a comma separated values (CSV) file given some lists and strings and although the same code worked...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  11. List all cron jobs for all usershttps://joellipman.com/articles/linux/list-all-cron-jobs-for-all-users.html

    CRONDIR='/etc/cron.d' # Single tab character. Annoyingly necessary. tab=$(echo -en "\t") # Given a stream of crontab lines, exclude non-cron job lines, replace # whitespace characters with a single space, and remove any spaces from the # beginning of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Linux
    • Language: *
  12. Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

    an extension (Quicklist Weblinks) I wrote for an OpenSource CMS. Could also be of some use if your portfolio is a bunch of online websites and you need screenshots of these. Whatever the reason, I needed a FREE option and everything available had a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  13. Zoho Creator: Add a subform while creating a recordhttps://joellipman.com/articles/crm/zoho/zoho-creator-add-a-subform-while-creating-a-record.html

    Why? The use case here is for a Quote Builder in Zoho Creator: Create a quote record and include a subform containing the line items. You may have tried code where you add a record first and then add the subform afterwards (insert into [...]) but it can...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines)https://joellipman.com/articles/crm/zoho/zoho-deluge-handle-commas-between-quotes-in-a-csv.html

    how to handle commas in a CSV file that were enclosed between two double-quotes. I've added to this the handling of new lines or carriage returns in between a pair of double-quotes. Why? Our use case is that we were trying to loop through rows of a CSV...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  15. Vertically align an asterisk on a linehttps://joellipman.com/articles/web-development/css/vertically-align-an-asterisk-on-a-line.html

    as the numbers but not overlap any list item beneath it. By increasing the size of the asterisk, this often increases the line-height and causes the overall line height to change for other objects in the same row. The problem afterwards was that the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *
  16. Invalid arguments passed in router.php on line 325https://joellipman.com/articles/cms/joomla/invalid-arguments-passed-in-routerphp-on-line-325.html

    in a menu: Warning: implode() [function.implode]: Invalid arguments passed in /home/.../public_html/includes/router.php on line 325 Where "..." is the path on your server. If you're writing a component, then ask yourself if you really need the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  17. JComments errors in PHP 7: plgContentJComments and JCommentsACLhttps://joellipman.com/articles/cms/joomla/jcomments-errors-in-php-7.html

    in a future version of PHP; plgContentJComments has a deprecated constructor in /plugins/content/jcomments/jcomments.php on line 25 Fix: // change on line 27 function plgContentJComments(&$subject, $config) // to function __construct(&$subject, $config)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  18. K2 Items disappearhttps://joellipman.com/articles/cms/joomla/k2-items-disappear.html

    Invalid argument supplied for foreach() in /home/public_html/administrator/components/com_k2/views/items/tmpl/default.php on line 80 If I went to K2 Comments, I'd get an additional error: Warning: Invalid argument supplied for foreach() in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  19. SSIS Skip Blank Rows in Flat File Sourcehttps://joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

    many sites was happening to me when I had blank rows in a flat file, where it appeared to add the special carriage return or line feed characters to the next viable row, see my original data file here (sample data): And this is what a Data Viewer...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  20. JComments 2.3.0 with ReCaptcha in Joomla 2.5.xhttps://joellipman.com/articles/cms/joomla/jcomments-2-3-0-with-recaptcha-in-joomla-2-5-x.html

    Joomla 2.5.x systems will not have updated this: Open the file \plugins\captcha\recaptcha\recaptcha.php See if you have the line const RECAPTCHA_API_SERVER = "http://api.recaptcha.net"; If you do, change it to const RECAPTCHA_API_SERVER =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
Results 1 - 20 of 119

Please publish modules in offcanvas position.