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

  1. Zoho Webhooks & Shopify API: Keep Disappearinghttps://www.joellipman.com/articles/else/e-commerce/shopify/zoho-webhooks-shopify-api-automatically-restore.html

    > Functions: then hover your mouse over the function and select "REST API". Enable the API Key option and copy the long URL to your clipboard for use in the above function: Set up a schedule If you find your webhooks being automatically removed by...

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

    An article to ensure I never spend this long on such a request again. The brief is: "Follow 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"....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  3. Zoho Analytics: Create a Monitoring System with Imageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-create-a-monitoring-system-with-images.html

    click on the "Widget" button: On the data column, I'll select any query and any field. It doesn't matter which one here, as long as I can get to the 3rd tab of the widget (it becomes enabled once you've completed enough on the 1st tab): I'll click on...

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

    back to the contact record, and upload the file to the attachment... Some customers say this is unworkable and takes far too long, especially the part of adding the various field placeholders onto the template document; every time. What if I told you we...

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

    A short article explaining how Zoho Deluge allows a variable assignment to be written across multiple lines, as long as the statement ends with a semi-colon. This has a limited number of use cases, but is useful to be aware of if you have not come...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  6. View your available module positionshttps://www.joellipman.com/articles/cms/joomla/view-your-available-module-positions.html

    positions. You will need to repeat the process when you select a different template but otherwise the bookmark will last as long as you keep that template.

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  7. Creating a Profile Plugin for Joomla 1.6https://www.joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

    profile fields for profile - JoelLipman.Com edit form" PLG_USER_PROFILE5_FIELD_ALLERGYTIME_DESC="How long have you been dealing with this allergy?" PLG_USER_PROFILE5_FIELD_ALLERGYTIME_LABEL="Time With Allergy?"...

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

    warp does not include the mootools-more.js file: -- reminder: check for conflicts Additional Notes You have no idea how long it has taken me to get this code in working order and as easy as it may be to others, this has been quite a challenge. I have...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  9. Google Authentication - OAuth 2.0 using PHP/cURLhttps://www.joellipman.com/component/content/article/google-authentication-oauth-2-0-using-php-curl.html?catid=61&Itemid=165

    OAuth2.0. These functions allow a script to simply be loaded and to either create a token file, or use the existing one as long as it hasn't expired. Update 2019 This script requires a user to authenticate the google account. I have a newer article...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  10. Transferring Apps (purchases) from iPhone 4s to 5s on a Windows PChttps://www.joellipman.com/articles/else/app-dev/ios/transferring-apps-purchases-from-iphone-4s-to-5s-on-a-windows-pc.html

    for the restore to complete. The new phone will restart but you have to wait for the sync to start and complete (can take as long as the restore/backup) Done Unplug your new phone and test. Ta daa! If this article helped you, please leave a comment...

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

    the correct value or say "No data found". My end-users would otherwise ask is the data value reliable if it's blank? The long way of doing this I would have called this article "Iteration within SQL Server Reporting Services Business Intelligence...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  12. SSRS: Performance Improvements: SELECT TOPhttps://www.joellipman.com/component/content/article/ssrs-performance-improvements-select-top.html?catid=75&Itemid=165

    ran in less than a few seconds. Analyzing the report through the ReportServer databases (internal auditing) only showed how long the SQL query would take to recover the data and present it in a report, which would average about 0.4 seconds. We're...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  13. SSRS Stop Scrolling Behindhttps://www.joellipman.com/component/content/article/ssrs-stop-scrolling-behind.html?catid=75&Itemid=165

    the corners and sides of the report. It looked beautiful if simply displayed on a single page (the top half of the page) as long as the end-user doesn't scroll. If the page was scrolled, what should display went behind my report and instead the whole...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  14. Windows 7: System Clock is constantly going out of synchttps://www.joellipman.com/component/content/article/windows-7-system-clock-is-constantly-going-out-of-sync.html?catid=80&Itemid=165

    date/time. The Quick Fix First off, check there aren't any Update for Windows 7 releases at Microsoft's Windows Update The Long Fix Now below are the notes I've had to try and fix this before (personally it was because Microsoft released an optional...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  15. Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/component/content/article/running-internet-explorer-6-7-8-as-standalones.html?catid=80&Itemid=165

    are a lot of articles on the WWW detailing this process but none of them really worked for me. I recently changed job and no longer have all my test machines at work. Instead I only have the one workstation :eek Still I've been asked to test some web...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  16. 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

    connected to my docking station weren't too much of an issue either as MS Windows detected these without needing software. Long rant to justify why I didn't want to drive home (~20 to 40 minutes commute) and pick up my laptop. How? The work and research...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  17. Search a database for a value and count matching rowshttps://www.joellipman.com/articles/else/database/search-a-database-for-a-value-and-count-matching-rows.html

    we want to search on is "3" (the 3rd incremental load). How? The below stored procedure can be reduced to just a script as long as you declare and set the parameters after the BEGIN and extract the script from BEGIN to END (excluding the words BEGIN and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  18. Convert to Proper Case in T-SQLhttps://www.joellipman.com/articles/else/database/t-sql/convert-to-proper-case-in-t-sql.html

    how to convert UPPERCASE text into mixed case. The feed is originally for a personnel feed so it won't be converting long paragraphs of English text. Instead it will be applied to names and addresses as well as job titles and departments. Why? We wanted...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  19. Accessing a MySQL Database with Business Intelligence Development Studiohttps://www.joellipman.com/articles/else/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

    Driver" > Finish Data Source Name (should be system name followed by Live/Test/Dev for reference) Description can be some long winded text that very few will ever use TCP/IP Server is the server name (without the DNS suffix) or the IP address of the...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  20. Inserting incremental weeks in MySQLhttps://www.joellipman.com/articles/else/database/mysql/inserting-incremental-weeks-in-mysql.html

    date. Problem? The 1st of January 2010 was a Friday. The 1st of January 2011 was a Saturday. The developer felt that as long as you adjust the script each year you could make the system last another year. Shame he also forgot the academic year ends...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
Results 41 - 60 of 76