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

  1. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines)https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-handle-commas-between-quotes-in-a-csv.html

    (string delimited by commas) l_StringParts = v_FormattedString.toList(); // show me column 3 with myspecialcomma replaced back to a comma info l_StringParts.get(2).replaceAll("|mySpecialComma|", ",", true); // yields: Flat 8, House Corner The long...

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

    using CSS? It looks beautiful on ZohoCreator pages but then you hit the PDF button and it pretty much vomits your output back to the 90s. The code snippet below is just for a standard template with a modern design. How? Ok, admittedly, when first...

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

    will complete, and the ones that other recipients will complete Send it for your end-user to complete and sign it This comes back to a section called "ZohoSign Documents", download the attachment Go back to the contact record, and upload the file to the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  4. Basic Joomla 2.5 Mootools Formhttps://www.joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

    examples across the web. All I wanted was a basic example to show me how to send a form asynchronously (ie. running in the background without loading a new page). How? This form is more AJ than AJAX as I don't even use an XML file. You'll need to create...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  5. What's the problem? Amusing computer issueshttps://www.joellipman.com/articles/cms/website-development/whats-the-problem-amusing-computer-reports.html

    was on IE7, while their designer was on an Apple Mac using Safari, and a third was using Mozilla Firefox. We told them to go back to the template providers and report the same problem to them...??? Staff member requiring access to a secure application...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  6. Inline Labels in Form Fields using Javascripthttps://www.joellipman.com/articles/cms/website-development/js/inline-labels-in-form-fields-using-javascript.html

    JQuery or Mootools but most of these will not work in Internet Explorer 7 which is unfortunately still in use. I needed a back-to-basics solution and this is the one I have used since my fad of JavaScript 1.2 in the 90s. For broader compatibility, this...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: en-GB
  7. Slideshow div layer through a windowhttps://www.joellipman.com/articles/cms/website-development/mootools/slideshow-div-layer-through-a-window.html

    a dynamic showcase slideshow. Using MooTools it's also proven to be responsive and compatible with smartphones.(Like Flash back in the days of Macromedia Flash :c) and works with apple macs!). The HTML Slide #1 Slide #2 Next Slide The CSS...

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

    fields panel) Untick the filter that is not in alphabetical order Click on the Refresh button Re-Tick the filter to add it back to the report Move this added field to the Report Filter section (click on it and select "Move to Report Filter") Advanced...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  9. Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/component/content/article/joel-s-guide-to-midjourney-prompts.html?catid=115&Itemid=165

    (or Meditation Pose) Crossed Arms Dynamic Pose Facing the Camera Hand on Chin Hands on Hips K-Shape Pose Leaning Back Odalisque Pose S-Shape Pose Sitting With their Back to the camera Period / Age in the year «Year» 60s 90s Autumn during the Dark Ages...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
  10. The greatest invention in IThttps://www.joellipman.com/component/content/article/the-greatest-invention-in-it.html?catid=116&Itemid=165

    research report by Lance A. Miller and John C. Thomas of IBM, noted that "It would be quite useful to permit users to 'take back' at least the immediately preceding command (by issuing some special 'undo' command)." Source: Behavioral Issues in the Use...

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

    it should be ok. Output names for the thumbnails follow the same restrictions as the MS Windows filesystem (so no colons, back/forward slashes, etc). If there is nothing specified, it will name it something like "000065.bmp". Do not include the file...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  12. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile)https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-using-a-function-for-validation-rules.html

    The client wanted that if the status had changed to something else, the first-line agent would not be allowed to set it back to "New Lead". Automations and workflows could however (run as Administrators). Mapping a dependency field didn't fit the bill...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  13. Zoho CRM & Creator: Download attachment and upload to Creator file fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-creator-download-attachment-and-upload-to-creator-file-field.html

    The complication here is that the user can use the Creator form to add a new attachment that will eventually be uploaded back to CRM. How? At time of print, things have moved on and based on the Zoho official forums, this used to be a daunting task. Not...

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

    profile(s) that will have access to this button and click on Save Go to a CRM account record and test the button works. Go back to your Zoho CRM function and simply include HTML and CSS in the output of the function... done. What we're here for The...

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

    CASE p."Title" WHEN 'DEMOGRAPHICS' THEN 2 WHEN 'AWARENESS' THEN 3 WHEN 'ENGAGEMENT' THEN 4 WHEN 'SATISFACTION & FEEDBACK' THEN 5 WHEN 'USABILITY' THEN 6 WHEN 'FEATURES' THEN 7 WHEN 'PRICING' THEN 8 WHEN 'SUPPORT' THEN 9 WHEN 'TRUST' THEN 10 WHEN...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  16. Zoho Deluge - Multi-line Variable Assignments and Expressionshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-multi-line-statements-using-semi-colon-termination.html

    while writing or reviewing code. Do bear in mind that once the script is saved and re-opened, the code will be reformatted back onto a single line. How? Below are three examples demonstrating multi-line assignments in Zoho Deluge. 1) Multi-line string...

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

    will pick this up when you install it via the Administration Control Panel (ACP)... But for us, it wasn't that easy. Make a backup of your /phpBB3/styles folder. Make a copy of your /phpBB3/styles/prosilver folder You need to copy any files from your...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  18. Keyboard and mouse shortcuts in Google Chromehttps://www.joellipman.com/component/content/article/keyboard-and-mouse-shortcuts-in-google-chrome.html?catid=61&Itemid=165

    Ctrl and click a link. Or click a link with your middle mouse button (or mousewheel). Opens the link in a new tab in the background . Press Ctrl+Shift and click a link. Or press Shift and click a link with your middle mouse button (or mousewheel). Opens...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  19. SSRS Hide results table if emptyhttps://www.joellipman.com/component/content/article/ssrs-hide-results-table-if-empty.html?catid=75&Itemid=165

    call on the sum of these, I can check if zero rows were returned because Sum(Fields!Counter.Value, "Equipment") should come back as zero. MDX Expression: One final and a little confusing tweak to make it all work! Where "Equipment" is the name of the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  20. MySQL: Find records in one table that are not in another.https://www.joellipman.com/articles/else/database/mysql/mysql-find-records-in-one-table-that-are-not-in-another.html

    not. The What I'm going to run these benchmark tests against a system that is both up and running via the front-end and back-end. It's MediaWiki CMS used by Wikipedia.org and the like. I like queries against this database because it involves linking a...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
Results 1 - 20 of 82