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

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

    to something else, the first-line agent would not be allowed to set it back to "New Lead". Automations and workflows could however (run as Administrators). Mapping a dependency field didn't fit the bill because we want "Lead Status" to be displayed to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *

  2. ZohoCRM: ZDK Client Script to retrieve Contact Emailhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-zdk-client-script-to-retrieve-contact-email.html

    How? This needs to behave like a formula field which changes and displays before saving the record. At time of print however, I can't get a formula field to retrieve a field from another CRM record. // freezes the GUI? ZDK.UI.freeze(true); // attempt...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *

  3. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://www.joellipman.com/articles/crm/zoho/zoho-other/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

    and although the solution below only connects to the OpenAI API, it is not currently connected to ChatGPT. The plus side however is that it is connected to the Internet unlike ChatGPT which only has information up to 2021. How? The basics of setting...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *

  4. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

    estimate and a client asked that the address on the CRM record 'pulls through'. Sending the address in the same request however gives me the following error: { "code": 15, "message": "Please ensure that the billing_address has less than 100 characters."...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *

  5. Zoho Deluge and Wordpress/WooCommerce API: Get All Productshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-and-wordpress-woocommerce-api-get-all-products.html

    should go in the other direction, as in enter the products in Zoho Inventory and this feeds the website. More than often, however, this request comes in when the customer has already been setting their Zoho environment up and the Wordpress site has the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *

  6. ZohoCRM: Make either Mobile or Email mandatoryhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-make-either-mobile-or-email-mandatory.html

    a Zoho CRM contact record is used to authenticate the contact on a Wordpress portal. OTP or 2FA or MFA or OTC is in effect however; so a contact email OR phone number is required. Both aren't required but at least one should be. How? We can do this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *

  7. PHP Script: Make your own Thumbnail Generator via APIhttps://www.joellipman.com/articles/cms/website-development/php/php-script-make-your-own-thumbnail-generator-via-api.html

    and to build upon it as I kept moving the goal posts, figuratively speaking, and changing the requirements. I am impressed however that every version it iterated, worked exactly as I asked with only 1 error where it mixed a method with a comment but...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *

  8. ZohoBooks: Broken UK Banking Feedhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohobooks-broken-uk-banking-feed.html

    marked Inactive Summary In this case, the client’s bank account had previously been syncing correctly. After several weeks, however, the feed stopped updating, and the option to Refresh Feed was missing entirely from the Banking module. Comparing...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *

  9. Add the website name to the page title in Joomla!https://www.joellipman.com/articles/cms/joomla/add-the-website-name-to-the-page-title.html

    "HOME - SITENAME.COM" which is ridiculous and I'm sure Joomla will release a new version addressing this. In the meantime however: Go to "Global Configuration" and set the "Include site name in page titles" setting to "No" Open your templates component...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *

  10. Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

    but only experimental for Joomla 3.0.x! I still do not recommend using this for your site if you have no test environment, however... I have used this script continuously to migrate J1.5.x websites to J2.5.x without issue. I have managed to do whole...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *

  11. Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttps://www.joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

    settings are what you want using the Joomla Admin interface. If the article IDs match then the comments will also match. If however your article IDs don't match in both versions of your site, consider using the following update script, this will change...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *

  12. Adding a selectable background to a Yootheme templatehttps://www.joellipman.com/articles/cms/joomla/adding-a-selectable-background-to-a-yootheme-template.html

    Template 2012 What? For any web-developer who can program in PHP/HTML, this would be easy to hard-code and override. However, the article below demonstrates how to make this an option that your client can switch off/on using the Joomla Admin Panel. How?...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *

  13. Registered Users Cannot Login - Super Users Canhttps://www.joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

    and "activated" (not blocked). If I used a test account, none of the Joomla groups, not even "Administrators" could login. However set the same test account to a "Super User" and they would be able to login. Was the problem authentication? Restricted...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB

  14. MacOs: Transcribe Training Video using OpenAI Whisperhttps://www.joellipman.com/component/content/article/macos-transcribe-training-video-using-openai-whisper.html?catid=60&Itemid=165

    whether it did it in a shorter amount of time; but the next morning I had a "transcript.txt" file in the working directory. However, the outputted transcript file is all in lowercase without any punctuation so ChatGPT was not able to make much sense of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Apple
    • Language: *

  15. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/component/content/article/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html?catid=74&Itemid=165

    4899A", "123A Myhouse". Example #2: Using as a Custom Script Component The above will work as a SSIS Script task. At work however, we needed to separate it out so that it could be used in other SSIS packages. If we included an SSIS Script in each...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB

  16. SSRS Hide results table if emptyhttps://www.joellipman.com/component/content/article/ssrs-hide-results-table-if-empty.html?catid=75&Itemid=165

    confined to functions, temporary tables or little subroutines which just overcomplicates basic simple select queries... However set a counter to 1 for each and then get BIDS to do the sum of this using an MDX expression. T-SQL Expression: Consider the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB

  17. How to change local folder for TFShttps://www.joellipman.com/component/content/article/how-to-change-local-folder-for-tfs.html?catid=79&Itemid=165

    2010 (TFS) instance and set my working local folder to my home directory. When the rest of my colleagues installed it however, they decided to use a common local directory for all workstations so configuration files would not need to be modified. So?...

    • Type: Article
    • Author: Joel Lipman
    • Category: Team Foundation Server
    • Language: *

  18. Basic Oracle Stored Procedure Structurehttps://www.joellipman.com/articles/else/database/oracle-pl-sql/basic-oracle-stored-procedure-structure.html

    simpler stored procedure, I'd imagine you just get rid of the cursor. Why A standalone query is faster in the eyes of SSRS, however within SSRS we don't have the capability to run standard PL/SQL commands... unless they're run from within a stored...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB

  19. Fix Oracle Tnsping 3511 without Windows Registryhttps://www.joellipman.com/articles/else/database/oracle-pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

    as an invite for suggestions on how my business should be run. How? So there are a variety of solutions that will fix this. However we have certain restrictions in my work environment thanks partly to group policies: Need to run with elevated...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB

  20. Generate a Timesheet in MySQL https://www.joellipman.com/articles/else/database/mysql/generate-a-timesheet-in-mysql.html

    and more. Similar systems have popped out that support some form of time recording and activity logging. The example below however is within a LAMP/MySQL environment but the SQL basics are here to help me adapt it to whatever environment people keep...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
Results 21 - 40 of 45