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

  1. Performance Report - Background colors based on dataset valueshttp://www.joellipman.com/articles/microsoft/ssrs/green-red-background-colors-based-on-dataset-values.html

    I was able to measure with the default installation are the times taken for "data retrieval", "processing", "rendering", and then the totals of these. I haven't Googled this at the time of print so there may be a million better solutions out there, this...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  2. Hide a Drive per User in Windows 7http://www.joellipman.com/articles/microsoft/windows-os/hide-a-drive-per-user-in-windows-7.html

    applies to the currently logged-in user. To restrict other users, see the example after this one: Open the Start Menu, then type regedit in the search box and press Enter. In regedit, expand to the following key...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  3. Migrating from Joomla 2.5.x to 3.4.xhttp://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

    admin details with old (name, registration date, etc). Copy over Categories: It is recommended to do this via the GUI and then associate the IDs to your content, weblinks, etc. The thing to watch out for is associating the categories with respect to the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  4. Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttp://www.joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

    in turn is used to list files in a team's Google Drive. This is very different to my code for OAuth when attended: Google Authentication - OAuth 2.0 using PHP/cURL... In that this one doesn't prompt for a user. Again this script doesn't need the client...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  5. Zoho Deluge - Get Refresh/Access Token API v2http://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

    you confirm whether your app is allowed to access the data within the specified scope(s). If you run this as a standalone, then this will simply tell you what the link is to go to. Agree and note the code parameter passed in the URL (ie. "&code=...")....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: en-GB
  6. Zoho Deluge: Setup an API Connection for InvokeURLhttp://www.joellipman.com/articles/crm/zoho/zoho-deluge-setup-an-api-connection-for-invokeurl.html

    is using in Zoho, check the domain and specifically the top-level-domain (TLD) part. For example, if it says zoho.com, then this means the US datacenter. If it says zoho.eu, then this is the EU datacenter. If it says zoho.in, then this is the India...

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

    true); // yields: Flat 8, House Corner The long answer is to consider the following code which generates a sample CSV and then loops through storing each row as a data record and outputting it to screen: // generate a sample CSV file v_DataCSV = "1,Joel...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  8. ZohoBooks: Stripe Terminal Integrationhttp://www.joellipman.com/articles/crm/zoho/zohobooks-stripe-terminal-integration.html

    a deposit or instalment. How? I won't go in to how to create a button in ZohoBooks but you simply add it to the invoice and then when it prompts for some code, you give it the snippet below. The Magic You would create a button for each terminal /*...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  9. Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkithttp://www.joellipman.com/articles/crm/zoho/zoho-email-deliverability-spf-dkim-dmarc-toolkit.html

    for a customer: https://zohomail.tools/#runChecks. How? So first I'll outline the steps to set this up in ZohoCRM and then how to troubleshoot issues with this. One important thing to note is that the setup needs to be done by whoever manages the domain...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  10. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttp://www.joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

    up when a lead is created and not converted within 1 day send an email and notification to sales person everyday for 3 days then escalate to a specified user". Why? Sorry Zoho! I tried using the interface to set up a workflow or any other mechanisms...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  11. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Templatehttp://www.joellipman.com/articles/crm/zoho/zoho-books-estimates-quotes-accept-decline-buttons-on-template.html

    or decline a quote. Sure there's a portal and you can probably do it from there but this is a one-click accept or decline then done. One of the biggest hurdles here, which may sound trivial, was the response when an end customer clicks on either the...

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

    created widget.html file in your code editor add the code as per the below generic script when done, save 'widget.html' then return to terminal and type zet validate and then type zet pack this will create a zip file in a dist folder Login to ZohoCRM as...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  13. Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttp://www.joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

    new.`images` = JSON_SET( COALESCE(new.`images`, '{}'), '$.image_intro', JSON_EXTRACT( CASE WHEN JSON_VALID(old.`attribs`) THEN old.`attribs` ELSE '{}' END, '$.spfeatured_image' ), '$.image_intro_alt', JSON_EXTRACT( CASE WHEN JSON_VALID(old.`attribs`)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  14. Tagliatelle alla Carbonarahttp://www.joellipman.com/articles/_other-misc/tagliatelle-alla-carbonara.html

    Add two-thirds of the prosciutto and fry for one minute. 2. Add 50g/2oz of the butter to the pan and allow to melt, then add the wine and simmer for 2-3 minutes, just to combine with the butter and the prosciutto juices. 3. Place the egg yolks, parmesan...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *
  15. Database Error: Unable to connect to the database: Could not connect to MySQLhttp://www.joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

    and the problem is the number of MYSQL database queries. It goes up to about 200,000 in the first few minutes of use and then after that every page load is a few hundred to few thousand queries (per page). The webserver limits me to 50,000 queries an...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  16. Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttp://www.joellipman.com/articles/microsoft/excel/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html

    guideline(s). Set the object’s size and position by right-clicking the field, selecting Object Size and Position and then setting the XY coordinates. Use the horizontal and vertical rulers as a reference when specifying height, width, and XY...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: *
  17. Licence GNU/GPLhttp://www.joellipman.com/static-items/licence-gnugpl.html

    any patent licenses granted under the third paragraph of section 11). However, if you cease all violation of this License, then your license from a particular copyright holder is reinstated (a) provisionally, unless and until the copyright holder...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  18. Registered Users Cannot Login - Super Users Canhttp://www.joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

    could login. However set the same test account to a "Super User" and they would be able to login. Was the problem authentication? Restricted access to a component? A load of blab on ACL managers? How? In our case, the website had recently been migrated...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  19. Zoho Deluge - First Monday of Month or Last Tuesday of Monthhttp://www.joellipman.com/articles/crm/zoho/zoho-deluge-first-monday-of-month-or-last-tuesday-of-month.html

    of the current/next month. What I mean by the last Tuesday is if the last Tuesday of the month is before the current date, then set it to the last Tuesday of next month. Why? This was a request by a client who instead of specifying the 1st of every...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: en-GB
  20. Zoho CRM/Creator - Common Errors & Gotchashttp://www.joellipman.com/articles/crm/zoho/zoho-crm-creator-common-errors-gotchas.html

    Login to ZohoCRM as Administrator > Setup > Developer Space > Connections > Add Connection > Give it a name and then select Scopes > and get ERROR_invalid_operation_type Solution: Remove some scopes and test. The likely ones you want are:...

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

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Please publish modules in offcanvas position.