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

  1. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://www.joellipman.com/component/content/article/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html?catid=45&Itemid=165

    Graphics Card to one of the Acer monitors DisplayPort to DVI (had to purchase this cable - twice as 2nd was dual-link and worked, first single-link didn't) to the 2nd Acer monitor. DisplayPort to Mini-DisplayPort: from the Graphics Card DP port to the...

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

    This is 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  3. Zoho Books/Inventory: Trigger a workflow when an invoice has been paidhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-books-inventory-trigger-a-workflow-when-an-invoice-has-been-paid.html

    a function that given an invoice, checks the customer payments and updates the custom fields. Executing the function this worked as expected. Now put it on a workflow where the settings were: When an invoice is "Created or Edited" Execute the workflow...

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

    but those instructions seemed only for those on an AMD or ARM processor. The process demo'd by LinxHype is the one that worked for me. Windows Intel These are the instructions that worked for me so I'm just storing these in case I need to do it again:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  5. Generate a Timesheet in MySQL https://www.joellipman.com/articles/else/database/mysql/generate-a-timesheet-in-mysql.html

    be the latest someone works that day. Time is recorded by tasks with an actual duration in seconds (eg. "Monday morning, I worked 45 minutes on setting up a Joomla 2.5.x demo site; I started at 9am and finished at 9:45.", "Monday morning, I also worked...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  6. Foreign Characters create symbols in PHP and MySQLhttps://www.joellipman.com/articles/cms/website-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

    $my_description = htmlspecialchars($my_description); Did I miss anything? So none of the above worked. If there is another solution out there, I didn't find one that worked otherwise I'd have included it in this article. How? The fix is a PHP one and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  7. Crystal Reports: Exporting to Excel omits column headershttps://www.joellipman.com/component/content/article/crystal-reports-exporting-to-excel-omits-column-headers.html?catid=110&Itemid=165

    following report in design view, only the circled headings would appear on the exported report: The solution I found that worked for me, was to make all the heading boxes the same height and to get rid of all the unnecessary extra gridlines (the ones...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  8. Oracle SQL - Convert given list (CSV) into Rowshttps://www.joellipman.com/articles/else/database/oracle-pl-sql/oracle-sql-convert-given-list-csv-into-rows.html

    a quick note as to something that worked for me. Taken from the Oracle forums @ https://forums.oracle.com/forums/thread.jspa?messageID=6861756 Situation I have one column of values that I've suffixed a comma to but I want to display this as a rows in a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  9. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party APIhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-post-a-multi-dimensional-or-nested-array-to-a-3rd-party-api.html

    Why? This took me several days and in the end only going through various forums and documentation, I found a solution which worked for me. Note that usually I could customize the receiving PHP script to receive a JSON request and process it that way but...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  10. Zoho CRM REST API: Stop Workflow from Triggeringhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-rest-api-stop-workflow-from-triggering.html

    which used up all the API calls. How? You might already be familiar with some of the trigger options below but one that worked was initially guessed as "none" but then later found in the documentation could also be an empty list []. So there are a few...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  11. ZohoCRM: Process all records of a modulehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-process-all-records-of-a-module.html

    each record and mark it so that the process doesn't repeat on records that have already been checked. Some solutions have worked in the past where you could simply add a checkbox and do a search where this value is false; but lately this hasn't been...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  12. Zoho Creator: Receive eBay Order Notifications via Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-receive-ebay-order-notifications-via-webhook.html

    one didn't tell me much first time I ran it but I can use it later on to check if my "setting the notifications" process worked. void API.fn_eBayQuery_GetNotificationPreferences() { /* Function: fn_eBayQuery_GetNotificationPreferences() Purpose:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  13. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeroshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-regex-rounding-and-or-removing-trailing-zeros.html

    going to use loops, then the next best thing I'm aware of is a regular expression. So the first expression I came up with worked to a certain point but didn't round up the numbers, in other words, it didn't remove the unnecessary zeros. Note that in the...

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

    months to find a solution. How? Disclaimer! There may be many ways of doing this, this is just one way that we used that worked for 90% of the invoices. There are invoices that may be associated to sales orders changed after being confirmed or missing...

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

    the client. How? I'm going to split this into 2 code snippets that were in practice added to the same function and that worked at time of print. Note that this uses the old Trading API as the new API is only available in Sandbox??? I won't go into how...

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

    here is that I was generating a comma separated values (CSV) file given some lists and strings and although the same code worked great on one Zoho CRM, another client's ZohoCRM was not accepting "\n" as a new line character and instead would...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  17. Zoho CRM: Change System Field Lengthhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-change-system-field-length.html

    Mapping" page. How? This is a bit of a hack and most likely not recommended... but it is a workaround I have used and that worked when converting a lead to a deal. Note that this hack doesn't work on the system field label name (I tried) just on the...

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

    goal posts, figuratively speaking, and changing the requirements. I am impressed however that every version it iterated, worked exactly as I asked with only 1 error where it mixed a method with a comment but thereafter, a working script every time. The...

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

    prosilver from the "Styles", "Themes", and "Imagesets", my first phpBB3 index page with the affinity template finally worked!!! Chuffed to bits as you might imagine but clicking on any other link returned an error something along the lines of "template...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  20. Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

    deletes the Installation folder. Avoid installing Sample Data if possible (there will be some but this script has been reworked to potentially accommodate). Download my migration script Decide on which script to use: If you have a small site (less than...

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