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

  1. SITS: Export field code and namehttps://www.joellipman.com/articles/cms/website-development/xml/sits-export-field-code-and-name.html

    the code and the lookup value in our XML to our Staging environment. Why? Let's take the country of birth of a person as an example as it is expected to be a long list and where just using the parameter &S is not workable. Instead I want to use &G[] and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *
  2. Excel PivotTable Filter List Orderinghttps://www.joellipman.com/component/content/article/excel-pivottable-filter-list-ordering.html?catid=110&Itemid=165

    order at first. If any new values come along then they get added to the bottom of the list... This is the problem. For example, if the year dropdown has a list of 2010, 2011, 2013; then if you add an entry which has year 2012, then the dropdown list...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  3. Stop Excel Row Height Self-Adjust on Refreshhttps://www.joellipman.com/component/content/article/stop-excel-row-height-self-adjust-on-refresh.html?catid=110&Itemid=165

    tables and displays the data in an Excel Spreadsheet. The Problem We can select all cells and set row height to be 30 for example, but everytime we refresh the data in the Excel spreadsheet, all the rows get re-adjusted to fit the data and lose that...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  4. Is it a scam? Gumtree.com's warning signshttps://www.joellipman.com/component/content/article/is-it-a-scam-gumtreecoms-warning-signs.html?catid=116&Itemid=165

    than the value of the items/rent/job. They’ll then ask for the surplus money to be returned to them or a third party, for example ‘to pay for shipping’. The cheque will clear into your bank account, only to be refused weeks later. At this point, the...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  5. Regular Expressions in SQLhttps://www.joellipman.com/articles/else/database/regular-expressions-in-sql.html

    start. This article serves as a quick note on how to use regular expressions within SQL statements: How? For the following examples, I am pretending to select rows from a table called `STUDENTS`. Oracle PL/SQL Looking for abnormal data, note the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *
  6. Zoho Cliq: Integrate OpenAI ChatGPT with Conversation Threadshttps://www.joellipman.com/articles/crm/zoho/zoho-other/zoho-cliq-integrate-openai-chatgpt-with-conversation-threads.html

    has the necessary scope(s). Note that you have to do this as the super admin to get organization level messages. But in ths example below, we're going to query a message to the ChatGPT bot: // // initialize m_Response = Map(); v_Message =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  7. Add Image Mouseover effect in AutoHotkey GUIhttps://www.joellipman.com/component/content/article/add-image-mouseover-effect-in-autohotkey-gui.html?catid=48&Itemid=165

    to get the tooltip to show until I realised you have to specify the tooltip text BEFORE the gui,show command. The above example is used in a search form where "SearchButton" is the name of the variable (picture) to change. Note that I am using the...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  8. Prefix Line Numbers in a Text Filehttps://www.joellipman.com/component/content/article/prefix-line-numbers-to-a-text-file.html?catid=51&Itemid=165

    > Type "COMMAND" > Enter) [Optional] Browse to the folder that contains the file (or use full path in path reference). This example assumes the file is in C drive (C:\). Create an empty text file (Type "ECHO > TEMP.TXT") Type "FC /N /LB 300...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: *
  9. 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

    the strings match any part of the absolute path of the file to be copied, that file will be excluded from being copied. For example, specifying a string like \obj\ or .obj will exclude all files underneath the directory obj or all files with the .obj...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
  10. Joes Network Transmission Detector (JTD)https://www.joellipman.com/component/content/article/joes-network-transmission-detector-jtd.html?catid=53&Itemid=165

    What's it detecting? Currently it just reads the size of packets sent and received. This allows me to test websites for example and compare page loads. It's more fun on a networked computer which is constantly writing back and forth to network shares,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  11. Joes Revolver Map (JRM)https://www.joellipman.com/component/content/article/joes-revolver-map-jrm.html?catid=53&Itemid=165

    and associate it with just your site, you'll need to visit www.revolvermaps.com and take your ID from the script code: For example: rm_f1st('0','280','true','false','000000','3sv7MUqXeMI','true','ff0000'); or The Unique ID code would be "3sv7MUqXeMI"...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  12. Zoho Deluge: Adding / Removing Total Tax from a Quote Recordhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-adding-removing-total-tax-from-a-quote-record.html

    want this to be zero, you need to pass the option of tax as zero and remove all other options. Take the following code for example, this will add 20% tax to the overall Tax on this record (where p_QuoteID is the ID of the quote): // init Map...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  13. Zoho Deluge - Modify the product line items in an invoice modulehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-modify-the-product-line-items-in-an-invoice-module.html

    the trick is to remove the existing ID of the line item and posting the map back to the record. In the following example, we are swapping out the product "123456789012345678" with the product "987654321098765432" and p_InvoiceID is the ID of the invoice...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  14. Zoho CRM/Creator - Common Errors & Gotchashttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-creator-common-errors-gotchas.html

    headers:m_Header ]; Problem: Value is empty and 'get' function cannot be applied Following a post similar to the above example by InvokeURL and then getting a JSON response back, the response does not seem to be read as a map: r_Response = invokeurl [...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  15. Zoho Deluge: Search Records with Special Characters (COQL)https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-search-records-with-special-characters-coql.html

    > Connections Click on Get Started / Add New Connection Click on the "Zoho OAuth" icon Enter a Connection name (for this example I will call it "CRM API v2") Select the appropriate scope(s): ZohoCRM.coql.READ Required!...

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

    loading another framework considering that Zoho Creator has their own version of Bootstrap and jQuery. This is the first example I have where you would want dynamic content in a Zoho Creator page without the use of JavaScript or 'Widgets JS'. How? Here...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  17. Zoho Deluge: Sort a Map by a specific fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-sort-a-map-by-a-specific-field.html

    code to me on sorting a map variable in Zoho Deluge, specifically Zoho Creator. Why? I do this a lot but in the following example, I want to sort a list of records by their date in descending order. Yes this functionality exists in reports but I want to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  18. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments)https://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-download-file-from-zohocrm-field-type-file-upload-not-attachments.html

    CRM module). The Solution So as a quick overview, this is what I did: Create a ZohoCreator form (I'm calling mine in this example: Download File to hold the file and some other fields Owner Email (type: Email) FIle Name (type: Single Line) File Ref...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  19. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party APIhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-post-a-multi-dimensional-or-nested-array-to-a-3rd-party-api.html

    documenting how to send a Zoho Deluge Map request to an API which is expecting nested/2d/multi-dimensonal arrays. In the example below, we are posting to a PHP script for testing but I have since sent something similar to an API expecting nested arrays...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  20. Zoho Projects: Deluge to Submit Custom Fieldshttps://www.joellipman.com/articles/crm/zoho/zoho-projects/zoho-projects-deluge-to-submit-custom-fields.html

    A super quick article to demonstrate an example where we create a project with custom fields. Why? At time of print, the documentation on the Projects API would only show responses rather than requests. Sure it lists fields that are required in the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Projects
    • Language: *
Results 61 - 80 of 175