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

  1. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

    article to ensure I never spend this long on such a request again. The brief is: "Follow up when a lead is created and not converted within 1 day send an email and notification to sales person everyday for 3 days then escalate to a specified user". Why?...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  2. Zoho CRM: Update a custom field in line items / product details using REST API v2.1https://joellipman.com/articles/crm/zoho/zoho-crm-update-a-custom-field-in-line-items-product-details.html

    = Map(); m_CreateQuote.put("Subject","My Test Quote"); m_CreateQuote.put("Product_Details",l_CrmLineItems); Which when converted and sent in JSON would look something like the following request: { "Subject": "My Test Quote", "Product_Details": [ {...

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

    is buried in Zoho documentation and due to the searchRecords function requiring it's 5th parameter which defaults to "not converted" records: =zoho.crm.searchRecords(,,,,,); The solution: The long answer/investigation is getting a JSON response with a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  4. ZohoCRM GetRelatedRecords INVALID_DATAhttps://joellipman.com/articles/crm/zoho/zohocrm-getrelatedrecords-invalid_data.html

    = 0; v_CountUpdated = 0; l_Pages = {1}; v_PerPage = 1; // // map to retrieve all records (to include approved and converted records, this needs to be specified as the query value) m_IgnoreRestrictions = Map();...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. Joe's Unduplicater (JUD)https://joellipman.com/component/content/article/joes-unduplicater.html?catid=40

    If you need to remove files which are simply the converted versions of music or video files, then this tool asks which folder has the files it will keep and which ones it will send to the Recycle Bin. TESTED ON: - Windows XP, Windows 7 SCREENSHOTS:...

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

    but here we're going to do it in client script: Additionally, the line items will be sourced from the quote that was converted to the invoice. For this to work, we've mapped a field on the invoice (not a lookup but a text field) which when a quote gets...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  7. Joes Quicklist Weblinks (JQW) Downloadshttps://joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

    Bug: Strict Standards Issue: New Operator removed for PHP5+. - Fixed Bug: Object without reference: Child object design converted to Object array. - Date Uploaded: Thu, 31st Oct 2013 3.0- Fixed Bug: Version compatible with Joomla v3 - Enhancement: Added...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  8. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM recordhttps://joellipman.com/articles/crm/zoho/zohoflow-zohosign-retrieve-a-zoho-sign-document-request-and-add-attachments-to-crm-record.html

    if(v_DealRef != "") { l_SearchResults = zoho.crm.searchRecords("Deals","(Reference_ID:equals:" + v_DealRef + ")",1,200,{"converted":"both","approved":"both"}); for each r_Result in l_SearchResults { if(!isnull(r_Result.get("id"))) { v_DealID =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  9. ZohoCRM & Xero: Function to pull most recent quoteshttps://joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-quotes.html

    / Rejected"); m_TranslateStatuses.put("ACCEPTED","Approved by Customer"); m_TranslateStatuses.put("INVOICED","Converted to Sales Order"); m_TranslateStatuses.put("DELETED","Cancelled / Rejected"); // // Xero Tax Rates translated to Zoho Tax Rate (manual...

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

    and to deal with a scenario which exists for a client of mine. The use-case for my Cx is that they need documents converted from HTML to PDF — as in we send it a bit of code in HTML and we want a PDF file returned. I have severaly instances of an API...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  11. Mediawiki Extension for Camtasia Studio SWF videoshttps://joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

    customization. Our screen recorder was also not displaying the captions of the video unless it was an AVI file that we converted to FLV. The quality was horrible. Then we moved to Camtasia Studio where their videos were displaying in good quality but as...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  12. Migrate Joomla Users to WordPresshttps://joellipman.com/articles/cms/wordpress/migrate-joomla-users-to-wordpress.html

    is for Joomla 1.5.x sites! Note that this article is for Joomla 1.5.x sites to be converted to Wordpress 3.2.x sites. I started with a Joomla 1.5 as the move from Joomla 1.6 or greater is a lot easier since it uses nested categories like Wordpress....

    • Type: Article
    • Author: Joel Lipman
    • Category: Wordpress
    • Language: en-GB
  13. Getting the mysql where in delimited string to workhttps://joellipman.com/articles/database/mysql/getting-the-mysql-where-in-delimited-string-to-work.html

    The Problem? When I select specifying the statement "WHERE IN (c.RoomImages)", this is interpreted as a string and when converted to a number only retrieves the first value before the first comma. Consider the following, the first query is how MySQL...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  14. MySQL: Display Users and Duration in Matrix Timesheethttps://joellipman.com/articles/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

    . "\t" . $this_t . "\t" . $this_t2;...do some more here ???... } } Yields -- Note this data matches the brief as we've converted the seconds to time. -- Using MySQL to convert rather than PHP so as not to have to deal with hour changes and the magical...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  15. SSIS Convert a string into a datehttps://joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

    (3833) to column "This_Date" (3932). The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data.". Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "Extract...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  16. URL Alias uniqueness with PHP & MySQLhttps://joellipman.com/articles/web-development/php/url-alias-uniqueness-with-php-mysql.html

    So this is an article for me on how to copy Joomla's and Wordpress' feature where a Title/Name value is converted to a search-engine friendly URL alias and is unique in the database. Ok that's a long sentence; let me try this: When I save a record in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  17. Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirectshttps://joellipman.com/articles/crm/zoho/zoho-creator-two-submit-buttons-on-a-non-stateless-form.html

    [ = = = ]; } Done: Additional Remember that an integration field on the interface is returned as a string and needs to be converted to a number to be assigned, eg: r_Details = myForm[ID == 1234567980123456789]; r_Details.Account = input.Account.toLong();

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  18. Zoho CRM: searchRecords with sorted resultshttps://joellipman.com/articles/crm/zoho/zoho-crm-searchrecords-with-sorted-results.html

    want to search. Method #1: zoho.crm.searchRecords() Contrary to the documentation saying there are only the approved and converted values supported in additional parameters, I find the below works in CRM just fine: As of 2025, this method no longer...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  19. Amazon Kindle: Send PDFs to your Kindlehttps://joellipman.com/amazon/kindle/amazon-kindle-send-pdfs-to-your-kindle.html

    it is with any email client. You can also use ‘Convert’ as the subject and send it to Kindle. The file gets automatically converted to the Kindle format. Fix for PDF file now showing on the Kindle If that is the case, here are a few things you can do....

    • Type: Article
    • Author: Joel Lipman
    • Category: Kindle
    • Language: *
  20. Zoho Inventory: Mark a package slip as delivered and shippedhttps://joellipman.com/articles/crm/zoho/zoho-inventory-mark-a-package-slip-as-delivered-and-shipped.html

    {"code": 4,"message": "Invalid value passed for salesorder_id"}: Not sure about what ended up fixing this one. I think I converted the sales order to an invoice and created a package slip for it. The invoice was then sent (payment=unpaid). Not sure...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 1 - 20 of 23

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.