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

  1. Zoho Creator: isBlank and isNull: Before or After?https://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-isblank-and-isnull-before-or-after.html

    is a BLANK String"; v_Test = ""; if(isBlank(v_Test)) { info "isBlank Preceding is TRUE"; } else { info "isBlank Preceding is FALSE"; } if(v_Test.isBlank()) { info "isBlank Succeeding is TRUE"; } else { info "isBlank Succeeding is FALSE"; }...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  2. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://www.joellipman.com/component/content/article/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html?catid=61&Itemid=165

    $mime_type, $name) { global $GAPIS; $ch1 = curl_init(); // don't do ssl checks curl_setopt($ch1, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch1, CURLOPT_SSL_VERIFYHOST, false); // do other curl stuff curl_setopt($ch1, CURLOPT_URL, $GAPIS....

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  3. MS Excel - Split Workbook into separate files per sheethttps://www.joellipman.com/component/content/article/ms-excel-split-workbook-into-separate-files-per-sheet.html?catid=110&Itemid=165

    Num Rows per Sheet", xTitleId, 5, Type:=1) Set xWs = WorkRng.Parent Set xRow = WorkRng.Rows(1) Application.ScreenUpdating = False For i = 1 To WorkRng.Rows.Count Step SplitRow resizeCount = SplitRow If (WorkRng.Rows.Count - xRow.Row + 1)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  4. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeroshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-regex-rounding-and-or-removing-trailing-zeros.html

    double-backslash with a single backslash: v_Test1 = 12.300; info v_Test1.toString().replaceAll("(\\.\\d*?[1-9])0+$", "$1", false); // yields 12.3 // same expression again but with a different value v_Test2 = 12.000; info...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  5. Parse a HTML Table into a ListViewhttps://www.joellipman.com/articles/cms/website-development/html/parse-a-html-table-into-a-listview.html

    after Needle1a Needle2a := " " ; Needle2a is the closing marker ; get table HTML Needle1 := InStr( Haystack, Needle1a, false, NeedleMarker ) Needle1 := InStr( Haystack, Needle1b, false, Needle1 ) + StrLen( Needle1b ) Needle2 := InStr( Haystack,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hypertext Markup Language
    • Language: en-GB
  6. Zoho Deluge - Some Useful Regular Expressionshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-some-useful-regular-expressions.html

    v_MyFormattedString = v_MyString.replaceAll(v_MyRegEx,""); b_Ok = if( v_MyFormattedString == "", true, false); // yields true v_MyString = "somewhere[]@beyondthesea_1.com"; v_MyFormattedString = v_MyString.replaceAll(v_MyRegEx,""); b_Ok = if(...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  7. Zoho CRM: Manage a subform using Client Scripthttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-manage-a-subform-using-client-script.html

    met v_DealRate0 = 350; v_DealRate1 = 390; v_DealRate2 = 465; v_DealRate3 = 535; v_DealRate4 = 590; b_ShowAlertMessage = false; } else if (v_RateCard == 'Old Rate Card (Pre Aug 22)' && (v_OppType == 'Client'||v_OppType == 'People') && v_CurrencyCode ==...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  8. Zoho Books: Get Invoice Payment Terms via APIhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-books-get-invoice-payment-terms-via-api.html

    "success", "data": { "payment_terms": [ { "payment_terms_id": "123456000000000123", "payment_terms": 15, "is_default": false, "payment_terms_label": "Net 15" }, { "payment_terms_id": "123456000000000124", "payment_terms": 30, "is_default": false,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  9. PHP: First name and Initial of Surnamehttps://www.joellipman.com/articles/cms/website-development/php/php-first-name-and-initial-of-surname.html

    was to create the logic: // default $author_name_disp=$author_name; // check and transform if(strpos($author_name, ' ')!==false){ $author_names=explode(' ', $author_name); $author_name_disp=ucfirst($author_names[0]).'...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  10. AutoHotkey: App GUI Listview to Rename Fileshttps://www.joellipman.com/component/content/article/autohotkey-app-gui-listview-to-rename-files.html?catid=48&Itemid=165

    v_NewNameWithExt ) > 0 ) { v_Increment++ b_FileExists:= FileExist( SelectedDir "\" v_NewNameWithExt ) ? true : false b_IsOriginal:= v_NewNameWithExt == A_LoopFileName ? true : false b_InColumn := CountExistingInColumn2( v_NewNameWithExt ) > 0 ? true :...

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

    change, my code would look something like 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 "; //...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  12. ZohoCRM: ZDK Client Script to retrieve Contact Emailhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-zdk-client-script-to-retrieve-contact-email.html

    it, just show it in the logs) log(e); //ZDK.Client.showMessage("Client Script error"); } // unfreeze the GUI ZDK.UI.freeze(false); // return false to prevent saving of record return false; Caveat(s) This only happens if the record is being edited (as in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  13. ZohoCRM & Xero: Function to pull most recent invoiceshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-invoices.html

    = 0; v_Count_Created = 0; v_Count_Updated = 0; v_AccessToken = ""; l_Pages = {1}; v_PageSize = 20; b_Debug = false; // // Xero Invoice Statuses vs your CRM Invoice Statuses m_TranslateStatuses = Map(); m_TranslateStatuses.put("DRAFT","Draft");...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  14. ZohoCRM & Xero: Function to pull most recent quoteshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-quotes.html

    = 0; v_Count_Created = 0; v_Count_Updated = 0; v_AccessToken = ""; l_Pages = {1}; v_PageSize = 1; b_Debug = false; // // Login to Xero > Accounting > Accounting Settings > Financial Settings > Time Zone v_XeroTimeZone = "Europe/London"; // // hard-code...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  15. Google Authentication - OAuth 2.0 using PHP/cURLhttps://www.joellipman.com/component/content/article/google-authentication-oauth-2-0-using-php-curl.html?catid=61&Itemid=165

    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false); $response=curl_exec($ch); if ($response === false) { return...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  16. URL passed settings in Reporting Serviceshttps://www.joellipman.com/component/content/article/url-passed-settings-in-reporting-services.html?catid=75&Itemid=165

    is True) http:///ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render &rc:Toolbar=False To hide just the parameters (default is True)...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  17. GDPR Privacy Policyhttps://www.joellipman.com/component/content/article/gdpr-privacy-policy.html?catid=50&Itemid=165

    • Type: Article
    • Category: Static Items
    • Language: *
  18. Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date Stringhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-convert-xero-date-unix-timestamp-to-standard-date-string.html

    Using a regular expression v_XeroTime="/Date(1586995200000+0000)/"; v_ZohoTime = v_XeroTime.replaceAll("[^0-9]", " ", false).trim().toList(" ").get(0).toLong().toTime(); // yields 15-Apr-2020 17:00:00 Update 2025 A few more years and a few more systems...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  19. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

    Sales Order Ref Name it whatever: eg. OnUserInput_ZBSoRef Put the following Deluge code: input.Attached_Files_in_CRM = false; Setup a scheduled task in Creator Schedules > New Workflow Choose a Date Field Start Date: select form and choose Modified_Time...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  20. Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd)https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-date-from-a-string-dd-mm-yyyy-to-yyyy-mm-dd.html

    // // regex change dd/MM/yyyy to yyyy-MM-dd v_RegexdDate = v_TestDate.replaceAll("(\\d{2})/(\\d{2})/(\\d{4})","$3-$2-$1", false); info v_RegexdDate; info v_RegexdDate.toDate(); info v_RegexdDate.toString("E, d MMM yyyy"); info "*********************";...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
Results 1 - 20 of 63