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

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

    customer had added 3 custom fields: Payment Method, Payment Date, and Last Four Digits. They needed these because sometimes their customers needed to know what card they had paid with (if paid by card). The customer wanted payment method and payment...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  2. ZohoCRM: Import Attachmentshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-import-attachments.html

    use-case here is a data migration for a client from a legacy CRM to ZohoCRM. They have a lot of files they want attached to their respective records in CRM. This took me a while as our own documentation is scatty and the online forums weren't too...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  3. Zoho Creator: Disable/Hide the add and delete subform row buttonshttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-disable-hide-the-add-and-delete-subform-row-options.html

    GUI. Why? Our use-case is that we have a subform which gets autopopulated with a list of services. The client does not want their operations team adding/deleting rows and instead simply specifying quantity (defaulting to zero) alongside each serviceable...

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

    and security very seriously, and they have implemented several measures to protect the data and models that are used by their services. When you train a model with OpenAI's services, your data is encrypted and stored in a secure environment, and access...

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

    Staff[ID != 0]; for each c_Employee in l_ApplicableStaff { info c_Employee.Name; // // reset the stuff they already have in their subform "Usual Shift" c_Employee.Usual_Shift.clear(); // // great now let's build a ZohoCreator subform c_UsualShift =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  6. Zoho Inventory: Enable Tracking using the APIhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory/zoho-inventory-enable-tracking-using-the-api.html

    Error(s) Encountered items with opening stock cannot be deleted, set the opening stock to zero: Guess who's going to have their opening stock set to zero, save the record, then delete it. Source(s) Stack Overflow - Using the Zoho Inventory API can you...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Inventory
    • Language: *
  7. Zoho Deluge: Proper Case for Nameshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-proper-case-for-names.html

    records containing people's names as duplicates, when actually they are the same entity but may have uppercased a letter in their name while the other entry does not... This article is a start and adaptation of my previous article Convert to Proper Case...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  8. Zoho Books: Generate Bank Text File for Downloadhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-books-generate-bank-text-file-for-download.html

    without using any other apps or software. How? Here's how to use it: Staff member clicks on button File downloads to their workstation Here's what's happening in the background: File is generated FIle is attached to the last record of the source data...

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

    Off a button / Standalone / Schedule to run daily @ 1am Purpose: Generates the email signature for all active users on their profile into the CRM settings. Inputs: - Outputs: - Scope(s): WorkDrive.team.ALL, WorkDrive.workspace.ALL, WorkDrive.files.ALL,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  10. ZohoAnalytics & ZohoBooks: Custom Related List from Analyticshttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohoanalytics-zohobooks-custom-related-list-from-analytics.html

    ZohoBooks, and a reminder on how to read a table from ZohoAnalytics. Why? My use-case here is that we have a client who uses their purchase orders and sales orders as part of a logistics solution where items are purchased from a supplier, sent to...

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

    of a credit application you want to send to your customer, and when they complete it, the PDF version gets attached to their contact record... all from one click of a button: Scenario 1: Credit Application: Template exists in ZohoSign Very quickly,...

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

    syntax of how to either create or update a record using 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  13. Zoho CRM: Remove Duplicate Product Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-remove-duplicate-product-records.html

    are a common issue during development, especially when we have products imported via a feed or API or simply by staff and their spreadsheets. There is a deduplication feature for leads and contacts but not for products. How? There may be a better way of...

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

    A follow-on article from my previous article ZohoCRM & Xero: Function to pull most recent invoices - along with their Contacts and Items (accounts/contact & products respectively). Why? This took me so much longer than I thought it would. It was meant...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  15. Community Builder in Joomla Vulnerabilityhttps://www.joellipman.com/articles/cms/joomla/community-builder-in-joomla-vulnerability.html

    my scanners have picked up on and so I'll be posting solutions for those who need to keep Community Builder as their user manager. There are several things I have picked up which I will go into more detail as I test each one (11.11.09):...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  16. Change default order of weblinkshttps://www.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

    database values used by each link. Joomla 1.5.x I found the page to edit after going through the Joomla forums for a bit. Their solution only permanently sets the default sort order to WEBLINK TITLE in order from A to Z. The below code with my...

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

    be hardcoded. What? Any developer installing my component will do so on a website which uses different login details for their Joomla database. The example below demonstrates how to get these details and extract data from the database. How? Based on a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  18. Things to Check if Joomla Password Reminder email not being senthttps://www.joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

    question I get asked. This refers to an issue within the Joomla CMS (version 2.5.x) where it fails to email users who reset their password. How? A few things to check: Check the email message even exists: Login to your Joomla Admin Panel Navigate to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  19. Creating a custom form field type for Joomla XML fieldsethttps://www.joellipman.com/articles/cms/joomla/creating-a-custom-form-field-type-for-joomla-xml-fieldset.html

    Why? In Joomla, the XML type of "sql" is extremely limited. The component I'm making has to ensure user's can only see their own projects and not everyone's: SELECT * FROM #__projects ORDER BY name -- yields all projects irrespective of which user is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  20. Protecting your Joomla Administrator Sectionhttps://www.joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

    ensure you have a static IP address (most home broadband users are now assigned these by ISPs so that they can identify their service users). The below also only allows 1 IP address (ie. one location from where an admin user can log in). Create a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
Results 81 - 100 of 133