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

  1. ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoicehttp://mail.joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-api-half-a-cent-or-penny-off-when-creating-an-invoice.html

    wrong in any case as they don't match the ZohoCRM... or both are just not matching... either way, your client will likely only accept the previous solution. I wanted to use a regex rather than treat the number as a string and truncate it that way. Given...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  2. Zoho People: Get Performance Records over APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-people-get-performance-records-over-api.html

    above (the one hosted in ZohoPeople) to account for this. It's the end of the day and I will do that tomorrow but there is only so much fun one can have in a day. The next day: Add to a workflow when objective / goal is submitted Here's the code that I...

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

    { v_CrmContactID = r_CreateContact.get("id"); } // // create other contacts (retain the map and only change first name, last name, and email) for each m_OtherContact in m_XeroContact.get("ContactPersons") {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  4. Collin Consulting Ltdhttp://mail.joellipman.com/component/content/article/collin-consulting-ltd.html?catid=33

    backed up my website for 18 months so even if Joe managed to retrieve it I expected most of my data to have gone. Joe not only fixed it immediately but all the data was still there too! Magic!

    • Type: Article
    • Author: Webmaster
    • Category: Portfolio
    • Language: *
  5. Hide Menu Item from Registered and Special http://mail.joellipman.com/articles/cms/joomla/hide-menu-item-from-registered-and-special.html

    by joomla administration but can be done by template code, you can have a module position in the template that is set to only show when the visitor is not logged in e.g. Code: Joomla extension disable menu link for registered users but not for public...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  6. Windows 7 and Google Chrome incognito mode by defaulthttp://mail.joellipman.com/articles/google/windows-7-and-google-chrome-incognito-mode-by-default.html

    start button). All the articles I googled were windows vista so I thought I'd share one for windows 7 here. I'm actually only saving you a click as you can just right-click on the google chrome icon and select "New Incognito Window". This is just how to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  7. How to make your Joomla site use SEO friendly urlshttp://mail.joellipman.com/articles/cms/joomla/how-to-make-your-joomla-site-use-seo-friendly-urls.html

    your website root folder). You'll need ftp access or a file manager with all your website files in). Do not continue if you ONLY have control of the Joomla CMS. Watch the youtube video below which shows you how to do it {youtube}UQkeT0o_U34{/youtube}

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  8. MyALN.bournemouth.ac.ukhttp://mail.joellipman.com/component/content/article/myalnbournemouthacuk.html?catid=33

    their website to reduce the paperwork and manage all the invoicing processes. The site is restricted to staff and students only.

    • Type: Article
    • Author: Joel Lipman
    • Category: Portfolio
    • Language: *
  9. Welcome to my website!http://mail.joellipman.com/articles/web-development/welcome-to-my-website.html

    have little or no documentation. I like workarounds and solutions and persist in the knowledge that anything is possible, I only have to believe. I tend to write about issues that the rest of the crowd so easily give up on. I am usually available for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  10. Frontpage Item Orderinghttp://mail.joellipman.com/articles/cms/joomla/frontpage-item-ordering.html

    be an article). Click on the menu Parameters - Advanced on the right. Set the Category Order to No. Order by Primary Order Only. Set the Primary Order to Default. Click on the Save button at the upper right.

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  11. SSRS Repeat Headers in PDF Reporthttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-repeat-headers-in-pdf-report.html

    Problem I've set some tablix headers but when I request the same report in PDF format, the tablix headers only appear once on the first page. Every subsequent page simply displays the report header (which does not include the tablix header......

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  12. Select unique values in Microsoft Excel columnhttp://mail.joellipman.com/articles/microsoft/excel/select-distinct-values-in-microsoft-excel-column.html

    the data range to do this to. Click on the "Data" tab. Click on "Advanced" (Advanced Filter). Tick the "Unique records only" box. A few more from Microsoft Office Help /* Count the number of unique number values in cells A2:A10, but do not count blank...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  13. Mootools - How to contain a menu sidebar between header and footerhttp://mail.joellipman.com/articles/web-development/mootools/mootools-how-to-contain-a-menu-sidebar-between-header-and-footer.html

    This has taken me too long to figure out and I hope I don't lose this note again. The only website that was titled similarly kept slowing down my computer too much so I decided to work out my own. The complexity is due to content also being dynamically...

    • Type: Article
    • Author: Joel Lipman
    • Category: MooTools Framework
    • Language: en-GB
  14. DBMS Random Referencehttp://mail.joellipman.com/articles/database/pl-sql/dbms-random-reference.html

    Uppercase) L (for Lowercase) A (for AlphaNumeric) X (for Alphanumeric with upper case alphabets) P (for Printable characters only) Usage select dbms_random.random from dual; -- yields random number, eg. 68489408 select dbms_random.value from dual; --...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: *
  15. SharePoint 2007: Change profile picture with minimal permissionshttp://mail.joellipman.com/articles/microsoft/sharepoint/sharepoint-2007-change-profile-picture-with-minimal-permissions.html

    right) Click on your own name or picture to see your profile page Click the “Edit Details” beneath your contact information (only visible if this is your own profile) Set the picture field to the http://... link to the image “Save and Close”

    • Type: Article
    • Author: Joel Lipman
    • Category: SharePoint
    • Language: *
  16. Error 404 Component Not Found when enabling SEF URLshttp://mail.joellipman.com/articles/cms/joomla/404-component-not-found-sef.html

    and report the error below. 404 Component not found. Just because I'm doing something like this: How? I found that this was only affecting my subdomains where this template was installed. I installed some terrible 3rd-party SEF plugins to correct the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  17. CSV Chart Generatorhttp://mail.joellipman.com/component/content/article/csv-chart-generator.html?catid=40

    chart which you can zoom in and out of, includes almost every type of chart you can think of (though this program only uses chart types: Area, Bar, Column, Line and Pie). Note that AMCharts.com is free as long as you leave the copyright information. If...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  18. SELECT COUNT(DISTINCT name) FROM tablehttp://mail.joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

    method 3 is an accepted answer over the web because as soon as I put a WHERE clause in the statements and check the numbers, only method 1 and 2 return the correct number. I'm still unsure as to why WHERE...GROUP BY... doesn't return the same totals and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  19. Zoho Deluge - Get Full Day Namehttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-get-full-day-name.html

    the code to retrieve the full day name from a date (eg. "Monday"). Why? If I use the toString() function to get the day, it only returns the first 3 letters of the day (eg. "Mon"). My_Date = today; Day_Name = My_Date.toString("E"); // returns "Mon" How?...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  20. Zoho Deluge - Regex to Strip all non-numeric charactershttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-regex-to-strip-all-non-numeric-characters.html

    A quick post on how I managed to build a regex to extract all non-numeric characters (all non-digits) from a string. Why? I only want the digits/numbers from a string: v_PaymentTerms = "Credit Note - 30 Days"; // we want the 30 from the above string...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 221 - 240 of 243

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Please publish modules in offcanvas position.