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

  1. Sort an associative array by values in Javascripthttps://www.joellipman.com/articles/web-development/js/sort-an-associative-array-by-values-in-javascript.html

    What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: *
  2. Accessing Apimo WebService APIhttps://www.joellipman.com/articles/automation/api-misc/accessing-apimo-webservice-api.html

    XML declaration from results $output = substr($output, stripos($output, '?>') + 2 ); // remove leading spaces, carriage returns $output = trim($output); // process if type specified was xml if($apimo_type=='xml'){ // send header...

    • Type: Article
    • Author: Joel Lipman
    • Category: API Miscellaneous
    • Language: *
  3. Pure JS - Display Time Elapsed & Remaininghttps://www.joellipman.com/articles/web-development/js/pure-js-display-time-elapsed-remaining.html

    seconds_remaining--; seconds_elapsed++; if(seconds_remaining>=0){ document.getElementById("time_remaining").innerHTML = returnTime( seconds_remaining ); document.getElementById("time_ago").innerHTML = returnTime( seconds_elapsed ); } } function...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: *
  4. Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

    4. Declare a PHP function to send requests using cURL A standard function that is skipping the SSL checks and returns a PHP array function send_request($url, $header, $data, $method="GET") { $ch = curl_init(); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  5. Excel - Check a column for values found in another columnhttps://www.joellipman.com/articles/microsoft/excel/excel-check-a-column-for-values-found-in-another-column.html

    Where: SumProduct( is a function to multiply two ranges together (must be the same size) and return the total of these results. -- is a double hyphen/dash which converts a boolean true to 1 and boolean false to 0. IsNumber( is a function returning a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  6. URL Alias uniqueness with PHP & MySQLhttps://www.joellipman.com/articles/web-development/php/url-alias-uniqueness-with-php-mysql.html

    single one (eg. "my_____test" yields "my_test") $v_Output = preg_replace("#((\_){2})\\2+#", "$2", trim($v_Output, "_")); // returns a string return $v_Output; } and the MySQL is a trigger which executes before the record is inserted and increments the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  7. CSS Add Text to Breadcrumb Link with a Transitionhttps://www.joellipman.com/articles/web-development/css/css-add-text-to-breadcrumb-link-with-a-transition.html

    on it: What I have » Home / Products / Lanterns What I want (on mouseover) // if I hover the mouse over the "Home" link: » Return to Home / Products / Lanterns // if I hover the mouse over the "Products" link: » Home / More Products / Lanterns // if I...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *
  8. Zoho Creator: Retrieve record with case-insensitive queryhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-retrieve-record-with-case-insensitive.html

    the product exists because it is searching with case-sensitivity enabled. It tries to insert into the product table, but returns the error "Result: Error on Execution" > "Error details: Execution Failed Due to invalid expressions insert statement is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  9. Zoho Deluge: Setup an API Connection for InvokeURLhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-setup-an-api-connection-for-invokeurl.html

    Secret, make a note of these or leave this window to copy&paste into the next step. Setting up the Oauth Connector So return to your Zoho Books instance (or Subscriptions, Inventory, app you were making the connection): From within books (or inventory,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  10. Zoho Creator: Button on Report for Merging Multiple Selected Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

    a name select "Deluge" as the language give it a Namespace (for this example I will leave this on "Default") and set the return type (again in this example, I will leave this as "void") for Arguments Specify a parameter name of your choosing, in our...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  11. Zoho Projects: Add a Time Log to an Issue using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-projects-add-a-time-log-to-an-issue-using-deluge.html

    meridian (even if you are using projects.zoho.eu) input.Start_Time.toString("hh:mm a"); // additional note: "13:00 PM" will return this error as well Source(s) Zoho Projects - Timesheets API Zoho Deluge - Date-Time Functions - toString

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

    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 datetime...

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

    This article demonstrates how to return a list of unique values in a particular field in a CRM module. Why? My use-case is a data-migration where the records exist in a staging module in CRM but I want to transform/translate one of the column values...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng)https://www.joellipman.com/articles/crm/zoho/zoho-crm-deluge-get-timezone-based-on-geocoded-address-lat-lng.html

    builds up the address from a Lead record to geocode into latitude and longitude coordinates to feed a third-party API which returns a timezone. Why? Our use-case is that we have a field called "Customer's Time Zone" on the lead record in ZohoCRM. It...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  15. Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-text-sms-using-twilio-api-localsense.html

    r_TwilioResponse = invokeurl [ url :v_Endpoint type :POST parameters:m_Data ]; // // display to user/developer the response return r_TwilioResponse; Adapting it to trigger off a scheduled workflow of a call/meeting Login to ZohoCRM > Setup > Automation...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  16. Zoho Deluge: a HTML Entity Decoderhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-a-html-entity-decoder.html

    { v_StringToDecode = v_StringToDecode.replaceAll(v_HtmlKey, m_HtmlEntity.get(v_HtmlKey), true); } // // output return v_StringToDecode; } Usage: v_TestString = "Father & Sons"; v_DecodedString =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  17. Zoho Desk: Re-enable Desktop Notifications after clicking on "Not Now"https://www.joellipman.com/articles/crm/zoho/zoho-desk-re-enable-desktop-notifications-after-clicking-on-not-now.html

    click on “Clear” Then also click on “Reset Permissions” (usually only if you enabled notifications previously) > Reset Return to Zoho Desk and you will get the popup to enable Desktop Notification Click on “Enable” Then click on “Allow” (browser popup...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  18. Zoho Books/Inventory: Trigger a workflow when an invoice has been paidhttps://www.joellipman.com/articles/crm/zoho/zoho-books-inventory-trigger-a-workflow-when-an-invoice-has-been-paid.html

    for each r_Result in l_SearchResults { if(!isnull(r_Result.get("payment_id"))) { // // invalid searches will return 200 results non-matching, so let's double-check if(r_Result.get("invoice_numbers").containsIgnoreCase(v_InvoiceRef)) { // retrieve...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  19. Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM templatehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-send-an-email-with-a-crm-quote-using-a-given-crm-template.html

    :file:f_FileRequest ]; } else { v_OutputMessage = "No email was specified on this record. Cannot send this quote."; } return v_OutputMessage; Update: What is the URL to download the PDF in Zoho Books? Found this today so thought I'd add it to this...

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

    be better as changes to your settings may limit your discovery of the variations and styles. Type /settings then enter/return twice Storing prompts as quick commands Type /prefer option list to see what custom options you already have. By default you...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
Results 141 - 160 of 180

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.