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

  1. Zoho Deluge - Modify the product line items in an invoice modulehttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-modify-the-product-line-items-in-an-invoice-module.html

    product_details field of an invoice record seems straightforward but it isn't. Undocumented, the trick is to remove the existing ID of the line item and posting the map back to the record. In the following example, we are swapping out the product...

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

    or url encoding to %26 wasn't working for me. I spent several hours trying to write a script that could search for the existing records by company name. The issue is that if you use zoho.crm.searchRecords() this will work fine for company names without...

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

    leading slash or your widget will error) Click on "Create" (bottom-right of your screen) Now go to a Creator page (new or existing), select "Widgets" and drag your new Widget to the page: Don't forget to click on the page settings (cog in the top right)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  4. Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

    Why? Sometimes you might need this when data mapping fields from one module to another, sometimes you need to manage existing multi-lookups/users in a record. How? So the key point to remember is that all multi-select lookup and multi-user lookup fields...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  5. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://joellipman.com/articles/crm/zoho/zoho-other/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

    bot Login to ZohoCliq Click on your profile picture Select "Bots & Tools" Click on "Create Bot" (or "Edit Handlers" on an existing bot) Fill in the details then edit the Handlers. For demo purposes, edit the code for the "Message Handler" Get an OpenAI...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  6. ZohoCRM: Get Organization Business Hours using Deluge/APIhttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-get-organization-business-hours-via-deluge-api.html

    Why? When creating a booking system in ZohoCreator, I want to enter the default working shift for an employee either existing or that has been added to the system based on the business hours set at the organization level in ZohoCRM. How? Using an...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  7. ZohoCreator: Using .toFile and Uploading to a Creator fieldhttps://joellipman.com/articles/crm/zoho/zoho-creator/zohocreator-using-tofile-and-uploading-to-a-creator-field.html

    // get original document file (optional) - you need your own record ID here v_ZC_DocumentRecordID = 1234567890123456789; c_ExistingDocument = Document[ID == v_ZC_DocumentRecordID]; info c_ExistingDocument.Document_File; Upload the generated file to the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  8. Zoho Deluge and Wordpress/WooCommerce API: Get All Productshttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-and-wordpress-woocommerce-api-get-all-products.html

    + "&" + l_PaginationParams.toString("&") type :GET ]; l_ThisList = r_AllProducts.toJSONList(); // // add this list to our existing list l_AllProducts.addAll(l_ThisList); // // stop the loop if there weren't any more products if(l_ThisList.size()...

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

    attempts to copy over the color on a new tag; the second is if this fails to copy over the color (because there is an existing tag with the same name), then it only copies over the name: v_TotalCount = 0; v_TotalProcessed = 0; v_PerPage = 100;...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  10. Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

    I need to quickly set up a JS widget: Open a MacOS Terminal sudo npm install -g zoho-extension-toolkit (this also updates existing install) sudo zet init select Zoho CRM enter a unique Project Name cd to the new project name To give permissions to write...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  11. Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://joellipman.com/articles/crm/zoho/zoho-analytics/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

    Outputs: - Date Created: 2025-09-25 (Joel Lipman) - Initial release Date Modified: 2025-09-29 (Joel Lipman) - Deletes existing images in the image upload field More Information:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  12. Connect to Joomla database in standalone scripthttps://joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

    some of these need to connect to the database but as they sit outside of the MVC structure, we need them to use the existing configuration file in order to retrieve the credentials (ie. username, password, database, etc.). For obvious reasons, these...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  13. Call to a member function mark() on a non-object in Joomla CMShttps://joellipman.com/articles/cms/joomla/call-to-a-member-function-mark-on-a-non-object.html

    CMS. Ticking both options and then updating re-created the error. I restored the files (using a backup to overwrite the existing PHP files), leaving the database and images folder unchanged. I updated just the Joomla CMS and then the option to update...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  14. Warning: Save failed. Another menu item has the same aliashttps://joellipman.com/articles/cms/joomla/warning-save-failed-another-menu-item-has-the-same-alias.html

    do SELECT * FROM #__menu WHERE alias LIKE '%about%' where #_ is the table prefix) Instead of deleting, I change the existing menu item alias from "about-us" to "about-us2" as well as any similar `path` value. Change the item you created in step #2 (eg....

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  15. Migrating from Joomla 2.5.x to 3.4.xhttps://joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

    -- Contrary to recommended practice, I'm moving these guys first so all -- the objects from the existing site will retain their ownership. Based -- on previous migrations, this tends to help not confuse the system. --...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  16. Google Authentication - OAuth 2.0 using PHP/cURLhttps://joellipman.com/component/content/article/google-authentication-oauth-2-0-using-php-curl.html?catid=61&Itemid=165

    using OAuth2.0. These functions allow a script to simply be loaded and to either create a token file, or use the existing one as long as it hasn't expired. Update 2019 This script requires a user to authenticate the google account. I have a newer...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  17. Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://joellipman.com/component/content/article/google-drive-oauth-using-service-account-in-php.html?catid=61&Itemid=165

    + 3600; $diff = $expiry_time - time(); $api['jwt']['token']['minutes'] = floor($diff/60); } 6a. Use existing Access Token This if else statement simply says if the token still has at least 5 minutes left, then use the one found at the file location...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  18. Android: Keytool and Google Maps displaying greyhttps://joellipman.com/articles/else/app-dev/android-os/android-keytool-and-google-maps-displaying-grey.html

    (*.jks) you used to upload the APK to the Google Play Developer Console. Finding the Certificate Fingerprint SHA1 of an existing keystore Open a command prompt Type CD C:\Program Files\Java Determine your JDK folder dir jdk* Change directory to the JDK...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  19. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://joellipman.com/component/content/article/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html?catid=75&Itemid=165

    An additional request is that there appears a link that will run a stored procedure which Updates a timestamp in an existing table Inserts a row into an audit table I need the report to run the stored procedure, then based on the errorlevel, return a...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  20. Sync Outlook 2007 Shared Calendar with SharePoint 2007https://joellipman.com/component/content/article/sync-outlook-2007-shared-calendar-with-sharepoint-2007.html?catid=77&Itemid=165

    to happen when I started this. We have a SharePoint 2007 site and we have been asked to migrate links and calendar from an existing system. I was worried when following other instructions because I thought my personal calendar in Outlook 2007 would be...

    • Type: Article
    • Author: Joel Lipman
    • Category: SharePoint
    • Language: *
Results 21 - 40 of 48