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

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

    rule stage). A workflow email notification doesn't do the popup on the CRM as well. A workflow notify by email didn't give the option to remind daily... only weekly or monthly. Spent a while trying not to use code but here we are. Code is our friend....

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

    Select the relevant workspace and click on "Next" Select "Custom Query" in step 2 and paste your Zoho SQL query in here. Give it a name, set the schedule and then wait for it to finish building the table. If you want the Zoho SQL (Ansi-SQL?) used to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  3. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

    where the template exists in Zoho Sign. But now how do we do this using simply a Mail Merge template held in ZohoCRM? Let's give it a go: Scenario 2: Custom Module Mail Merge: Template exists in ZohoCRM For this scenario, the use-case is a little more...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  4. ZohoCRM & Xero: Function to pull most recent quoteshttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-quotes.html

    ??? - ??? More Information: Ensure that all possible tax rates in Xero match those in Zoho; the output of this function will give you a copy&paste list ******************************************************************************* */ // init v_Output =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  5. Improve Default Joomla Search https://joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

    want to order by more than just popularity and/or date, but also by our own relevance heuristics. The following change would give radically high relevance to articles where the search term is found in the title. \plugins\search\content\content.php:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  6. MacOs: Transcribe Training Video using OpenAI Whisperhttps://joellipman.com/component/content/article/macos-transcribe-training-video-using-openai-whisper.html?catid=60&Itemid=165

    is ok Could you do the same with the attached please? Feel free to include details of what you know of [Video Topic]. Give the transcript to some popular LLMs: [Score: 7/10] I gave the transcript.txt file (all lowercase no punctuation) to Google's...

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

    Settings Select Create View Select Datasheet View (you could probably use a "Standard View", I just used the Datasheet one) Give the view a name, select what columns you want the form to have (I included the IDs for functional purposes) Further down the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Infopath
    • Language: *
  8. SSIS Convert a string into a datehttps://joellipman.com/component/content/article/ssis-convert-a-string-into-a-date.html?catid=74&Itemid=165

    + "-" + SUBSTRING(Date,3,2) + "-" + SUBSTRING(Date,1,2) + " 00:00:00") So although your SSIS IDE (Visual Studio?) will give you a useless Microsoft message saying something like: Error: Data conversion failed while converting column "This_Date" (3833)...

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

    p_STUDENT_ADNAME || ':$:' || SQLERRM, TRUE); END sp_get_studentdetails_from_ad; Permissions on this SP Might need to give permission for your SSRS user (specified credentials in data source) to run this stored procedure. CREATE PUBLIC SYNONYM...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  10. Print Directory Contents to a Filehttps://joellipman.com/component/content/article/print-directory-contents-to-a-file.html?catid=80&Itemid=165

    Select the "(NONE) Folder" option Click on "Advanced" Click on "New..." Enter the New Action as per the following: Action: - Give the action name a memorable name (eg. "Print Directory Contents To File") Application: - Type the following...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  11. Apple Magic Trackpad with Windows 11 Intelhttps://joellipman.com/component/content/article/apple-magic-trackpad-with-windows-11-intel.html?catid=80&Itemid=165

    see a Magic Trackpad - but not connected. Try switching the trackpad on and off and pair it up again but bear in mind to give it a few seconds to reconnect. If it still doesn't work, I had to repeat the preivous step of installing the driver and wait a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  12. The ReportServer Databasehttps://joellipman.com/articles/else/database/the-reportserver-database.html

    do I get the milliseconds between start and end times instead of summing the remaining columns? Correction, sum will only give me the total time but what if a report has been run twice more often then another, then is it slower? Not necessarily. Like...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  13. Fix Oracle Tnsping 3511 without Windows Registryhttps://joellipman.com/articles/else/database/oracle-pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

    Under "System Variables" modify the variable "ORACLE_HOME" (without the quotes). Or create NEW if it doesn't exist. Give it the value C:\ORACLE\product\11.2.0\client_1 OK all dialogs to close and save. Additional The affecting TNSNAMES.ORA file for the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  14. Accessing a MySQL Database with Business Intelligence Development Studiohttps://joellipman.com/articles/else/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

    Development Studio (BIDS) Right-click on "Shared Data Sources" in the Solution Explorer > select "Add New Data Source" Give the DataSource1 a more memorable name Click on the "Edit..." button Click on the "Change..." button Select "ODBC" and click on...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  15. Merge the content of two similar tables in MySQLhttps://joellipman.com/articles/else/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

    for most SQL forms). I found that to add further tables, simply start with another "UNION ALL" clause with a note to give the 3rd table a different alias to the 2nd (so "C" instead of "B"): SELECT title, intro FROM ( SELECT `title`, `introtext` intro...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  16. MySQL: Count occurrences of words in a columnhttps://joellipman.com/articles/else/database/mysql/mysql-count-occurrences-of-words-in-a-column.html

    clause which omits words less than 5 characters in length, and some other words not to count. I have added the ORDER BY to give me the highest count first in descending order. I have added a LIMIT to only return the top 50 words. Source(s): Counting...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  17. Webdeveloper-Speakhttps://joellipman.com/articles/cms/website-development/webdeveloper-speak.html

    write an article on another site but I came across it and rather than just add it to my weblinks section, I thought I'd give it a little more credit. "Motive is a web design and development agency based in Wellington, New Zealand providing consultation,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  18. Inline Labels in Form Fields using Javascripthttps://joellipman.com/articles/cms/website-development/js/inline-labels-in-form-fields-using-javascript.html

    style="color:grey" - add a styling to it by default (on initial load), in this specific case the color grey. value="Name:" - give this field a default value. In this specific case, we are giving it the label value to indicate to the user to enter their...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: en-GB
  19. Sort an associative array by values in Javascripthttps://joellipman.com/articles/cms/website-development/js/sort-an-associative-array-by-values-in-javascript.html

    What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's...

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

    have a search feature? I do. I think it defeats the purpose of cramming information endlessly in cyberspace. So we want to give a search engine to our users. This sounds really simple, we could try: $search_term_esc = AddSlashes($search_term); $sql =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
Results 61 - 80 of 82