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

  1. Zoho Deluge: Calculate Days, Hours, Minutes, Seconds between two Timestampshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-calculate-days,-hours,-minutes,-seconds-between-two-timestamps.html

    A very quick article to calculate the time between two timestamps and break it down into days, hours, minutes and seconds. Why? I've done this in lots of other systems but here's one in Zoho Deluge. How? We're going to make use of the .toLong() function...

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

    { if(r_TimeZone.get("display_value").containsIgnoreCase(v_TimeZone)) { v_CustomerTimeZone = r_TimeZone.get("display_value"); break; } } } } } } // // if not blank then we found the correct timezone picklist option if(v_CustomerTimeZone != "") {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  3. Zoho CRM: searchRecords with sorted resultshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-searchrecords-with-sorted-results.html

    info r_Result.get("id"); } } // // stop looping if less than 200 records on this page if(l_SearchResults.size()...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  4. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile)https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-using-a-function-for-validation-rules.html

    in r_UserDetails.get("users") { if(!isnull(r_User.get("profile"))) { v_UserProfile = r_User.get("profile").get("name"); break; } } } } // // get field value that we want to check for v_LeadStatus = ""; if(!isnull(m_Webhook.get("record"))) { // //...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  5. Zoho Analytics: Determine profits from invoices and purchase ordershttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-determine-profits-from-invoices-and-purchase-orders.html

    may be associated to sales orders changed after being confirmed or missing associated purchase orders altogether. I had to break this down into several queries to generate the dataset, then use these as pseudo-subqueries. The first task was to determine...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  6. Zoho Books: Generate Bank Text File for Downloadhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-books-generate-bank-text-file-for-download.html

    = r_Attachment.get("documents"); for each r_Doc in l_DocumentResponse { v_DocumentID = r_Doc .get("document_id"); break; } // // open/download the file immediately to workstation openurl("https://books.zoho.com/api/v3/documents/" + v_DocumentID +...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  7. ZohoCreator: Basic Widget with Zoho Datahttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zohocreator-basic-widget-with-zoho-data.html

    // quick loop to find the preferred name for(var index in recordArr){ v_GreetingName = recordArr[index].Nick_Name; break; } // if not blank then let's display it if(v_GreetingName != "") { // can't seem to do jQuery references within this SDK...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  8. Zoho Deluge and Wordpress/WooCommerce API: Get All Productshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-and-wordpress-woocommerce-api-get-all-products.html

    list l_AllProducts.addAll(l_ThisList); // // stop the loop if there weren't any more products if(l_ThisList.size()...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  9. Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

    c_AddedBy = Staff[Zoho_Creator_User == zoho.loginuser]; if(c_AddedBy.count() > 0) { v_AddedBy = c_AddedBy.Name; } break; } } %> /* page sizing */ @page { size: A4; margin: 0; } /* CSS for when opting to print rather than render in PDF */ /* Overridden...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  10. Zoho Analytics & Zoho People: Monitor DataSource Sync https://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-zoho-people-monitor-datasource-sync.html

    v_LastSyncStatus = m_DataSource.get("lastDataSyncStatus"); m_DataSourceInfo = m_DataSource; break; } } } //info m_DataSourceInfo; // // to email or not to email, that is the question, whether 'tis nobler in the mind to suffer......

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  11. Zoho CRM: Remove Duplicate Product Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-remove-duplicate-product-records.html

    } else { l_DebugNotes.add("No Action."); } info v_Debug + l_DebugNotes.toString(". "); } if(l_UniqueProducts.size() == 0) { break; } } return "Deleted " + v_CountDeleted + " of " + v_CountTotal; }

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

    for each m_Data in l_Datas { l_QuotedItems = ifnull(m_Data.get("Quoted_Items"),List()); break; } // return l_QuotedItems; }

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  13. Zoho CRM Client Script: Map Quote to Invoicehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-client-script-map-quote-to-invoice.html

    a_QuotedSalesOrders[i].Status !== "Expired") { // found one so let's bail v_FirstSalesOrderID = a_QuotedSalesOrders[i].id; break; } } // if not null (was found) then let's assign it to this invoice if (v_FirstSalesOrderID != null) { // retrieve the deal...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  14. MacOs: Transcribe Training Video using OpenAI Whisperhttps://www.joellipman.com/component/content/article/macos-transcribe-training-video-using-openai-whisper.html?catid=60&Itemid=165

    ~/.zshrc Test It whisper --help Run the whisper on the original MP3: whisper output_audio.mp3 --model small Error(s): PATH breaks, no commands work: echo 'export PATH="/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin:/Users//Library/Python/3.9/bin"' >...

    • Type: Article
    • Author: Joel Lipman
    • Category: Apple
    • Language: *
  15. Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/component/content/article/google-drive-oauth-using-service-account-in-php.html?catid=61&Itemid=165

    impersonator and you have NOT authorized this service account via the G-Suite Administrator settings, then this script will break. Once you have authorized the service account, you can then put the email of the user the service account will be...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  16. SSIS Convert a string into a datehttps://www.joellipman.com/component/content/article/ssis-convert-a-string-into-a-date.html?catid=74&Itemid=165

    ? (DT_DATE)"1900-01-01" : (DT_DATE)This_Date -- last column when datasource is flat file (account for line break): ISNULL(Last_Column) ? "" : TRIM(Last_Column) Last Troubleshooting Check: The problems here relate to when our datasource was a flat file...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  17. Include a carriage return in a column headinghttps://www.joellipman.com/component/content/article/include-a-carriage-return-in-a-column-heading.html?catid=78&Itemid=165

    from a data source located on a database on the other side of the world. I want the header in the column "Academic Week" to break across two lines so that the column doesn't expand to the width of "Academic Week" and instead expands to the width of the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server
    • Language: *
  18. Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/component/content/article/running-internet-explorer-6-7-8-as-standalones.html?catid=80&Itemid=165

    v0.4.3 (Returned different results from my IE7 tests) ie6olas_nt (from http://browsers.evolt.org - works but installing IE8 breaks it) ie6setup.exe (from Microsoft's website advising on Run > c:\\download\\ie6setup.exe /c:"ie6wzd.exe /d:1 /s:""#E") If...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  19. PHP & MySQL Search Enginehttps://www.joellipman.com/articles/cms/website-development/php/php-a-mysql-search-engine.html

    foreach ($levenshtein_words as $word) { $lev = levenshtein($term, $word); if ($lev == 0) { $closest = $word; $shortest = 0; break 1; } if ($lev 0)?"Did you mean: ".$didyoumean_string_joined."?":""; $didyoumean_words_array=array(); // Note: for some...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  20. Convert Past Date to Time Ago in PHPhttps://www.joellipman.com/articles/cms/website-development/php/convert-past-date-to-time-ago-in-php.html

    floor(($s%3600)/60), floor($s%60), ); for($i=0;$i0 ? $a2[$i].' '.$a1[$i] : ''; $str .= $a2[$i]>1 ? 's' : ''; if($str!='') break; } return $str.' ago'; } If you want the first 4 words but minified (eg. "1 week and 2 days ago"): function getTimeAgo($p) {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
Results 21 - 40 of 45