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

  1. ZohoCRM: zoho.crm.searchRecords only returns certain recordshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-search-records-only-returns-certain-records.html

    than it took me, why a zoho.crm.searchRecords() returns some 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  2. Zoho Creator: Change Radio into Tabshttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-change-radio-into-tabs.html

    we have the tabs looking close to what we want, you will have noted that I have done this code in-line of the form. If you were to embed the form on to a page, you would be free to use some reserved CSS attributes on the page style rather such as...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  3. Zoho CRM: Schedule a Call using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-schedule-a-call-with-deluge.html

    schedule a call using the GUI then write a test function to check the JSON that is being returned for API names... If that were the case, it would have been a 5 minute job. Instead, it's turned into over an hour of figuring this out. So here's a working...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  4. 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/zoho-crm-using-a-function-for-validation-rules.html

    worth an article. The ability to block field picklist options from being selected based on the profile of a user. Why? There were several alternatives we considered beforehand which still didn't fit the requirement: A client's first-line agents would...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  5. Zoho Books/Inventory: Trigger a workflow when an invoice has been paidhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-books-inventory-trigger-a-workflow-when-an-invoice-has-been-paid.html

    and updates the custom fields. Executing the function this worked as expected. Now put it on a workflow where the settings were: When an invoice is "Created or Edited" Execute the workflow when "When any field is updated" Filter the triggers when Status...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  6. Zoho Analytics: Determine profits from invoices and purchase ordershttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-determine-profits-from-invoices-and-purchase-orders.html

    for an invoice issued prior to this, and we want to work out profits in January, we're including the credit notes that were issued in January. I'm calling this one "My Credit Note Items": SELECT cn."Created Time" AS "Created", abs_month(cn."Created...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • 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

    If these are blank then enter the rates manually below: Rate Year 1.0, Rate Year 1.5,..."); } // update the fields (that were blank on the existing record - but now pulled from Opp or from set values) ZDK.Page.getForm().setValues({ 'Rate_Year_1_0':...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  8. ZohoDeluge: Get All eBay Orders Given a From and Till Datehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zohodeluge-get-all-ebay-orders-given-a-from-and-till-date.html

    an access token then getting the OAuth access codes from the client. How? I'm going to split this into 2 code snippets that were in practice added to the same function and that worked at time of print. Note that this uses the old Trading API as the new...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  9. ZohoCRM: Using Criteria with Module Record Counthttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-using-criteria-with-module-record-count.html

    Urlencoding or not didn't have much affect on the above but it is recommended you do as it did work if the criteria were encoded... The criteria is in the same syntax format as the one used in the Search API call. Code-wise using the same criteria...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  10. Zoho Creator: Get Images in Report to be Exported to PDFhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-get-images-in-report-to-be-exported-to-pdf.html

    when you download the PDF and view this outside of the Zoho instances, the photos don't display. This is because the photos were just links in the Zoho Creator image field, links to another Zoho app that is behind a user wall (ie. login and password as...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  11. Zoho Books: Error 7008: There are no contact persons associated with this Invoicehttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohobooks-error-7008-there-are-no-contact-persons-associated-with-this-invoice.html

    This is from within ZohoCreator, requesting for an invoice in ZohoBooks to be sent. How? So the key here is that there were no contact persons on the customer record. Instead, when building the invoice, this had to be added (don't ever remember having...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  12. ZohoCreator: Basic Widget with Zoho Datahttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zohocreator-basic-widget-with-zoho-data.html

    Passed in URL - Cannot use window.location URL var queryParams = ZOHO.CREATOR.UTIL.getQueryParams(); // Check parameters were even specified if (queryParams.p_ShopifyEmail !== undefined) { v_ShopifyEmail = queryParams.p_ShopifyEmail; } if...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  13. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

    set in Step 1: // ******************************************************************************* // delete any tasks that were transferred from the lead record relating to reminding staff to convert the lead. // l_RelatedTasks =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  14. Zoho Analytics: Create a Monitoring System with Imageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-create-a-monitoring-system-with-images.html

    visualize the health of the system. Why? The use-case here is to build a system which monitors a Zoho App for when records were last modified and if a synchronization process starts to fail, there should be images or icons warning or advising of...

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

    is to remove the color_code key as well... m_Tag.remove("color_code"); */ Considering that neither the color code nor ID were necessary in the end, I can use shortcode for getting the tag. Note that on a fresh CRM instance where no tags have been used...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  16. ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoicehttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohocrm-to-zohobooks-api-half-a-cent-or-penny-off-when-creating-an-invoice.html

    Ta daa! Source(s): I would mention a few community forum pages I went through which showed me how not to do it, but as none were the solution, I'm not sure putting them here would make this easier for you. Zoho Books API Documentation: Create Invoice:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  17. ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

    } } } // determine deposit amount // get grand total (note that formula for grand total excludes line items which were optional) v_QuoteGrandTotal = 0.00; r_QuoteDetails = ZDK.Apps.CRM.Quotes.fetchById(v_QuoteID); if (r_QuoteDetails.Grand_Total !=...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  18. Zoho CRM Client Script: Map Quote to Invoicehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-client-script-map-quote-to-invoice.html

    invoice) var o_InvoicedQuote = ZDK.Page.getField('Quote').getValue(); // go down this route if a quote is specified (they were on the quote and clicked on the plus next to 'invoice') if (o_InvoicedQuote != null) { // check on the quote associated to...

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

    not a third-party app. This can only be cleared by Zoho’s backend support. Yodlee vs Plaid: Older Zoho Books feeds in the UK were powered by Yodlee. From 2024 onward, Zoho migrated UK accounts to Open Banking connections handled by Plaid. The “via...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  20. How to redirect the visitor after the contact pagehttps://www.joellipman.com/articles/cms/joomla/how-to-redirect-the-visitor-after-the-contact-page.html

    - remove menu item Ultimately this solved the problem of redirecting the user after they complete the contact form: If you were wondering how to get the default contact form in Joomla 1.5 to redirect you to another page after you submit it, or if you...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
Results 41 - 60 of 106