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

  1. ZohoCRM & Xero: Function to pull most recent invoiceshttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-invoices.html

    the first page of most recent invoices from Xero and pull them into ZohoCRM Inputs: - Outputs: - Date Created: 2025-10-08 (Joel Lipman) - Initial release Date Modified: 2025-10-13 ( Joel Lipman) - Parsing Xero Dates and Times to include timezone of Xero...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  2. T-SQL concatenate an incremental row numberhttps://joellipman.com/articles/else/database/t-sql/t-sql-concatenate-an-incremental-row-number.html

    the following two tables exist: TABLE: Employee -------------------------------------------------- ID FirstName Surname 1 Joel Lipman 2 Another Joe TABLE: Qualifications -------------------------------------------------- ID Employee Subject Grade 1 001...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  3. Joel's Reference to MidJourney v4 Promptshttps://joellipman.com/component/content/article/joel-s-guide-to-midjourney-prompts.html?catid=115&Itemid=165

    What? So this is an article for me to store prompts for the MidJourney AI text-2-image discord tool. Why? The results from the MidJourney bot are beyond unpredictable however with the correct prompts you can direct it to focus on the elements you want...

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

    response = invokeUrl [ url: "https://books.zoho.com/api/v3/estimates?organization_id=12346789" type: GET connection: "joelconnector" ]; How? So in the following example, we are going to setup a connection in Zoho Books on an EU datacenter: First...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  5. Zoho CRM: Update a custom field in line items / product details using REST API v2.1https://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-update-a-custom-field-in-line-items-product-details.html

    like: { "data": [ { "code": "SUCCESS", "details": { "Modified_Time": "2021-05-17T11:02:59+01:00", "Modified_By": { "name": "Joel Admin", "id": "123456" }, "Created_Time": "2021-05-17T11:02:59+01:00", "id": "98498465735491156", "Created_By": { "name":...

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

    to describe this might be better explained if you consider the following snippet of code: // sample data v_Test = "00011,Joel Lipman,\"Flat 8, House Corner\",Brummieland"; // regex to replace a comma found between 2 double-quotes to a string of your...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  7. Zoho CRM & Zoho Books: Get SalesPersonshttps://joellipman.com/articles/crm/zoho/zoho-books/zoho-crm-zoho-books-get-salespersons.html

    through all salespersons in Zoho Books, and retrieving the salesperson_id. Also I have a connector to ZohoBooks called "joel_books". The "v_Filter" appears to do absolutely nothing but I've left it in there in case one day I figure it out: // init...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  8. Zoho Creator/Deluge: Calculating with Timezone Offsethttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-deluge-calculating-with-timezone-offset.html

    "); v_ResultInformation = v_ResultInformation.concat(" "); input.Note_BookedTimeSelection = v_ResultInformation; Source(s): Joel Lipman: Zoho Deluge: Generate List of TimeZones Joel Lipman DataSources: Time zones supported by Zoho (MS Excel file)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  9. Zoho Deluge: Calculate start and end of Daylight Savings Timehttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-calculate-start-and-end-of-daylight-savings-time.html

    is calculating correctly. I use these to store the values in a table that can be double-checked at a later date. Source(s): Joel Lipman: Zoho Deluge: Generate List of TimeZones Joel Lipman DataSources: Time zones supported by Zoho (MS Excel file)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  10. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Delugehttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-zoho-inventory-upload-image-to-item-record.html

    image is accepted at the moment, and the endpoint will depend on your datacenter (eg. COM or EU), and lastly the connection "joel_books" is my connection to ZohoBooks: // // declare ID of item in Zoho Inventory v_InventoryId = 123456789012345678; // //...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  11. ZohoCRM: Import Attachmentshttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-import-attachments.html

    subfolders as well as rename the files to unique filenames. ; ; Language: English ; Platform: Microsoft Windows 11 ; Author: Joel Lipman ; Version: 1.0 ; Description: This program will generate a clean Attachments.zip and its Attachments.csv to upload...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  12. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://joellipman.com/articles/crm/zoho/zoho-recruit/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

    is modified Purpose: Associates Job Openings with a Candidate when their record is modified. Date Created: 2023-02-02 (JoelLipman.com - Joel Lipman) - Initial release Date Modified: ????-??-?? (??? - ???) -...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Recruit
    • Language: *
  13. ZohoBooks: Stripe Terminal Integrationhttps://joellipman.com/articles/crm/zoho/zoho-books/zohobooks-stripe-terminal-integration.html

    - Initial release - Reads Books Invoice and sends the amount to the reader for a payment atempt Date Modified: 2023-02-24 (Joel Lipman) - If custom field "Amount To Be Taken" is not greater than zero, then defaults to balance due of invoice. More...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  14. ZohoDeluge: Check Shipment Status via DHL APIhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zohodeluge-check-shipment-status-via-dhl-api.html

    DHL for tracking information about a shipment and returns the status code (eg. "delivered") Date Created: 2023-03-21 (Joel Lipman) - Initial release Date Modified: 2023-03-21 (Joel Lipman) - ??? More Info: - DHL Developer Portal:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  15. Zoho Deluge: Get All Orders from eBayhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-all-orders-from-ebay.html

    /* Function: fn_GetEbayOrders() Purpose: Queries eBay for all orders for a specified year Date Created: 2023-03-29 (Joel Lipman) - Initial release Date Modified: 2023-03-29 (Joel Lipman) - Added in ability to list errors and query order line item IDs...

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

    WorkDrive.teamfolders.ALL, WorkDrive.links.ALL, WorkDrive.DataTemplates.READ Date Created: 2023-12-05 (Joel Lipman) - Initial release - Uploads an image to workdrive and returns the public link Date Modified: ??? - ???...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  17. ZCRM Client Script: Correct Decimal Fields OnLoadhttps://joellipman.com/articles/crm/zoho/zoho-crm/zcrm-client-script-correct-decimal-fields-onload.html

    without changing this. This script will round up decimal fields onload. Inputs: - Outputs: - Date Created: 2023-12-13 (Joel Lipman) - Initial release - Correctly rounds any decimal fields to their maximum decimal place. Date Modified: ??? - ???...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  18. ZohoCreator: Basic Widget with Zoho Datahttps://joellipman.com/articles/crm/zoho/zoho-creator/zohocreator-basic-widget-with-zoho-data.html

    and Bootstrap: Company Name - Quote Builder Hi You have 0 Pending Quotes You have 0 Previous Quotes Get a New Quote! © 1999 Joel Lipman Ltd. All Rights Reserved the JavaScript These are the contents of main.js and is working at time of print: // Start...

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

    to Dan Inputs: The Lead Record ID Outputs: A task with a daily reminder until after 3 reminders Date Created: 2024-05-13 (Joel Lipman) - Initial release Date Modified: 2024-05-14 (Joel Lipman) - After the 3rd reminder (3 days overdue) then assign to Dan...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  20. Zoho Creator: Input Color Pickerhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-input-color-picker.html

    value, when the record is loaded up (existing record), it will have the color already displayed in the button: Source(s): Joel Lipman - Zoho Creator: Radio group into Calendar Carousel Joel Lipman - Zoho Deluge: Convert Hex to RGB

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
Results 21 - 40 of 656