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

  1. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

    v_ThisTimeZone) Incorrect Created By: this is because the system manager who initially set up CRM is used by default. By creating a connection as a system user with the necessary scopes to this CRM instance, untick use credentials of logged-in user, and...

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

    return m_RelatedList; Additional Note that for reading the data from Analytics, we cheat by creating a table in ZohoAnalytics rather than simply writing a query and using the 'asynchronous' method to extract the query result. To create an analytics...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  3. Zoho Creator: Input Color Pickerhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-input-color-picker.html

    An article on creating a color picker from a specific palette using an input field of a radio type. Why? At the time of print, this feature is not provided out-of-the-box and getting our users to learn about hexadecimal color references and Red Green...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  4. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Templatehttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-books-estimates-quotes-accept-decline-buttons-on-template.html

    other than what the interface offers, into the template. the CRM webhook API function So let's do my favorite method of creating a REST API function in CRM Login to ZohoCRM > Setup > Functions > New Function Give it a function name, I'm calling mine...

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

    = invokeurl [ url :v_Endpoint type :PUT parameters:m_Data.toString() connection:"zcrm" ]; info r_QuoteDetails; } Creating a record Pretty much the same as above but instead of the method/type PUT you will use POST with an endpoint of...

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

    via your online banking and authorise Zoho Books. Once redirected back, link the feed to the existing account (rather than creating a new one) so previous transactions remain associated. Fetch transactions and verify. Once the connection is restored,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  7. Setup a copy of your Joomla websitehttps://www.joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

    all files in LIVE (except for configuration.php) and copy these to TEST using the web-based file manager. Above & Beyond Creating subdomains allows your developers to simply change the http://www.mysite.com to your development environments, eg....

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  8. Basic Android App using Google Maps and Current Locationhttps://www.joellipman.com/articles/else/app-dev/android-os/basic-android-app-using-google-maps-and-current-location.html

    writing an app for a tablet running Android and wanted to include a Google Map. The following exercise focuses solely on creating an app which opens Google Maps at your current location. How? I couldn't find any instructions using the tools I had...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  9. Android: Keytool and Google Maps displaying greyhttps://www.joellipman.com/articles/else/app-dev/android-os/android-keytool-and-google-maps-displaying-grey.html

    the respective dialogs (note that setting the variable via the command prompt will NOT work!) To get the Test SHA1 code: Creating a Google Maps project in Android Studio (v0.8.6 beta) "creates" a SHA1 along with the project name: something similar to:...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  10. Transferring Apps (purchases) from iPhone 4s to 5s on a Windows PChttps://www.joellipman.com/articles/else/app-dev/ios/transferring-apps-purchases-from-iphone-4s-to-5s-on-a-windows-pc.html

    a different backup so click on the dropdown to make sure it's the one you just made). Enter the password you entered when creating the Encrypted Backup. Wait for the restore to complete. The new phone will restart but you have to wait for the sync to...

    • Type: Article
    • Author: Joel Lipman
    • Category: iOS
    • Language: *
  11. Sort order a dropdown list in MS InfoPath without programminghttps://www.joellipman.com/component/content/article/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html?catid=73&Itemid=165

    So this is for Microsoft Office Infopath 2007 (SharePoint 2007). The situation is that I started creating a SharePoint List (datasheet) and when I made my form dropdown read from the list, it just put elements in the order that I entered them in the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Infopath
    • Language: *
  12. SSIS Skip Blank Rows in Flat File Sourcehttps://www.joellipman.com/component/content/article/ssis-skip-blank-rows-in-flat-file-source.html?catid=74&Itemid=165

    pushed out of alignment (something about {CR}{LF} being displayed for the blank rows and inserted in the next line) and creating discrepancies that would error the flow. Solution Found!!! Taking the idea that the Carriage Return (CR) or Line Feeds (LF)...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  13. SSIS: How to loop through multiple flat files as data sourceshttps://www.joellipman.com/component/content/article/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html?catid=74&Itemid=165

    connection manager but this is inefficient and not versatile enough to accommodate files that get added later. Why? I am creating an extract SSIS package intended to take a text file as its source and to populate a database table with this data. Note...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  14. Parameters not being used in report processinghttps://www.joellipman.com/component/content/article/parameters-not-being-used-in-report-processing.html?catid=75&Itemid=165

    (BIDS) or Report Builder 2.0 and when previewing the report, the parameters are not accounted for (ie. the SQL query creating the dataset does not use the parameters in its query). Problems: Given a date, the date format was reverting to US format as...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  15. Hide a Drive per User in Windows 7https://www.joellipman.com/component/content/article/hide-a-drive-per-user-in-windows-7.html?catid=80&Itemid=165

    undo the above if you didn't want this applied to the current logged-in user (delete the NoDrives DWORD). The concept of creating the NoDrives registry entry is what you need to remember. In the example below, we are applying the same principle to a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  16. Generate a Timesheet in MySQL https://www.joellipman.com/articles/else/database/mysql/generate-a-timesheet-in-mysql.html

    minutes on setting up a Joomla 2.5.x demo site; I started at 9am and finished at 9:45.", "Monday morning, I also worked on creating a template for the site I just made; I started at 9:45 and finished at 12:00") The final system needs to specify every...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  17. PHP & MySQL Search Enginehttps://www.joellipman.com/articles/cms/website-development/php/php-a-mysql-search-engine.html

    { $omitted_words_array[]=$term; $out[]=$term; } } $terms=array(); $terms=$out; # start creating the sql query $terms_db = search_db_escape_terms($terms); $terms_db_sql = search_final_clean($terms); $parts = array(); foreach($terms_db as $term_db){...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  18. Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=105&Itemid=165

    Height - Parameter: Force no underlines - Parameter: Force no image borders - Debug mode also displays list of urls (for creating text file to be used by JWT program). - Date Uploaded: Sun, 3rd Jul 2011 1.2 - Upgraded to work on Joomla 1.6 websites -...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  19. SSIS: Add Reference Microsoft.SqlServer.TxScripthttps://www.joellipman.com/component/content/article/ssis-add-reference-microsoft-sqlserver-txscript.html?catid=74&Itemid=165

    This article is so that I don't spend so long in googling what the TxScript referenced assembly is when creating an SSIS custom component. How? This is simply the "Script Component" under "Extensions". No MSDN website said this... obvious to Microsoft...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  20. SSRS Expand specific drilldown by defaulthttps://www.joellipman.com/component/content/article/ssrs-expand-specific-drilldown-by-default.html?catid=75&Itemid=165

    pasted from other sites) but they refer to SQL Server 2000 or SQL Server 2005. This is how to do it in SQL Server 2008 and creating a report in Business Intelligence Development Studio (BIDS) or MS Report Builder. Scenario I have a report that specifies...

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