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

  1. Zoho Creator: Retrieve record with case-insensitive queryhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-retrieve-record-with-case-insensitive.html

    the records:... l_ProductDetails = Product[Product_Name.containsIgnoreCase(v_Name)];... Lastly, there is a function I find myself using more and more called equalsIgnoreCase() which could be used:... l_ProductDetails =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  2. AutoHotkey: App GUI Listview to Rename Fileshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

    ; -------------------------------------------------------------------------------------- ; Function: CountExistingInColumn2: Find in list view occurrences of new names column CountExistingInColumn2( v_Filename ) { v_AlreadyExists := 0 Loop, %...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  3. Zoho Deluge: Get Image Uploaded in Creator Formhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-image-uploaded-in-creator-form.html

    page. Why? There might be different articles out there and discussion forums that do cover this but it takes me so long to find the solution with the right syntax. How? So I'm going to start with 1 method and then update this article with other methods....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  4. Windows 10: Shortcut Apps to Settingshttps://www.joellipman.com/articles/microsoft/windows-os/windows-10-shortcut-apps-to-settings.html

    Security Activation ms-settings:activation Backup ms-settings:backup Delivery Optimization ms-settings:delivery-optimization Find My Device ms-settings:findmydevice For developers ms-settings:developers Recovery ms-settings:recovery Troubleshoot...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  5. Zoho Deluge: Search Records with Special Characters (COQL)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

    names without special characters such as the ampersand or parentheses. But what if amongst your records you may want to find: Company Name: Father & Sons (Incorporated) Contact Name: O'Reilly How? Well I've tried various replace methods with regular...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  6. Expecting ZC_SUBFORM_250 expression found COLLECTIONhttps://www.joellipman.com/articles/crm/zoho/expecting-zc_subform_250-expression-found-collection.html

    A very quick article as I couldn't find anything on the WWW to document this error. Why? During a data migration, I was using a custom function to copy all the data from one app to another. The specific form was for "Leads" which contained a subform...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  7. Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

    there will be a log in the terminal: Editing the Widget So let’s modify the widget.html file in this app by opening a finder/file explorer window and browsing to the app folder: Then open the file “widget.html” in your favorite code editor, here I am...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  8. Zoho Creator: info/alert/modal/popup notification for any userhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

    all contents: Any styling on an embedded form on the popup would need to apply specifically to the contents in the popup. Find the modal or popup name to isolate these from other CSS tags sharing the same name. Alternative Solution Some of you may be...

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

    written this article because I keep forgetting on how to do this. I have a specific order of steps on how I do this, you may find other ways but this is one that works for me. How? So here's an overview and then we'll go into more detail: Create a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  10. Zoho Creator: Assign an integration field value with an integration valuehttps://www.joellipman.com/articles/crm/zoho/zoho-creator-assign-an-integration-field-value-with-an-integration-value.html

    to update the value to r_RecordDetails.Account. Line:(442) How? It is written in the documentation albeit difficult to find: an integration field returns an ID as a string. If you want to assign it to an integration field, you have to convert it to a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  11. Zoho CRM & Zoho Books: Custom Related Lists Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-custom-related-lists-deluge.html

    + "No records found"; v_RelatedListXML = v_RelatedListXML + ""; } // // output return v_RelatedListXML; in Zoho Books // // find all related quotes l_DataRows = List(); v_QuoteRefID = "0"; v_CrmOppID = "0"; v_OwnerName = ; v_AppLinkName = ;...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  12. ZohoCRM: Process all records of a modulehttps://www.joellipman.com/articles/crm/zoho/zohocrm-process-all-records-of-a-module.html

    in l_Contacts { v_Count = v_Count + 1; if(!isnull(r_Contact.get("Email"))) { v_Email = r_Contact.get("Email"); // // find all lead records matching this email l_Leads = zoho.crm.searchRecords("Leads","Email:equals:" + v_Email); for each r_Lead in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  13. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-handle-commas-between-quotes-in-a-csv.html

    Replace all commas in between a pair of double-quotes: Well I couldn't find a single regex that can do this in one go but by applying the same regex to the same value (line 29), solved this for the sample data. If you are expecting a 3rd comma in the...

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

    An article so that I don't spend so long in trying to find sales persons in Zoho Books. Why? My use case is that I want to create a Sales Order in ZohoBooks based on one in ZohoCRM and wanted to assign the sales person. How? So after an hour or so...

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

    following code snippet will get the Opportunity/Deal/Potential record details, then get the Owner frrom the CRM users table, find the value of the custom field and search for this (if it is a lookup to a module - only returns as string), and updates the...

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

    is wait about 30 seconds or more for the loop to automatically cut out and then they can use the interface again only to find it may crash again. In the background and from a developers understanding: field1 is told to update field2 when field1 is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  17. Zoho Creator: Receive eBay Order Notifications via Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

    then contact eBay and ask them to enable it once you've run the above function. For me, I didn't have this patience and find it more fun to write another function that will generate the Auth'n'auth token. Here is a reminder on what my Zoho Creator form...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  18. Zoho Creator / Shopify: Get all Active Productshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-shopify-get-all-active-products.html

    products. I then felt that actually I just need the Product IDs. This method could do with some refinement and perhaps if I find a better way to do this, then I'll put it here. But I like this snippet of code albeit a brute force to loop through every...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  19. Zoho Deluge: Generate List of TimeZoneshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-list-of-timezones.html

    a HTML select element and convert to a Zoho Deluge list that will eventually be used to populate a dropdown. Why? Because I find myself doing this quite a bit and wanted a quick way of extracting a SELECT list in someone else's form. How? So, let's copy...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  20. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attachhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-writer-button-to-merge-template,-send,-and-attach.html

    for " + r_ContactRecord.get("Salutation") + " " + r_ContactRecord.get("Last_Name")); m_MergedData.put("message","Please find attached your document"); r_SendResponse = zoho.writer.mergeAndSend("aaaabbbbccccddddeeeeffff000011112222333344445555", "pdf",...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 101 - 120 of 162

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.