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

  1. AutoHotkey: App GUI Listview to Rename Fileshttps://www.joellipman.com/component/content/article/autohotkey-app-gui-listview-to-rename-files.html?catid=48&Itemid=165

    #NoEnv ; Recommended for performance and compatibility with future AutoHotkey releases. SendMode Input ; Recommended for new scripts due to its superior speed and reliability. SetWorkingDir %A_ScriptDir% ; Ensures a consistent starting directory. ;...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  2. Zoho Creator: Expecting ZC_SUBFORM_250 expression found COLLECTIONhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-expecting-zc-subform-250-expression-found-collection.html

    . = ; . = ; // insert the row into the collection .insert( ); // insert the collection into the subform on the current form input..insert( ); // or insert the row(s) into the subform through the record variable r_LeadDetails = Leads[ID == 1234567890];...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  3. Zoho Creator: info/alert/modal/popup notification for any userhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

    Creator page, retrieve the title and content of the modal dialog from the record by using the following: v_NotifyID = ifnull(input.p_NotifyID,0).toLong(); r_NotifyDetails = Notifications[ID == v_NotifyID]; v_Text = r_NotifyDetails.Title; v_Content =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  4. Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://www.joellipman.com/articles/crm/zoho/zoho-people/zoho-people-reject-an-application-for-leave-in-deluge.html

    Properties" > Tick the box under "Validation" for "Custom Validation" to create a function: Ensure you select parameters to input rather than retrieving the record data: I'm calling the Function Name "RejectLeave" then click on Edit Params I'm calling...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  5. Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

    m_Link); } Code to Add a value to a multi-lookup (on Update Record): v_DealID = ifnull(input.p_DealID,0); if(v_DealID != 0) { m_Link = Map(); m_Link.put("Deal", v_DealID); m_Link.put("Product", 123456789012345678); r_Link =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  6. Zoho Creator: Add a subform while creating a recordhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-add-a-subform-while-creating-a-record.html

    any bidirectional relation field that exists will be prepopulated using the method above. Clear subform of all its rows: input..clear(); Changing the picklist/dropdown options in a subform row (applies overall rather than per row): clear ..; ..

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  7. Zoho Creator: Receive eBay Notification and Create Shopify Orderhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-receive-ebay-notification-and-create-shopify-order.html

    Transaction data and then the code to create a Shopify Order: Parse an eBay Transaction Notification (XML) x_ResponseBody = input.Payload.getJSON("body"); v_MainNodeName = "GetItemTransactionsResponse"; x_MainNode =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  8. Zoho Creator: eBay: Get Item Transactionhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-ebay-get-item-transaction.html

    is the eBay Item ID: void API.fn_eBayQuery_GetItemTransaction(int p_ItemID) { /* Function: fn_eBayQuery_GetItemTransaction() Input: int p_ItemID (eBay Item ID) Purpose: Fetches a line item transaction per item ID Date Created: 2022-01-22 (Joellipman -...

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

    Defaults ; -------------------------------------------------------------------------------------- #NoEnv #Warn SendMode Input SetWorkingDir %A_ScriptDir% #SingleInstance force v_Company := "Joel Lipman .Com" v_CompanyKey := StrReplace( v_Company, " ",...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  10. Zoho CRM: Change System Field Lengthhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-change-system-field-length.html

    the "Number of Characters allowed" field and select "Inspect Element" Expand the DIV the field is in and double-click on the INPUT element (specifically the disabled="disabled" attribute), then press delete/backspace to remove the attribute. Also remove...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  11. Zoho Books: Error 7008: There are no contact persons associated with this Invoicehttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohobooks-error-7008-there-are-no-contact-persons-associated-with-this-invoice.html

    you can lock it down to just the scopes you need. void ZohoBooks.fn_SendZohoBooksInvoice(int p_OrderID) { v_OrderID = ifnull(input.p_OrderID,0).toLong(); /* ******************************************************************************* Function: void...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  12. Zoho Deluge: Convert Hex to RGBhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-convert-hex-to-rgb.html

    reference to a Red Green Blue value (RGB). Why? It's likely that Zoho will avail their color picker at some point as an input but at the time of print, this hasn't happened yet. Here's a function in deluge that takes a 3 or 6 character hexadecimal color...

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

    Label: Fn - Quotes - On Edit Trigger: Used in a workflow when a quote is modified Purpose: Actions when a quote is modified Inputs: int p_QuoteID - the ID of the CRM Quote Record Outputs: void Date Created: 2024-12-10 (Joel Lipman) - Initial release...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  14. Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

    setting up her survey (eg. 1. question 1, 2. next question, 3....). ZohoSurveys - Individual Responses Query (if using an input field for email: public Survey) If you're not using the CRM integration and this is a public Survey with an email field on...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  15. Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

    CMS. Cross your fingers and use your DB management tool to run the SQL file (or copy the contents of the SQL file into the input field) Re-build/Auto-correct some Joomla inconsistencies Login to your Joomla Admin Panel using a System Administrator...

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

    unzip vosk-model-small-en-us-0.15.zip Convert Your MP4 to MP3 (extract the audio from the video) ffmpeg -i input_video.mp4 -q:a 0 -map a output_audio.mp3 Convert Your MP3 to WAV (mono, 16KHz) ffmpeg -i output-audio.mp3 -ar 16000 -ac 1 -f wav...

    • Type: Article
    • Author: Joel Lipman
    • Category: Apple
    • Language: *
  17. Mediawiki Extension for Camtasia Studio SWF videoshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

    { global $wgParser; $wgParser->setHook( "bukbplayer", "renderFlvPlayer" ); } function renderFlvPlayer( $input, $argv ) { $result = $flvPlayerFile->render(); return $result; // send the final code to the wiki } Amend your skin files Amend your skins to...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  18. Android: Replace return key with done, go, send...https://www.joellipman.com/articles/else/app-dev/android-os/android-replace-return-key-with-done-go-send.html

    openMap(v); // do function on pressing the word GO handled = true; } return handled; } }); Other Noteworthy Actions android:inputType In some cases, this will change the keyboard layout (eg. Numbers) text // Normal text textNoSuggestions // No...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  19. No rows returned in Oracle causes SP to failhttps://www.joellipman.com/articles/else/database/oracle-pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

    We have a stored procedure which contains two select queries. The first query will retrieve a student ID number where the input parameter is the student's username. The second query will return data using the student ID number found in the first query....

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  20. Inline Labels in Form Fields using Javascripthttps://www.joellipman.com/articles/cms/website-development/js/inline-labels-in-form-fields-using-javascript.html

    field was created with the following code: Explanation type="text" - standard attribute that tells the field this is an input field for single line of text. name="name" - attribute that assigns a variable name to this field so we can reference it later....

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: en-GB
Results 41 - 60 of 65