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

  1. Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-generate-5-letter-booking-retrieval-code.html

    take a list of letters, shuffle the list, and return the first 5 characters. string generateRetrievalCode() { // init v_Output = ""; l_Output = List:String(); l_Alphabet =...

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

    to a CRM account record and test the button works. Go back to your Zoho CRM function and simply include HTML and CSS in the output of the function... done. What we're here for The following script is what I use to pass the record ID to a CRM function...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  3. MS-DOS: Copy folders without overwriting fileshttps://www.joellipman.com/component/content/article/ms-dos-copy-folders-without-overwriting-files.html?catid=51&Itemid=165

    copy in the source directory. -- /XO excludes existing files older than the copy in the source directory. There's a nice output of the results if you run this in a command prompt. The Manual:...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
  4. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://www.joellipman.com/component/content/article/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html?catid=61&Itemid=165

    'Authorization: Bearer ' . $access_token) ); // execute cURL request $response=curl_exec($ch1); if($response === false){ $output = 'ERROR: '.curl_error($ch1); } else{ $output = $response; } // close first request handler curl_close($ch1); // now let's...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  5. Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=53&Itemid=165

    over quite quickly due to testing). Options/Features Source Browser Size: Sets what the original picture dimensions are. Output Thumbnail Size: Only several presets but there are free image editors out there that will batch convert your images: 150x100,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  6. Accessing Apimo WebService APIhttps://www.joellipman.com/component/content/article/accessing-apimo-webservice-api.html?catid=109&Itemid=165

    = ''; // specify target url and version $apimo_url = 'https://api.apimo.com/api/call'; $apimo_version = 2; // specify data output $apimo_method = 'getAgencies'; $apimo_type = 'xml'; // specify key and encryption $apimo_key =...

    • Type: Article
    • Author: Joel Lipman
    • Category: API Miscellaneous
    • Language: *
  7. A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/cms/website-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

    word, so this is a somewhat summarized article on how to get data out of SITS, up to running the monitors and populating an OUTPUT table in the SITS database. Note that this does not include steps thereafter in the Staging or Target destination which...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *
  8. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile)https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-using-a-function-for-validation-rules.html

    Function: fn_Validate_LeadStatusChange Trigger: Function executed when a record is changed Inputs: String crmAPIRequest Outputs: output message to user Date Created: 2022-02-11 (JoelLipman.com - Joel Lipman) - Initial release - Checks the user profile...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  9. MacOs: Transcribe Training Video using OpenAI Whisperhttps://www.joellipman.com/component/content/article/macos-transcribe-training-video-using-openai-whisper.html?catid=60&Itemid=165

    Open the "Terminal" app Type brew install ffmpeg Extract audio: ffmpeg -i your_video.mp4 -vn -ar 16000 -ac 1 -b:a 64k output_audio.mp3 [Optional if using online version of OpenAI Whisper] Split audio into segments: ffmpeg -i output_audio.mp3 -f segment...

    • Type: Article
    • Author: Joel Lipman
    • Category: Apple
    • Language: *
  10. Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/component/content/article/google-drive-oauth-using-service-account-in-php.html?catid=61&Itemid=165

    Well mostly. Simply because we'll be working with JSON data and this encodes/decodes easily into PHP arrays. I can also output any of the variables and responses for debugging purposes. I can also unset multiple branches of variables with fewer commands...

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

    doesn't need a database connection here: function getUrlAlias($p_Name){ // lowercase and trim preceding/trailing spaces $v_Output = strtolower(trim($p_Name)); // replace all non alphanumeric characters (except underscore) to an underscore $v_Output =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  12. ZohoCRM & Xero: Function to pull most recent invoiceshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-invoices.html

    / Callable Purpose: Function to get 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  13. Zoho Creator: Receive eBay Order Notifications via Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-receive-ebay-order-notifications-via-webhook.html

    that generates an access token from a refresh token: string API.fn_eBayConnect_AccessToken() { b_SandboxMode = false; v_Output = ""; if(b_SandboxMode) { r_Api = API_Integration[Connection_Name == "eBay API (Sandbox)"]; //info "Sandbox Mode"; } else {...

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

    - Xero - Map Tax Rates Trigger: Standalone / On-Demand Purpose: Function used to map Xero tax rates to Zoho ones Inputs: - Outputs: - Date Created: 2025-10-13 (Joel Lipman) - Initial release Date Modified: ??? - ??? More Information: Ensure that all...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  15. Add attribute xsl:nil=true on empty elements using XSLThttps://www.joellipman.com/articles/cms/website-development/xml/xslt/add-attribute-xsl-nil-true-on-empty-elements-using-xslt.html

    I'm going to use a very short example by providing a blank date of birth value: -- What I have: // -- What I want: Why? Outputting from SITS:Vision to our staging environment, the application would only output blank values using single tags so we had to...

    • Type: Article
    • Author: Joel Lipman
    • Category: XML Stylesheet Language Transformations
    • Language: *
  16. List last modified files using FTP Command-linehttps://www.joellipman.com/articles/cms/website-development/ftp/list-last-modified-files-using-ftp-command-line.html

    directory is the current directory. Type lcd to confirm what the local working directory is (when you download or print output, it will save to this folder on your computer). Can type lcd if you want to change this (leave blank to simply display what...

    • Type: Article
    • Author: Joel Lipman
    • Category: File Transfer Protocol
    • Language: *
  17. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://www.joellipman.com/component/content/article/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html?catid=45&Itemid=165

    Here's a crude diagram of what I had: Previous Setup Diagram: Home PC has a graphics card with 1x HDMI, 1x DVI, and 1x VGA output ports: I connected the 2 acer monitors which both accepted DVI. Work PC has a graphics card with 1x Display Port output...

    • Type: Article
    • Author: Joel Lipman
    • Category: Articles
    • Language: *
  18. 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

    type :POST parameters: m_Params.toString() connection: "joels_coql_connection" ]; // // output info r_Coql; But this returns something like the following (I've reduced the 200 records to about 6 of them): { "data": [ { "Currency": "EUR", "id":...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  19. Zoho Creator / Shopify: Get all Active Productshttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-shopify-get-all-active-products.html

    of ID ascending (starting with ID=0) retrieving 250 per call and using since_id to not list the same one twice. It then outputs a JSON list as a response and the total record count: void API.fn_ShopifyQuery_GetActiveProducts() { m_Header = Map();...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  20. Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

    these in a cURL request (same thing really): string API.fn_ShopifyQuery_UploadPhoto(int p_Position, int p_ProductID) { v_Output = ""; m_Header = Map(); m_Header.put("Content-Type","application/json"); // // your shopify details v_ClientID = "";...

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