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

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

    ... Lastly, there is a function I find myself using more and more called equalsIgnoreCase() which could be used:... l_ProductDetails = Product[Product_Name.equalsIgnoreCase(v_Name)];... Other Functions of Interest contains case-sensitive search, can...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *

  2. ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-integrate-chatgpt-to-zohozia.html

    } } // // storing latest user input v_UserMessage = ifnull(userInput,""); if(!isBlank(v_UserMessage) && !v_UserMessage.equalsIgnoreCase("Ask ChatGPT")) { // // store user input to a CRM record m_Create = Map(); v_Title = if(v_UserMessage.length()>40,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *

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

    // // eg. Delivery should just be the name of the product not both the title and description if(!v_CrmProductName.equalsIgnoreCase(m_XeroLineItem.get("Description"))) { m_CrmProduct.put("Description",m_XeroLineItem.get("Description")); }...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *

  4. Zoho Creator: Find Duplicates by Customer Name for Large Datasetshttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-find-duplicates-by-customer-name-for-large-datasets.html

    in l_Customers2 { v_CountDiscrepancies = v_CountDiscrepancies + 1; c_Customer = Customer[Customer_Name.equalsIgnoreCase(v_DistinctCustomer)]; info v_CountDiscrepancies + "#: " + c_Customer.Customer_Name; } } Caveat(s): There was a risk that the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *

  5. Zoho Analytics & Zoho People: Monitor DataSource Sync https://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-zoho-people-monitor-datasource-sync.html

    for each m_DataSource in l_DataSources { if(m_DataSource.get("datasourceName").equalsIgnoreCase("Zoho People")) { v_LastSyncTime = m_DataSource.get("lastDataSyncTime"); v_LastSyncStatus = m_DataSource.get("lastDataSyncStatus"); m_DataSourceInfo =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
Results 1 - 5 of 5