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

  1. Joes Word Cloud (JWC)https://joellipman.com/component/content/article/module-joes-word-cloud-jwc.html?catid=53&Itemid=165

    Download the appropriate file for your system (see compatibility table below) Login to your Joomla admin panel and install as per usual. How to Use Install the ZIP using your Joomla! Admin Panel > Extension Manager View the module on your front-end to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  2. AwStats Data Parser (ADP)https://joellipman.com/component/content/article/awstats-data-parser-adp.html?catid=53&Itemid=165

    by my infographic script which allowed quicker reports then scanning entire website visitor logs. No installation and USB portable. Currently runs using either Windows XP or Windows 7. How to use: Save a frame of your Awstats page (so there isn't the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  3. Zoho Deluge: Loop through 30 Minute Slotshttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-loop-through-list.html

    when the closing hour is found. The picklist field is called "Time_Field". The following reads from a form (creator data table) where thisServiceRecord.Opening_Time is returning an hour value (eg. "08:00") and thisServiceRecord.Closing_Time returns an...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  4. Zoho Creator: info/alert/modal/popup notification for any userhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

    and the popup size will automatically resize based on content. I tend to use the first solution combined with a form/table of standard messages allowing the client to enter their own text to display to their users. A preset form/page with openUrl could...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  5. Zoho Deluge: Sort a Map by a specific fieldhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-sort-a-map-by-a-specific-field.html

    date in descending order. Yes this functionality exists in reports but I want to do it in code so as to display it in a HTML table. What I have: id name date --------------------------------------------- 46498 Joel 1977-11-14T12:30:00+00:00 8949...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  6. ZohoCRM: Deluge: Map a custom field from user profilehttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-deluge-map-a-custom-field-from-user-profile.html

    The following code snippet will get the Opportunity/Deal/Potential record details, then get the Owner frrom the CRM users table, find the value of the custom field and search for this (if it is a lookup to a module - only returns as string), and updates...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  7. Zoho Deluge: Today, Tomorrow, Day After but Skip Sundayhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-today,-tomorrow,-day-after-but-skip-sunday.html

    v_Day3_Ordinal = ifnull(m_Ordinals.get(v_NextDay.toString("d").toLong()),"th"); Then in my HTML table, I can use the headers: v_Day1_Header = " Today " + v_Today.toString("EEEE") + " " + v_Today.toString("MMMM") + " "; v_Day2_Header = " Tomorrow " +...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  8. Zoho Deluge: Calculate start and end of Daylight Savings Timehttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-calculate-start-and-end-of-daylight-savings-time.html

    not been tested extensively. Do not use if you are unsure it is calculating correctly. I use these to store the values in a table that can be double-checked at a later date. Source(s): Joel Lipman: Zoho Deluge: Generate List of TimeZones Joel Lipman...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  9. Zoho CRM & Creator: Download attachment and upload to Creator file fieldhttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-creator-download-attachment-and-upload-to-creator-file-field.html

    An attachments section to hold a notes field. A notes field called "Note_Attachments" (this will display a HTML table with click-to-download files) A blank subform callled "Attachments" (links to a form called "Documents") Here's the Creator form to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  10. Zoho Creator: Populate a Multi-Lookuphttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-populate-a-multi-lookup.html

    or text is possibly a quicker solution and when using a desktop interface, you can parse the multi-line into a nice HTML table. But on a mobile device, it's somewhat better to use the built-in interfaces provided by Zoho Creator. What I really needed...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  11. Zoho Analytics: Determine profits from invoices and purchase ordershttps://joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-determine-profits-from-invoices-and-purchase-orders.html

    notes issued in a particular month rather than the one-to-one with an invoice as profits in the past would change. So this table is created so that if a credit note was issued in January for an invoice issued prior to this, and we want to work out...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  12. Zoho Deluge: Determine if Daylight Savings are in effecthttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-determine-if-daylight-savings-are-in-effect.html

    in the US, where there could be 4 different timezones between customer, agent, HQ, server; we would create a separate table to manage this data. I can't do this for every client, so here's a quick snippet to just check if Daylight Savings are in effect...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  13. Zoho Creator: Get Images in Report to be Exported to PDFhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-get-images-in-report-to-be-exported-to-pdf.html

    p_TicketRef) { v_TicketRef = ifnull(p_TicketRef,""); c_TicketRecords = QC_Report_Table[Ticket_Number == v_TicketRef]; for each c_TicketRecord in c_TicketRecords { info "Ticket Ref: " + c_TicketRecord.Ticket_Number; v_CountImages = 0; v_CountNew = 0; for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  14. ZohoCreator: Basic Widget with Zoho Datahttps://joellipman.com/articles/crm/zoho/zoho-creator/zohocreator-basic-widget-with-zoho-data.html

    and before I added all the layers of complexity, I want to have here an example that demonstrates a basic search on a table of data and returns one record as a result. The use-case here is that we are enhancing a quote builder form in Zoho Creator. The...

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

    - Connect to Xero API so here's the pull of the first page of invoices by most recent first (invoice date). There is also a table that returns the name of tax rates and then the percent that these equate to which I've copied below this invoices pull...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  16. Installing phpBB3 for Joomla with a RocketTheme templatehttps://joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

    you already have a working Joomla website set up. Go to the phpBB website (www.phpbb.com) and download their latest stable release. At the time of this article, this was version 3.0.5, but RocketTheme are fully aware of this and seem to be committed to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  17. Lazy stats: Yootheme / Gavick Pro / Rocket Theme Comparisonhttps://joellipman.com/articles/cms/joomla/lazy-stats-yootheme-and-gavick-pro.html

    providers. When I'm less caught up in work I'll try adding to this article. But here's some lazy stats: Package Comparison Table Personal Business Developer YooTheme 3 months 1 license Unlimited YOOtools 39 € ($53) 12 months 3 licenses Unlimited...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  18. Google Event Ilustrations aka Flairshttps://joellipman.com/component/content/article/google-event-ilustrations-aka-flairs.html?catid=61&Itemid=165

    back rub, backrub, massages newyear: new year, new year's, new years oilchange: oil change, car service pingpong: ping pong, table tennis, ping-pong, pingpong planmyday: plan week, plan quarter, plan day, plan vacation, week planning, vacation planning...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: *
  19. SSIS Multiple Lookups in onehttps://joellipman.com/component/content/article/ssis-multiple-lookups-in-one.html?catid=74&Itemid=165

    convert the data and output it to the target system. For our package to decode what "M" means, it needs to look this up in a table on the original server. We had around 12 lookups to do, so you could do this: But we didn't want to do this. How? As a...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  20. Returning Oracle Stored Procedure Resultset in SSRShttps://joellipman.com/component/content/article/returning-oracle-stored-procedure-resultset-in-ssrs.html?catid=75&Itemid=165

    credentials in data source) to run this stored procedure. CREATE PUBLIC SYNONYM sp_get_studentdetails_from_ad FOR base_table_owner.sp_get_studentdetails_from_ad; GRANT EXECUTE ON sp_get_studentdetails_from_ad TO my_ssrs_user; Notes: No "SELECT... INTO...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
Results 81 - 100 of 120