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

  1. Project Plan for Freelance Websitehttps://www.joellipman.com/articles/cms/website-development/project-plan-for-freelance-website.html

    what does this mean in stage 1? And this in stage 2? (There are over 100 stages)... Below is my template project initiation plan (project mandate?) for my freelance website development process. It may look clean, clear, obvious... it's just an outline...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  2. Google Event Ilustrations aka Flairshttps://www.joellipman.com/component/content/article/google-event-ilustrations-aka-flairs.html?catid=61&Itemid=165

    new year, new year's, new years oilchange: oil change, car service pingpong: ping pong, table tennis, ping-pong, pingpong planmyday: plan week, plan quarter, plan day, plan vacation, week planning, vacation planning pride: dyke march, christopher street...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: *
  3. Client Services: Website Development Agreementhttps://www.joellipman.com/component/content/article/client-services-website-development-agreement.html?catid=50&Itemid=165

    and running with the latest technologies. You are welcome to find and use your own website hosts with their own support plans and I can help you configure these for the source files (as per my base rate). Note that my servers are based in Houston,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  4. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://www.joellipman.com/articles/crm/zoho/zoho-other/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

    return m_Response; Error(s) Encountered: Exceeded Quote Limit: Try generating a new API key (aka Secret). If you need a paid plan, then you can access this by logging into OpenAI and browsing to https://platform.openai.com/account/billing/overview. At...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  5. Zoho Deluge: Determine your Statement Execution Limithttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-determine-your-statement-execution-limit.html

    in Zoho Creator was hitting statement execution limits and rather than proposing an upgrade or add-on to the subscription plan; we wanted some proof using code. How? We're going to use a quick snippet of some code. So create a function in the Zoho App...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  6. Zoho Deluge: Loop through 30 Minute Slotshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-loop-through-list.html

    a picklist and fill it with options from a certain time of the day to the closing time of the day (working hours). How? The plan is to iterate through a 24-hour clock, enable adding to the picklist when the starting hour is found and stop adding when...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  7. Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-create-a-widget-which-uses-javascript.html

    fresh install as if this is the first time this computer has created a Zoho Creator Widget. Software used: Zoho Creator v5 (Plan Premium or greater is required - includes Zoho One) macOS Catalina v10.15.7 Safari v14.0 MS Visual Studio Code v1.48.2...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  8. Zoho CRM: Get Unique Values of a Text Fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-get-unique-values-of-a-field.html

    in a staging module in CRM but I want to transform/translate one of the column values into the target How? So this is my plan: Setup a connector to CRM with the scopes ZohoCRM.coql.READ and ZohoCRM.modules.ALL Build up a SQL query, or more specifically,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  9. Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense)https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-text-sms-using-twilio-api-localsense.html

    - Creating or Updating Resources with the POST Method Twilio Docs - Error 21211 Twilio Docs - E.164 (Telephone numbering plan)

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

    on Reuse Test on keeping conversation context: Still to do: Need to train it on ZohoCRM data with statistics and datasets. Planning Need to ensure data fed into a session is not shared or available to external sources once entered into OpenAI. If I...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  11. Zoho Creator: Find Duplicates by Customer Name for Large Datasetshttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-find-duplicates-by-customer-name-for-large-datasets.html

    use of any third-party APIs. How? My team of developers actually helped me solve this one as I was slowly dispairing... The Plan Get a list of all unique/distinct Customers Get a list of all Customers Remove the list of unique ones from the "all" list...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  12. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

    SVG. ZohoCRM signatures seem to be unable to handle a lot of code or long URLs such as a base64 source URL for an image. The Plan Get company phone and website from Organization Details in ZohoCRM. Upload and get publicly-accessible image URL to/from...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  13. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://www.joellipman.com/component/content/article/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html?catid=129&Itemid=165

    icon in the top-right for "Settings" You should be in the "Organization Settings" Click on any page in the left sidebar (eg. Plan Details), your Org ID is in the URL as the last number after the slash (eg. "20012345678") Note this down for later use...

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

    Use URL of image representing a FAILURE ***/ But if I want it to join to my images table and with a bit more foresight (I plan to do a mega query to rule them all which has all the data for my widgets), I have to write it as such: SELECT 'CRM Accounts'...

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

    of a button: Scenario 1: Credit Application: Template exists in ZohoSign Very quickly, let's go over the implementation plan for this scenario (where you have the template in ZohoSign with fields for the end user to complete): Add code to button "Send...

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

    on a per-app basis so I wanted a standard way of doing it and I'll update this article as I improve on the code. How? So the plan is: Declare the functions. Authenticate on page load by checking timestamp in token file: If token is required, redirect...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  17. SSRS AlphaNumeric Parameter Validationhttps://www.joellipman.com/component/content/article/ssrs-alphanumeric-validation.html?catid=75&Itemid=165

    punctuations, etc) then you should do this at the database level, and then get the report to complete the check: The Plan User enters value in parameters and clicks on "View Report" Report passes parameter to dataset which gets formatted by the database...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  18. SSRS Dropdown parameter cannot be blank!https://www.joellipman.com/component/content/article/ssrs-dropdown-to-allow-blank-values.html?catid=75&Itemid=165

    solution but it still didn't work for me. But the idea of inserting a NULL entry to select sounded good. Aim / Objective The plan will be to replace the default "" with a custom null entry and the end-user will be none the wiser. OLD: Dataset to...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  19. 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

    #CountRecordsPerTablePerCol; END Issues Consider adding a drop of the temporary table to the start of this script if you plan on running this successively against several databases: DROP TABLE #CountRecordsPerTablePerCol or equally IF...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  20. Drop If Object Existshttps://www.joellipman.com/articles/else/database/t-sql/drop-if-object-exists.html

    IF = SQL inline table-valued function IT = Internal table P = SQL Stored Procedure PC = Assembly (CLR) stored-procedure PG = Plan guide PK = PRIMARY KEY constraint R = Rule (old-style, stand-alone) RF = Replication-filter-procedure S = System base table...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
Results 1 - 20 of 24