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

  1. ZohoAnalytics: Pivot Campaigns vs Contactshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zohoanalytics-pivot-campaigns-vs-contacts.html

    Name" IN ( "Campaign 1","Campaign 2","Campaign 3" ) ) t2 The bigger query: Now create another query (better to refresh the page so that the new table and columns will be available to us): SELECT c."Full Name", c."Lead Source", cp."Campaign 1",...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  2. ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

    evaluate v_currentDate = zoho.currentdate.toString("yyyy-MM-dd"); v_OrderDate = zoho.currentdate.toString("yyyy-MM-dd"); v_Page = 1; v_PerPage = 10; m_Output = Map(); l_Costs = {11,13,15,17,20}; b_DebugMode = true; l_DebugMessages = List();...

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

    Not sure about the rest of you, but I've been using this for pagination purposes and for the system to work out how many pages or loops in total it would need to do. How? Here's a couple of working examples I use in production systems: Pre-amble: I'm...

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

    it is intended to be all in the same function as there are references to some variables in earlier snippets of code on this page. Error(s): 2945: UPLOAD_RULE_NOT_CONFIGURED Was happening when I was trying to update the Zoho Creator record, specifically...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  5. Zoho Analytics & Zoho People: Monitor DataSource Sync https://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-zoho-people-monitor-datasource-sync.html

    = "12345000001234567"; // // to get the Analytics Org ID, login to Zoho Analytics, ensuring you are on the "Home" page (click on "Home" in top menu if not), // then click on the cog icon "Organization Settings", then click on "Organization Details", //...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  6. Zoho Projects: Get All Eventshttps://www.joellipman.com/articles/crm/zoho/zoho-projects/zoho-projects-get-all-events.html

    find anything that documented this with a working example. Why? The use-case here is that we want to make a ZohoCreator page display events for this month from ZohoProjects. How? The bit that stumped me was making a call to the Events endpoint as it...

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

    optional. Click on "Create" and select "New Table / Import Data": One of the last options on the "Import Your Data" page is "Enter Data Right Away": You'll be presented with a table of about 10 columns called "Untitled-1". I enter some labels in the...

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

    Completion: Attach the signed document to the contact record [DEPRECATED: Please use Generic Webhook at the bottom of this page] For this, we'll create the webhook function first (this one I've called Fn - ZohoSign - Document Completed) and then make it...

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

    images of products that they want to appear in a dropdown menu of a JavaScript widget. When the user first loads up the webpage containing the widget, 10k images are downloaded. I have put in a lazy loading process where it will load the first few...

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

    the current feed. Go to Banking > Selet the active account (click into it) and click the gear icon in the top right of this page (not the one next to your profile as that's global settings but the one next to the "Import Statement" button). Reconnect...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  11. Applying a button and centering it in the RocketTheme Affinity templatehttps://www.joellipman.com/articles/cms/joomla/applying-a-button-and-centering-it-in-the-rockettheme-affinity-template.html

    do so I thought I'd document it for future reference. The Issue See the restore default setting link at the bottom of this page in the footer? I wanted to put one of the styled buttons behind it but then found that there's a lot more to do than just...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  12. Using MetaMod to hide buttons from logged in usershttps://www.joellipman.com/articles/cms/joomla/using-metamod-to-hide-buttons-from-logged-in-users.html

    a solution that works 100% for me using the MetaMod tool without using any template hacks. The instructions on the metamod page are very vague so I wanted to make it bit more in-depth for this specific use. I'd love to hear if this helps you. Let me...

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

    infect your computer. For detailed information about the problems with this site, visit the Google Safe Browsing diagnostic page for this address I understand that visiting this site may harm my computer. Continue? Even if you use the latest versions of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  14. Uninstalling AEC Central and installing Community Builderhttps://www.joellipman.com/articles/cms/joomla/uninstalling-aec-central-and-installing-community-builder.html

    - AEC ErrorHandling 12. Tick System - AEC Routing 13. Tick User - AEC User 14. Click the Uninstall icon at the top of the page 15. Click on the Modules link (to uninstall modules) 16. Tick mod_acctexp (if you installed this) and Uninstall. 17. Click on...

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

    $content_count; mysqli_free_result( $db_connect ); Clear as mud? Feel free to use the comment fields at the bottom of this page to ask a question. Additional I'm pretty sure you don't need all the require files and my solution may be crude, but this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  16. Adding a selectable background to a Yootheme templatehttps://www.joellipman.com/articles/cms/joomla/adding-a-selectable-background-to-a-yootheme-template.html

    file. Note the same filename as in the option value of the previous step. body#page { background: #f4f5f5 url(../../images/background/ambientturquoise/ambientturquoise.jpg) 0 0 no-repeat; } If using an image, create a folder and add the image matching...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  17. Registered Users Cannot Login - Super Users Canhttps://www.joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

    This article is a note on how I fixed an issue on a client site. The website had a redirect on the login which would go to a page accessible by "registered" users but only "Super Users" could actually login. "Registered" users would not be able to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  18. Export Joomla Users scripthttps://www.joellipman.com/articles/cms/joomla/export-joomla-users-script.html

    was more fun. Simply create a text file with the following code and upload it to the root of your Joomla website. Access the page from a browser and you should get all your users listed... For security reasons, delete the file after you have used it. IT...

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

    allow,deny deny from all ErrorDocument 403 http://www.joellipman.com/error/403.html # change this to your 403 - forbidden page. These are two methods I like and will work in tandem. They will not affect the standard visitors to your Joomla website...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  20. Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttps://www.joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

    into each category and hit save and close starting with the parent categories first Copying article heading images from SP Page Builder to normal Joomla Articles SELECT new.`id`, old.`id`, json_extract(old.`attribs`, '$.spfeatured_image') AS...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
Results 121 - 140 of 167