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

  1. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines)https://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-handle-commas-between-quotes-in-a-csv.html

    This is an article to demonstrate how to handle commas in a CSV file that were enclosed between two double-quotes. I've added to this the handling of new lines or carriage returns in between a pair of double-quotes. Why? Our use case is that we were...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  2. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

    is an article which is the updated version of my article Zoho Deluge: Push Item to Shopify API for 2022 using the new policy that Shopify have implemented when creating a custom app. Why? My use-case scenario here is that we have a Zoho Creator app...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  3. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://joellipman.com/articles/else/e-commerce/ebay/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

    image to eBay's Picture Hosting Services (EPS). Why? Because I couldn't find any other article in the whole world wide web that had a working solution. My use-case here is that I have built an eBay integration between Zoho Inventory and... eBay....

    • Type: Article
    • Author: Joel Lipman
    • Category: Ebay
    • Language: *
  4. ZohoCRM: Make either Mobile or Email mandatoryhttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-make-either-mobile-or-email-mandatory.html

    cool requirement, making 2 fields mandatory but if one is completed then making the other optional. Why? My use-case is that the mobile or email field on a Zoho CRM contact record is used to authenticate the contact on a Wordpress portal. OTP or 2FA or...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  5. Zoho CRM: Updating a CRM record Custom Line Items using API v7https://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-updating-a-crm-record-using-api-v7.html

    What? This is a quick bit of code for my reference so that I don't have to keep finding a function that gives me the syntax of how to either create or update a record using invokeUrl. Why? Because my designers keep including custom fields in their...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  6. Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-using-remove-key-on-a-map.html

    to use remove() on a map variable as well as a snippet of code to copy tags from a contact to a deal record. Why? Anything that stumps me for 30 minutes is worth writing a quick article on. In this case, I had a function querying tags on a contact...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  7. Zoho CRM Client Script: Map Quote to Invoicehttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-client-script-map-quote-to-invoice.html

    This is an article to apply an automation that when creating an invoice in CRM from a related quote, it maps in the fields. Why? The process should be that you go to the CRM quote record and click on "Convert" > then select "Invoice", and it should map...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  8. ZohoCRM & Xero: Function to pull most recent quoteshttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-quotes.html

    Because my head is a little fried, I'm putting the two functions I used here and I'll document further if I remember. Note that the pre-amble is to generate a Xero access token which I documented in another article - it's behind a userwall because I...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  9. SSIS Convert a string into a datehttps://joellipman.com/component/content/article/ssis-convert-a-string-into-a-date.html?catid=74&Itemid=165

    situation. This is a quick article on how I got time conversion working in an SSIS package which read from a text file. Note that the example below converts a string in European Date Format (ie. "ddmmyyyy" to "dd/mm/yyyy"). Also, my data flow imports...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  10. SSRS Querying on either of 2 Parametershttps://joellipman.com/component/content/article/ssrs-querying-on-either-of-2-parameters.html?catid=75&Itemid=165

    situation is that we are replacing a website-application with a single SQL Server Reporting Services (SSRS 2008 R2) report. We're using Business Intelligence Development Studio (BIDS VS2008) with Team Foundation Server (TFS VS2010) and connecting to an...

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

    like this linked to events in a database. I'm calling this project "Reinventing the Wheel" because the request was a report that was similar to an MS Outlook calendar which will display any room bookings for that month. This is "Reinventing" because we...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  12. Project Plan for Freelance Websitehttps://joellipman.com/articles/cms/website-development/project-plan-for-freelance-website.html

    on one element means less on another) Search Engine Optimization constraints and standards Domain Registration This is so that you as the client retain overall control of the website. If you are dissatisfied with our services or need another developer...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  13. What's the problem? Amusing computer issueshttps://joellipman.com/articles/cms/website-development/whats-the-problem-amusing-computer-reports.html

    the rest of this article in case you're easily offended. It's just an amusing stab at customers computer issues. Note that most of the below were remote support jobs so we weren't there in person and could only see the users screen. Three Webdevelopers...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  14. PHP & MySQL Search Enginehttps://joellipman.com/articles/cms/website-development/php/php-a-mysql-search-engine.html

    you hate sites that do not have a search feature? I do. I think it defeats the purpose of cramming information endlessly in cyberspace. So we want to give a search engine to our users. This sounds really simple, we could try: $search_term_esc =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  15. URL Alias uniqueness with PHP & MySQLhttps://joellipman.com/articles/cms/website-development/php/url-alias-uniqueness-with-php-mysql.html

    feature where a Title/Name value is converted to a search-engine friendly URL alias and is unique in the database. Ok that's a long sentence; let me try this: When I save a record in JoomlaCMS or WordpressCMS It creates a unique name to use in URLs I...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  16. AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttps://joellipman.com/component/content/article/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html?catid=48&Itemid=165

    have a Mac or Linux system, you will know of a feature where you can have another virtual desktop on your device. For those that don't know it, the feature is similar to mobile phones where you swipe left/right to reveal another screen of app icons. The...

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

    about a week prior to release date). JoelLipman.Com will make the source files available for download 24/7 so in the event that we lose contact with each other, the project manager has the option of going to another developer with the source files in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  18. Joe's CSV Chart Generator (JCG)https://joellipman.com/component/content/article/joellipmans-csv-chart-generator.html?catid=53&Itemid=165

    :c) BACKGROUND: Originally dubbed EventViewer Chart Generator. As the name suggests, I was looking for a free program that can take an exported CSV list from a standard MS Windows eventlog or eventviewer log and generate a chart from the data. What my...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  19. Zoho Deluge: Setup an API Connection for InvokeURLhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-setup-an-api-connection-for-invokeurl.html

    Token API v2 (Zoho to Zoho service) and different to my Zoho CRM: APIv2 using PHP & cURL (3rd-Party to Zoho), in that this details how to setup a connection to use in an invoke URL statement. Specifically for Zoho Books, Subscriptions or Inventory. Why?...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  20. Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Divhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-page-toggle-on-off-switch-hide-display-a-div.html

    So this is an article documenting how to create an on/off toggle switch that hides and displays between 2 div layers in a Zoho Creator Page (so not a form or report but a page). Why? This is written at a time when Javascript or interactive pages that...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
Results 81 - 100 of 494