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

  1. ZohoCRM: Get Organization Business Hours using Deluge/APIhttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-get-organization-business-hours-via-deluge-api.html

    A super quick article on getting the business hours set in ZohoCRM. Why? When creating a booking system in ZohoCreator, I want to enter the default working shift for an employee either existing or that has been added to the system based on the business...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  2. Accessing a MySQL Database with Business Intelligence Development Studiohttps://joellipman.com/articles/else/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

    was I trying to achieve? I've written this article because this is how I connected to a MySQL database from within the Business Intelligence Development Studio (BIDS) IDE from Microsoft. Required: Windows XP (ODBC Data Source Administrator) MS Business...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  3. SQL Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/else/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

    I find myself searching the web for a way of producing an outlook-style calendar within Business Intelligence Development Studio (BIDS). Weekdays along the top and then dates inside. Additionally we would like this linked to events in a database. I'm...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  4. Room Availability Calendar in Business Intelligence Development Studiohttps://joellipman.com/component/content/article/room-availability-calendar-in-business-intelligence-development-studio.html?catid=75&Itemid=165

    Well I tried and I spent a few hours searching the net for a solution which displays the hours in the top columns, and undefined number of rooms in the rows. No all I was looking for was a calendar showing 1 day with the hours on the top. Working hours...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  5. GDPR Privacy Policyhttps://joellipman.com/component/content/article/gdpr-privacy-policy.html?catid=50&Itemid=165

    • Type: Article
    • Category: Static Items
    • Language: *
  6. Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=53&Itemid=165

    was free as well :c) Question Why would I want preview screenshots of sites I link to? Answer: Apparently it's big business but I fail to see why any business specialising in website thumbnail generator services, puts all its eggs in one basket. Put...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  7. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/component/content/article/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html?catid=74&Itemid=165

    to: Microsoft Business Intelligence Development Studio (BIDS) Visual Studio 2008 Microsoft Windows 7 Microsoft .NET Framework 3.5 Microsoft Visual C# 2008 What? So like lots of people on the net, I've been given a datasource with names and addresses all...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  8. Checklist for the local computer repairshttps://joellipman.com/component/content/article/checklist-for-the-local-computer-repairs.html?catid=116&Itemid=165

    Templates: Service Agreement Template Computer Repair Invoice Template Documents: Service Agreement Electronic Newsletter Business Cards Extra RAM (to charge for) Extra Cables (again to charge for) Service: Software installs at flat price Website...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  9. Newbies guide to be the local computer guyhttps://joellipman.com/component/content/article/newbies-guide-to-be-the-local-computer-guy.html?catid=116&Itemid=165

    Get business cards made. Pass them out where ever you go. Don’t rent a storefront yet. Go to people’s businesses/homes and do the repairs there. Ask local businesses if you can post a flyer in their window or on their cash wrap. Initially, charge a...

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

    that runs on lead create (record action) and the criteria can be where "Lead Conversion Time" is less than 4 (4 days not 4 business days?). Though I've removed this condition since go live and simply specified "All Leads". I'm calling my function...

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

    by a JS Widget. Inputs: string crmAPIRequest (webhook request from Zoho CRM) Outputs: - Date Created: 2025-08-15 (Ascent Business - Joel Lipman) - Initial release - Testing auth and connection Date Modified: 2025-08-15 (Ascent Business - Joel Lipman) -...

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

    processor (1.0 GHz or faster recommended), and requires approximately 35 MB of disk space. It runs on Windows Vista Business, Windows Vista Enterprise, Windows Vista Ultimate, Windows XP Professional, Windows XP Tablet PC Edition, Windows Vista Service...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  13. Terms & Conditionshttps://joellipman.com/component/content/article/terms-conditions.html?catid=50&Itemid=165

    the content of the linked website(s). You may not create a link to this website from another website or document without [business name]'s prior written consent. Your use of this website and any dispute arising out of such use of the website is subject...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  14. Licence GNU/GPLhttps://joellipman.com/component/content/article/licence-gnugpl.html?catid=50&Itemid=165

    this License. You may not convey a covered work if you are a party to an arrangement with a third party that is in the business of distributing software, under which you make payment to the third party based on the extent of your activity of conveying...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  15. Joes DNS Correction (JDC)https://joellipman.com/component/content/article/joes-dns-correction2.html?catid=53&Itemid=165

    usual solution is a reboot, then this tool may be for you. In my environment, I am working with a Visual Studio 2008 IDE (Business Intelligence Development Studio - BIDS) along with Microsoft's Team Foundation Server (TFS). Sometimes I'll check out an...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  16. Zoho Deluge: Calculate Days, Hours, Minutes, Seconds between two Timestampshttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-calculate-days,-hours,-minutes,-seconds-between-two-timestamps.html

    a from datetime v_NowTime = '2021-09-21 21:27:15'; // // now specify a to datetime (we're doing a working day so we add 1 business day) v_NextTime = zoho.currentdate.addBusinessDay(1).toString("yyyy-MM-dd ") + "12:00:00"; // // convert to seconds...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  17. ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-integrate-chatgpt-to-zohozia.html

    "user"); m_MessageTraining1.put("content", "Joel Lipman is a technical consultant working with Ascent Business Solutions, the top Zoho Reseller based in the United Kingdom."); l_Messages.add(m_MessageTraining1); // // this message m_ThisMessage = Map();...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  18. Zoho Creator: Get Images in Report to be Exported to PDFhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-get-images-in-report-to-be-exported-to-pdf.html

    in the real world process; then cover some technical information; and even include the function that makes it work: Business Process Customer visits website to report a faulty product; using website form or chat. Customer can upload or send to agent to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  19. Zoho Deluge and Wordpress/WooCommerce API: Get All Productshttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-and-wordpress-woocommerce-api-get-all-products.html

    Give it a description, assign a user that it will run as (preferably of the admin or account that will never leave the business), and permissions can be "Read". Click on the "Generate API Key" button Note the consumer_key and consumer_secret somewhere...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  20. Zoho Creator: Render to PDF with margins and page numbershttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

    small print here just so that you don't really read this and appreciate that we have terms and conditions like every other business. Page of Copyright © My Company Ltd. All Rights Reserved. Additional Notes to Self: Some customers will want a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
Results 1 - 20 of 47