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

  1. MySQL: Count occurrences of words in a columnhttps://joellipman.com/articles/database/mysql/mysql-count-occurrences-of-words-in-a-column.html

    database column by order of most used first (replace 'mydbprefix_content' with the name of your database table AND `introtext` with the name of your column): SELECT SUM(`total_count`) as `total`, `value` FROM ( SELECT count(*) AS `total_count`,...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  2. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

    this only appears to accept Microsoft Word Documents and Adobe PDF files! Applicable to Zoho Books. If the user attaches text files (TXT) these will only attach to the Sales Order in the CRM record but not to the Sales Order in Zoho Books.. Source(s):...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  3. Zoho Deluge: Get Image Uploaded in Creator Formhttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-image-uploaded-in-creator-form.html

    form called "MyImages" and an image upload field that has the field link name "MyImage". There is an additional single-line text field called "Name". I have added an entry with name "Logo" and I have uploaded an image accordingly. // change this to eu...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  4. Zoho Deluge: Generate List of TimeZoneshttps://joellipman.com/articles/crm/zoho/zoho-deluge-generate-list-of-timezones.html

    a bit and wanted a quick way of extracting a SELECT list in someone else's form. How? So, let's copy the HTML select into a text editor, then escape the double-quotes, then prepend with a list declaration and append with a end of list suffix; loop...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. Zoho Creator: Change Radio into Tabshttps://joellipman.com/articles/crm/zoho/zoho-creator-change-radio-into-tabs.html

    but ensure the labels are still visible (I can hide all labels in this group except for those with class "choice-label-text"): v_Css = ""; v_Css = v_Css + ".zc-Tabs-group label{display:none !important;}"; v_Css = v_Css + ".zc-Tabs-group...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  6. ZohoCRM & Xero Real-Time Invoices: Receive Webhookhttps://joellipman.com/articles/crm/zoho/zohocrm-xero-real-time-invoices-receive-webhook.html

    just created, click on the 3 dots/ellipsis and select "REST API" Switch on the API Key and copy the URL to clipboard or a text editor Click on "Save" Setup a Xero webhook: Login to the page https://developer.xero.com and click on "My Apps". Select the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  7. Zoho Analytics: Setup DataSource via FTP Connectionhttps://joellipman.com/articles/crm/zoho/zoho-analytics-setup-datasource-via-ftp-connection.html

    - 136.143.177.255 136.143.190.0 - 136.143.190.255 The file on the FTP server to download can be of type: CSV, TSV, Text, Excel, MS Access DB, HTML, JSON, XML and others: Supports server types of FTP, FTPS - File Transfer over Explicit TLS/SSL, FTPS -...

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

    stores the URL of each picture in a list variable: l_Pictures = x_MainNode.executeXPath("//Item/PictureDetails/PictureURL/text()").toXmlList(); // yields //...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  9. Zoho Analytics: Set Up a Widget Displaying Sales Personhttps://joellipman.com/articles/crm/zoho/zoho-analytics-set-up-widget-displaying-sales-person.html

    Value As", select Max Then click on the "Settings" tab and do the following: Under Primary Value - Label, enter the static text you want to display above the sales person (eg. "Sales Person") Alongside the Value field, enter ${Sales Person}.LABEL Under...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  10. Joel's Reference to MidJourney v4 Promptshttps://joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

    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 from a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
  11. ZohoCRM: Using Criteria with Module Record Counthttps://joellipman.com/articles/crm/zoho/zohocrm-using-criteria-with-module-record-count.html

    and between. The supported data types are picklist, id, owner_lookup, user_lookup, lookup, phone, email, date, datetime, text, textarea, integer, currency, decimal and double. You can search for a maximum of 10 criteria (with same or different columns)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  12. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

    // _ m_Parameters = Map(); m_Data = Map(); m_Templates = Map(); m_Actions = Map(); m_FieldData = Map(); m_FieldTextData = Map(); m_FieldBooleanData = Map(); m_FieldDateData = Map(); l_Actions = List(); //...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  13. ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttps://joellipman.com/articles/crm/zoho/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

    from the quote that was converted to the invoice. For this to work, we've mapped a field on the invoice (not a lookup but a text field) which when a quote gets converted to an invoice, will map over the quote ID to the field "Converted From ID"....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. Hide Menu Item from Registered and Special https://joellipman.com/articles/cms/joomla/hide-menu-item-from-registered-and-special.html

    e.g. Code: Joomla extension disable menu link for registered users but not for public More Information: not so great, lot of text: http://help.joomla.org/content/view/476/146/

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  15. Splatter Logohttps://joellipman.com/graphic-design/splatter-logo.html

    to be able to run several programs at the same time and simplicity is king. In PaintShop Pro you would simply: How? Insert text as floating, leave the selection on Create a new layer beneath Go to Selection > Modify > Expand > 10 px Fill this selection...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
  16. Add default to a picture buttonhttps://joellipman.com/articles/automation/autohotkey/add-default-to-a-picture-button.html

    y70 w90 h90 vSearchButton gSearch, %A_ScriptDir%\images\program\search_button.png Add the input field where you type the text: Gui, Add, Edit, x55 y95 r1 w550 vSearchTextInput, Search... Add the submit button with a hidden attribute: Gui, Add, Button,...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  17. Added a Launcher and Unduplicaterhttps://joellipman.com/component/content/article/added-a-launcher-and-unduplicater.html?catid=87

    files and modify these to suit your needs. The new programs also read off a configuration file which you can modify in any text editor in order to tweak the program to suit your needs. Launcher v2.0 is crude replacement to the quick launch toolbar which...

    • Type: Article
    • Author: Joel Lipman
    • Category: Products
    • Language: *
  18. Mouseover Links in AutoHotkeyhttps://joellipman.com/articles/automation/autohotkey/mouseover-links-in-autohotkey.html

    ; CREATE GUI Gui, Color, FFFFFF Gui, +OwnDialogs +SysMenu +Caption +0x800000 Gui, Add, Text, gOpenDocumentation, Open the documentation Gui, Show, w600 h700, %ThisProgramName% WinSet, AlwaysOnTop, On, %ThisProgramName% OnMessage(0x200, "WM_MOUSEMOVE")...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  19. Excel: Extract hyperlink from linkhttps://joellipman.com/articles/microsoft/excel/excel-extract-hyperlink-from-link.html

    A quick article on if you want to extract the link from some text you have copied off the web and into an MS Excel document. How? Open up a new workbook. Get into VBA (Press Alt+F11) Insert a new module (Insert > Module) Copy and Paste the Excel user...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  20. CSV Chart Generatorhttps://joellipman.com/component/content/article/csv-chart-generator.html?catid=40

    and Pie). Note that AMCharts.com is free as long as you leave the copyright information. If you want to remove the copyright text that displays on the charts, you need to buy the products of AMCharts.com. I have no afiliation with these and I myself...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
Results 101 - 120 of 121

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Please publish modules in offcanvas position.