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

  1. Zoho CRM: Client Script: Swap Quote Account with Deal Lookuphttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-client-script-swap-quote-account-with-deal-lookup.html

    on a small client script to set the Account field on the Quote from a lookup field on the Deal record. Why? The use-case here is that I have a client who is a supplier. The opportunity (aka Deal) will be in the end customer's name so it is their name in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  2. On Gui Resize Eventhttps://www.joellipman.com/component/content/article/on-gui-resize-event.html?catid=48&Itemid=165

    for this solution. In the end, I found it hidden away in the Autohotkey help file and not under the gui events... The issue here is if you want to do something when a user resizes your program. If you search and search, you'll find that GuiClose...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  3. Zoho Deluge - Hide Reset Button on Formhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-hide-reset-button-on-form.html

    This is to hide the reset button on a non-stateless form (state form?). I have posted this on the Zoho forums as well but here goes: Why? Because I can. And because as someone said, a "reset" button is so 1990. I have a confirmation page and don't want...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  4. Zoho Deluge: Push a value to a datetime field in CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-push-a-value-to-a-datetime-field-in-crm.html

    and time to ZohoCRM or ZohoCreator. Why? You may have received an error that goes something like: datatype: datetime How? Here are some formatting examples: Creator to CRM: v_CreatorTime = zoho.currenttime.toTime(); v_CrmTime =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  5. Joomla banners not rotatinghttps://www.joellipman.com/articles/cms/joomla/joomla-banners-not-rotating.html

    The issue here is that you have added all your banners, divided between clients and categories and you're looking for a solution which doesn't involve installing a 3rd party applicatoin. Unfortunately the Joomla banner module only supports alternating...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  6. Link to a Joomla article from within another articlehttps://www.joellipman.com/articles/cms/joomla/link-to-a-joomla-article-from-within-another-article.html

    Quick article here as googling/binging for how to refer to Joomla articles after versions 1.5.x wasn't obvious. This article is to demonstrate how to write the webaddress for a Joomla article even when you have Search-engine-friendly website addresses...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  7. Windows 7 and Google Chrome incognito mode by defaulthttps://www.joellipman.com/component/content/article/windows-7-and-google-chrome-incognito-mode-by-default.html?catid=61&Itemid=165

    shortcut (next to your start button). All the articles I googled were windows vista so I thought I'd share one for windows 7 here. I'm actually only saving you a click as you can just right-click on the google chrome icon and select "New Incognito...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  8. SSRS Expand specific drilldown by defaulthttps://www.joellipman.com/component/content/article/ssrs-expand-specific-drilldown-by-default.html?catid=75&Itemid=165

    thought I'd put something here as there are lots of posts like this on forums (a lot of which seem to be copied & pasted from other sites) but they refer to SQL Server 2000 or SQL Server 2005. This is how to do it in SQL Server 2008 and creating a...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  9. SSRS Subscriptions cannot be createdhttps://www.joellipman.com/component/content/article/ssrs-subscriptions-cannot-be-created.html?catid=75&Itemid=165

    Images don't display. The answer to this error is your report needs to use a datasource with the credentials stored, here are the details to our report As developers, we connect to the datasource directly using our Windows Credentials. For the SSRS...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  10. MySQL Group_concat equivalent in T-SQL and Oraclehttps://www.joellipman.com/articles/else/database/mysql-groupconcat-equivalent-in-t-sql-and-oracle.html

    myself doing any other job and it beats daytime television any day. I use this quite a lot so I thought I'd put an article here somewhere. Based on the following concept: RowID column_to_return_as_string --------- -------------------------- 1 Me 2...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  11. Select unique values in Microsoft Excel columnhttps://www.joellipman.com/component/content/article/select-distinct-values-in-microsoft-excel-column.html?catid=110&Itemid=165

    I'd put a quick note here, I tried a fair few solutions that didn't work and then found this hidden away in a forum: Quick Count =INT(SUMPRODUCT((A3:A1000"")/COUNTIF(A3:A1000,A3:A1000&""))) This returns the number of unique values in the range A3 to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  12. DJI Phantom FC40 - First Flighthttps://www.joellipman.com/component/content/article/dji-phantom-fc40-first-flight.html?catid=113&Itemid=165

    which I'll try to transfer my Joomla videos over to but in the meantime you can be subjected to my quadcopter videos. Here are a few quick ones, the Hubsan H107C and its Q4 Nano, then the DJI Phantom. First up, the Hubsan X4 H107C for $60 USD filming at...

    • Type: Article
    • Author: Joel Lipman
    • Category: Quadcopters
    • Language: *
  13. Splatter Logohttps://www.joellipman.com/component/content/article/splatter-logo.html?catid=115&Itemid=165

    I saw this article and rather than bookmark it I thought I could just have it here for easy reference. It was written for Photoshop but I use Paint Shop Pro and felt I could do the same. It's just so complicated in Photoshop when web-developers need to...

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

    This happened to a m8s website in VirtueMart 1.1.3. The issue here was that although all the prices lost their float/decimal and were rounded up to the nearest integer... At first we thought this was due to installing a Virtuemart UK Credit Card...

    • Type: Article
    • Author: Joel Lipman
    • Category: Virtuemart
    • Language: *
Results 181 - 194 of 194