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

  1. CSS Printing - Page Break Inside with Headers and Footershttps://joellipman.com/articles/web-development/css/css-printing-page-break-inside-with-headers-and-footers.html

    page (background image filling the page with a logo floating at the centre) and the next page has a table which is of variable length. Fine when the table was short and didn't have many rows. But the client will pick up the phone to you when the table...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *
  2. Zoho Deluge - Get Refresh/Access Token API v2https://joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

    = invokeUrl [ url :v_EndPoint type :PUT headers: m_Header parameters:m_Data.toString() ]; // NOTE: convert parameters variable to a string Common Error(s): {"error":"invalid_code"}: Happens if you have a wrong CODE or generated another one after the one...

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

    work on the CRM record: // assuming I have a creator form called "myForm" // that the ID of the record is the value of the variable "myRecordID" // that a subform exists in the form called "Attachments" // that a field exists in the subform called...

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

    This is a quick article to template some 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. Zoho Creator: Receive JSON via a Shopify Webhookhttps://joellipman.com/articles/crm/zoho/zoho-creator-receive-json-via-a-shopify-webhook.html

    app name respectively) Update 2022: I've included the code to verify the webhook came from Shopify: // // declare response variable back to Shopify m_Response = Map(); // // enter webhook key featured in the "settings > notifications > webhooks" section...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  6. Zoho Deluge: Calculate Days, Hours, Minutes, Seconds between two Timestampshttps://joellipman.com/articles/crm/zoho/zoho-deluge-calculate-days,-hours,-minutes,-seconds-between-two-timestamps.html

    but here's one in Zoho Deluge. How? We're going to make use of the .toLong() function applied to a datetime datatype variable which will return the Unix seconds. // the now time v_NowTime = zoho.currenttime; // // correction: I want to specify a from...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  7. Zoho CRM: Get Unique Values of a Text Fieldhttps://joellipman.com/articles/crm/zoho/zoho-crm-get-unique-values-of-a-field.html

    they realised they would get the same results, and then suggested looping through all records and creating a distinct list variable... But what if there are 20000+ records? The advantage of working in a team of Zoho developers, is that "two heads are...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  8. Zoho Creator/Deluge: UnPredictable exception, Invalid statement foundhttps://joellipman.com/articles/crm/zoho/zoho-creator-deluge-unpredictable-exception,-invalid-statement-found.html

    simply, I'm using 2 for each loops and this is one of those scenarios where you need to store the loops into different variable names: // select a bunch of creator records (ok all of them) l_AllRecords = myForm[ ID != 0 ]; // // loop through these for...

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

    so here's the quick parsing instruction to get the eBay photos; this snippet 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: *
  10. ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

    you can ask me... with one being "Ask ChatGPT" Click on it and then ask away:... Keeping a Conversation So annoyingly, the variable broadcast was unreliable in storing message conversations despite it's purpose being ideal. Instead, let's use a CRM...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  11. Zoho Books: System Values Mapshttps://joellipman.com/articles/crm/zoho/zoho-books-system-values-maps.html

    so for multiple instances of ZohoBooks for the same organization, a separate call would need to be made with a different variable org ID. /* ******************************************************************************* Function: Map...

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

    The criteria is in the same syntax format as the one used in the Search API call. Code-wise using the same criteria variable for both calls might offer some consistency. Notes on the attribute: Criteria You can't compare a date time value to a field...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  13. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

    user with photos displaying; also supported a PDF export with images instead of URLs. Error(s): 8504. Ensure the columns variable is converted to a string.

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

    function var o_ParsedQuote = JSON.parse(JSON.stringify(r_QuotedRecord)); // valid? note the underscore before the details variable a_QuotedItems = []; if (o_ParsedQuote._code == "SUCCESS") { if (o_ParsedQuote._details !== undefined) { if...

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

    function here as it would use my credentials but what you need to know is that it is passed the crmAPIRequest (string) variable and that the function itself had to have API Key and OAuth enabled (hover over function in CRM setup and select REST API,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  16. Converting SQL date in PHP to European date format and vice-versahttps://joellipman.com/articles/web-development/php/converting-sql-date-in-php-to-european-date-format-and-vice-versa.html

    strpos($this_date, " ")+1)); $formatted_datetime=implode("/", array_reverse($this_date_array))." ".$this_time; Replace the variable names and the SQL column and table names as per your setup. Converts 2001-06-25 09:41:00 to 25/06/2001 09:41:00 And...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  17. $_SERVER['http_referer'] returns blank in Internet Explorerhttps://joellipman.com/articles/microsoft/serverhttpreferer-returns-blank-in-internet-explorer.html

    Thought I'd put a note about this as I spent ages rewriting an entire system. The HTTP_REFERER environment variable can be changed by the user anyway but I was using it as an additional validation check. The only solution is to not use it for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Microsoft
    • Language: en-GB
  18. SQL: Use CASE for Relevance columnhttps://joellipman.com/articles/database/mysql/sql-use-case-for-relevance-column.html

    which has to find relevant terms to autofill/autocomplete a search form: -- where @ThisSearch is a posted (and sanitized) variable SET @ThisSearch:="Brains"; SELECT columnID, columnFullName, CASE WHEN columnFirstName LIKE @ThisSearch THEN 20 WHEN...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  19. A for loop within a for loop in MS-DOShttps://joellipman.com/articles/automation/ms-dos/a-for-loop-within-a-for-loop-in-ms-dos.html

    trust these more than my all-in-one GUI applications. How? Note: we're using the code in a DOS Batch program so our variables have to be prefixed with a double-percent rather than just the one: -- the following loops through directory for any file...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
Results 41 - 59 of 59

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.