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

  1. ZohoCRM: Import Attachmentshttps://joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

    below but also to document the import process of a bunch of files into a ZohoCRM system. Why? Our use-case here is a data migration for a client from a legacy CRM to ZohoCRM. They have a lot of files they want attached to their respective records in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  2. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://joellipman.com/articles/crm/zoho/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

    v_Endpoint type: GET connection: "ab_cliq" ]; // // let's build up the conversation thread if(!isnull(r_ChatDetails.get("data"))) { for each r_MessageData in r_ChatDetails.get("data") { v_Role = "user"; if(!isnull(r_MessageData.get("message_source"))) {...

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

    + p_QuoteID + "?fields=Quoted_Items" type :GET connection:"j_crm" ]; // // should only be 1 record but respecting JSON data structure and parse l_Datas = ifnull(r_QuoteDetails.get("data"),Map()); for each m_Data in l_Datas { l_QuotedItems =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  4. MySQL Commands to display all columnshttps://joellipman.com/articles/database/mysql/mysql-commands-to-display-all-columns.html

    that I wanted a PHP/MySQL extension created which needs to launch a query to find all columns across the tables of the local database which had valid content to extract keywords from. The following is a MYSQL query that displays the structure of all the...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  5. SITS: XET format for Export not availablehttps://joellipman.com/articles/web-development/xml/sits-xet-format-for-export-not-available.html

    but I want to use the XET template I created rather than the pre-installed XML export formats. When I try to export using data format XET, the system has never heard of it. Why? To test the XET I created, I want to see what the resulting XML will look...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *
  6. CSV Chart Generatorhttps://joellipman.com/component/content/article/csv-chart-generator.html?catid=40

    that can take an exported CSV list from a standard MS Windows eventlog or eventviewer log and generate a chart from the data. What my program does is convert all the data into a settings and data file that can be used by the charting system...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  7. MS Excel - Open CSV with Long Numbershttps://joellipman.com/articles/microsoft/excel/ms-excel-open-csv-with-long-numbers.html

    a CSV in MS Excel but without converting long numbers into exponential notations (which are incorrectly rounded anyway). My Data: Account ID,Name,Phone,Record ID 1457102000000135533,Joel,00441234567890,1457102000000165989...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  8. Checklist for the local computer repairshttps://joellipman.com/hardware/checklist-for-the-local-computer-repairs.html

    hourly rate "I always had work order forms in duplicate. Right above the signature line was a BIG BOLD WARNING ABOUT LOSS OF DATA and “Check this box to have your data backed up for $75. Then, I’d charge them $150 for “forensic data recovery” with “no...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  9. Sort order a dropdown list in MS InfoPath without programminghttps://joellipman.com/articles/microsoft/infopath/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html

    So this is for Microsoft Office Infopath 2007 (SharePoint 2007). The situation is that I started creating a SharePoint List (datasheet) and when I made my form dropdown read from the list, it just put elements in the order that I entered them in the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Infopath
    • Language: *
  10. The ReportServer Databasehttps://joellipman.com/articles/database/the-reportserver-database.html

    I have just spent all morning on Microsoft websites to determine what number is the TimeDataRetrieval column displaying. Thank you I know it's an INT. There is just a serious lack of documentation as to what this database is and how it populates its...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  11. Joes Network Transmission Detector (JTD)https://joellipman.com/component/content/article/joes-network-transmission-detector-jtd.html?catid=40

    add to the network traffic, this program adds NOTHING to the network traffic, and therefore is a much better measure of what data is being received/sent from your workstation. Download Available for download for FREE as OpenSource. Portable so no...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  12. Basic Joomla 2.5 Mootools Formhttps://joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

    This form is more AJ than AJAX as I don't even use an XML file. You'll need to create a receiving file that sends back the data, in my case, I've called it ajax.form.php and the contents of which are: This just prints back an array of data that was sent...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  13. Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html

    shared libraries and dynamically linked subprograms that the work is specifically designed to require, such as by intimate data communication or control flow between those subprograms and other parts of the work. The Corresponding Source need not...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  14. Include a carriage return in a column headinghttps://joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

    or new line into the column name/alias (the header). It might seem trivial but these little aesthetic changes done at the database level can save some time. Why? I have an Excel report which dynamically gets its content from a data source located on a...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server
    • Language: *
  15. Submit form as a server and not the client with cURLhttps://joellipman.com/articles/automation/api-misc/submit-form-as-a-server-and-not-the-client-with-curl.html

    how to submit a HTML form to a server via your Mobile application so the following will only document the process of sending data under the server IP address. We're going to use a PHP script with the cURL function to receive and send the data. cURL is a...

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

    Click Create and Connect You will be prompted to allow permissions, so click on "Accept/Allow" 2. Determine the client datacenter Look at the URL (website address) of the CRM you are wanting to do this on. The part after Zoho is the top level domain...

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

    So to give you a gist of what the following snippet of code is doing, let me give an overview: Build up a map with sample data (you won't need to this, use your own data, this one is for this demonstration only) Initialize a list to hold the keys which...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  18. Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://joellipman.com/articles/crm/zoho/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

    the following: // temporarily disable auto-update preview input.Update_Preview=false; // // do stuff here... eg getting data fields, generating a title and setting the title: input.Title = " Hello World "; // // output input.Note_Preview = input.Title;...

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

    the application so that any order is sent to a URL, specifically a CRM REST API function that will forward the payload data to Zoho Creator (Yes you will need CRM version Enterprise or Zoho One [that supports functions] for this process). So first off,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  20. Zoho CRM & Deluge: Adding 10 minutes to a CRM Date Time fieldhttps://joellipman.com/articles/crm/zoho/zoho-crm-deluge-adding-10-minutes-to-a-crm-date-time-field.html

    and wanted a refresher for use in a client system. The usual error is something similar to the following: { "code": "INVALID_DATA", "details": { "expected_data_type": "datetime", "api_name": "Check_Date_Time" }, "message": "invalid data", "status":...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 81 - 100 of 218

Please publish modules in offcanvas position.