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

  1. Zoho Projects: Deluge to Submit Custom Fieldshttps://joellipman.com/articles/crm/zoho/zoho-projects/zoho-projects-deluge-to-submit-custom-fields.html

    "duration": "1", "duration_type": "hrs", "start_date": "11-12-2021", "end_date": "12-12-2021", "percent_complete": "0", "order_sequence": "4", "priority": "None", "custom_fields": m_Custom.toString() }; r_CreateResponse =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Projects
    • Language: *
  2. ZohoCRM: zoho.crm.searchRecords only returns certain recordshttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-search-records-only-returns-certain-records.html

    of the records but omits others. Why? The use-case was that we were creating a custom related list on a Zoho Finance > Sales Orders module but it wasn't finding all the Quotes related to this Sales Order. How? The quick answer is buried in Zoho...

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

    = "0"; v_CrmOppID = "0"; v_OwnerName = ; v_AppLinkName = ; v_FormLinkName = ; v_ViewLinkName = ; if(!isnull(salesorder.get("salesorder_id"))) { v_CreatorSoID = salesorder.get("salesorder_id"); } v_SearchCriteria = "Sales_Order_ID==\"" + v_CreatorSoID +...

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

    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 trying to get the...

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

    In any way that you do this, OnEdit will populate the form with the record data and trigger each field in the displayed order. Method #3: Use an eTag I use to use an eTag for a database-driven system I created to store the record details of properties....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  6. Zoho Creator: eBay: Get Item Transactionhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-ebay-get-item-transaction.html

    This is the function to get the line item order/transaction from eBay if you give it the eBay Item ID as a parameter. Why? Mostly for debugging but here's the code that will quickly get the XML of a GetItemTransactions request to eBay. How? You'll need...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  7. ZohoCRM: Template: not being able to edit a text boxhttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-template-not-being-able-to-edit-a-text-box.html

    cause/outcome would be for your case but worked for us. This documents the steps taken to edit/modify the header on a sales order inventory template. Why? A client raised an issue that they had previously hard-coded the address of their organization...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  8. Zoho CRM & Creator: Download attachment and upload to Creator file fieldhttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-creator-download-attachment-and-upload-to-creator-file-field.html

    v_NoteAttachments = " "; m_SortCriteria = Map(); m_SortCriteria.put("sort_by","Created_Time"); m_SortCriteria.put("sort_order","desc"); l_Attachments = zoho.crm.getRelatedRecords("Attachments","Contacts",v_CrmContactID,1,200,m_SortCriteria); for each...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  9. Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

    the nodes to get the last cursor. Not sure if this meant any data was missing. Perhaps by forcing the sort criteria to be by order of cursor alphabetically; but we were happy with the results the above code did anyway so I haven't tried this. Source(s):...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  10. ZohoCRM: Get All eBay Active Listingshttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-get-all-ebay-active-listings.html

    { l_Pages.add(v_StartingPageIndex + v_Increment); } v_TotalNumberOfPages = l_Pages.size(); // // declare variables to store order details in a JSON or ZohoDeluge Map format m_Response = Map(); l_JsonProducts = List(); // // start preparing CSV file to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  11. ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-integrate-chatgpt-to-zohozia.html

    List(); // // build up COQL query v_CoqlQuery = "select Content, Role from GPT_Chats where Owner='" + v_LoggedInUserID + "' order by Created_Time asc"; // // build up parameters m_Params = Map(); m_Params.put("select_query",v_CoqlQuery); // // invokeurl...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  12. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

    note, that this Zoho instance is in the EU datacenter (zoho.eu) rather than the US datacenter. The most important tweak in order for the below to work, is to add a file upload field on the user profile in ZohoCRM; Login as SuperAdmin > Users > Edit a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  13. Zoho Books / Inventory: Get Item Rate from a Price Book/Listhttps://joellipman.com/articles/crm/zoho/zoho-books/zoho-books-inventory-get-item-rate-from-a-price-book-list.html

    would fail because it was making too many function statements. How? I have this code triggered in a workflow when the sales order is created to do some further calculations based on a surcharge rate held in a custom module. The custom module could only...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  14. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

    m_CreateRecipient.put("Owner",v_LoggedInUserID); m_CreateRecipient.put("zohosign__Recipient_Order",1); m_CreateRecipient.put("zohosign__ZohoSign_Document",r_ZCrm_ZSDoc.get("id")); m_CreateRecipient.put("zohosign__Recipient_Type","Signer");...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  15. Zoho CRM: Updating a CRM record Custom Line Items using API v7https://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-updating-a-crm-record-using-api-v7.html

    invokeUrl. Why? Because my designers keep including custom fields in their transactional modules line items (quotes, sales orders, invoices, purchase orders). The only way to update these are by using the API and deluge function invokeURL rather than...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  16. Zoho Deluge: Nested Catch Statementshttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-nested-catch-statements.html

    issues with one of the servers being down, or inaccessible due to certificate expirys, means that the Cx business halts. In order to add a bit of clustering, we have added a bit of code for it to try one server first, if there is any kind of an error...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  17. Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-using-remove-key-on-a-map.html

    = 100; v_CoqlQuery = "select id, Contact_Name.Tag 'Tag' from Deals where Tag is null and Contact_Name.Tag is not null order by id asc limit " + v_PerPage; m_Params = {"select_query":v_CoqlQuery}; r_Coql = invokeurl [ url...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  18. ZohoDeluge: eBay marketplace account deletion/closure notificationshttps://joellipman.com/articles/crm/zoho/zoho-deluge/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

    the unique challenge code, the endpoint must hash the challengeCode, verificationToken, and endpoint URL (in that exact order), and respond to eBay with an HTTP 200 OK status, including the hashed result in JSON format within the challengeResponse...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  19. Zoho Deluge: Connect to Shopifyhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-connect-to-shopify.html

    r_ShopifyAPI.API_Version; // // url with client id and client secret (now to be deprecated July 25, 2025 by Zoho) // where p_OrderID is the shopify order ID v_Endpoint = v_ShopifyURL + "/admin/api/" + v_ShopifyApiVersion + "/orders/" + p_OrderID +...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  20. ZohoBooks: Broken UK Banking Feedhttps://joellipman.com/articles/crm/zoho/zoho-books/zohobooks-broken-uk-banking-feed.html

    Caveat(s): Refreshing the feed means that duplicates will be created. You will need to delete the ones manually imported in order for the numbers to be brought in line. Notes and findings: Integration locks: The “Accounts associated with Integration...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
Results 81 - 100 of 133