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 44 results were found.

  1. AutoHotkey: Check Windows Folder Sizeshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-check-windows-folder-sizes.html

    size2 = "MB", size3 = "GB", size4 = "TB" sizeIndex := 0 while (size >= 1024) { sizeIndex++ size /= 1024.0 if (sizeIndex = 4) break } return (sizeIndex = 0) ? size " byte" . (size != 1 ? "s" : "") : round(size, decimalPlaces) . " " . size%sizeIndex% } ;...

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

    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
  3. Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-5-letter-booking-retrieval-code.html

    in l_BadWords { if(v_Output.indexOf( v_BadWord ) >= 0) { b_BadWordFound = true; } } // if not found if(!b_BadWordFound) { break; } } // output return v_Output; } Source(s): Zoho Creator - Community Forum - Random Sort/Shuffle a List Zoho CRM - Community...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  4. Convert Past Date to Time Ago in PHPhttps://www.joellipman.com/articles/web-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
  5. AutoHotkey: App GUI Listview to Rename Fileshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

    || b_InColumn) && (!b_IsOriginal) { v_NewNameWithExt := Trim( v_NewName ) " (" v_Increment ")." A_LoopFileExt } else { break } } ; add to the list view LV_Add("", A_LoopFileName, v_NewNameWithExt ) ; update for the status bar v_RowCount++...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  6. AutoHotkey: Get Media Information and Displayhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-get-media-information-and-display.html

    := A_LoopFileTimeAccessed fex["_FileTimeC"] := A_LoopFileTimeCreated fex["_FileTimeM"] := A_LoopFileTimeModified } Break } If Not ( _FileExt ) ; Filepath not resolved { Return } objShl := ComObjCreate("Shell.Application") objDir :=...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  7. Zoho CRM & Zoho Books: Get SalesPersonshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-get-salespersons.html

    { if(r_SalesPerson.get("crm_reference_id") == v_OwnerID) { v_SalesPersonID = r_SalesPerson.get("salesperson_id"); break; } } m_CreateSO.put("salesperson_id",v_SalesPersonID); } Additional Note(s): Scope(s) required: for the connection I think it was...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  8. ZohoCRM: Deluge: Map a custom field from user profilehttps://www.joellipman.com/articles/crm/zoho/zohocrm-deluge-map-a-custom-field-from-user-profile.html

    r_UpdateDeal = zoho.crm.updateRecord("Deals",v_DealID,m_UpdateDeal); info r_UpdateDeal; } } break; } }

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

    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
    • Language: *
  10. 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

    { 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
    • Language: *
  11. Zoho CRM: searchRecords with sorted resultshttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  12. 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-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
    • Language: *
  13. Zoho Analytics: Determine profits from invoices and purchase ordershttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  14. Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

    expression using words and phrases to instruct the Midjourney Bot (or any other AI text-2-image generator) which the bot can break down into "tokens" and then match with its training data to generate the image. Quick recap on how to first start using...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
  15. Zoho Books: Generate Bank Text File for Downloadhttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  16. ZohoCreator: Basic Widget with Zoho Datahttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  17. Zoho Deluge and Wordpress/WooCommerce API: Get All Productshttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  18. Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  19. Zoho Analytics & Zoho People: Monitor DataSource Sync https://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  20. Zoho CRM: Remove Duplicate Product Recordshttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
Results 21 - 40 of 44

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.