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

  1. 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

    API" Then click on the API switch to enable it and copy the resulting URL to your clipboard Now login to ZohoSign In the left sidebar, go to > Settings > Developer Settings > Webhooks Copy and paste the URL and set the callback events (triggers) to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  2. Zoho CRM Client Script: Map Quote to Invoicehttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-client-script-map-quote-to-invoice.html

    someone skips the process, in other words, goes to the quote record, and clicks on the plus icon next to "Invoices" in the left sidebar? This script will map over the core fields, address, and line item. This took me a while to get the right syntax for...

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

    code (below) For this website template: I've added the module-dark classes. Specified float:none to get rid of float:left Specified width of readon-wrap1 to the width of the button Specified margin:0 auto to center readon-wrap1 Original Code: New Code:

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  4. Basic Joomla 2.5 Mootools Formhttps://joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

    // Send the form. this.send(); }); }); .aCoupleOfDivs { background-color:#efefef; border:2px solid #ccc; width:300px; float:left; } Basic Mootools Form in Joomla 2.5 Basic Mootools Form in Joomla 2.5 Name: E-Mail: Sample CheckBox: Sample SelectList:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  5. Call to a member function mark() on a non-object in Joomla CMShttps://joellipman.com/articles/cms/joomla/call-to-a-member-function-mark-on-a-non-object.html

    restore them from a backup. NOTE: Only restore the files! The images and database were unaffected in our case and could be left as they were. Our last file backup was over a year old but we only needed the core files, a working system, and then we could...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  6. Joomla: Remove IDs from URLs for out-of-the-box SEFhttps://joellipman.com/articles/cms/joomla/joomla-remove-ids-from-urls.html

    All GUI Now login to your Joomla Administrator section Browse to System > Global Configuration Click on "Articles" in the left sidebar Under "SEO Settings" set to "Yes" to the options: Search Engine Friendly URLs Use URL Rewriting Add Suffix to URL...

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

    "w") as f: f.write(" ".join(transcript)) Run the Python Script to Transcribe python3 transcribe_vosk.py I left the script running overnight so I'm not sure whether it simply played it for 5.5 hours and transcribed it or whether it did it in a shorter...

    • Type: Article
    • Author: Joel Lipman
    • Category: Apple
    • Language: *
  8. Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://joellipman.com/component/content/article/google-drive-oauth-using-service-account-in-php.html?catid=61&Itemid=165

    } 6a. Use existing Access Token This if else statement simply says if the token still has at least 5 minutes left, then use the one found at the file location specified earlier. if( $api['jwt']['token']['minutes'] > 5){ $access_token =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  9. 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

    so simple. Hey presto, I found a cheat/workaround: Click on the list to see your datasheet (has a MS Access icon in the top left to remind you what you're getting yourself into) Go to Settings Select Create View Select Datasheet View (you could probably...

    • Type: Article
    • Author: Joel Lipman
    • Category: Infopath
    • Language: *
  10. Report Builder 2.0 - Hide Series1https://joellipman.com/component/content/article/report-builder-20-hide-series1.html?catid=75&Itemid=165

    part of your database. In my example, the team members could have changed and that a person doing most of the jobs suddenly left or moved to another team. To exclude the rest and only show "Series1" Took me a while to figure this out but modify the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  11. Alternate row background colour in Reporting Serviceshttps://joellipman.com/component/content/article/alternate-row-background-colour-in-reporting-services.html?catid=75&Itemid=165

    "DataSet1") returns the maximum number of rows retrieved Yields something like: This is the bottom left of a report where both the above examples (fill and borders) have been applied:

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  12. SSRS Hide results table if emptyhttps://joellipman.com/component/content/article/ssrs-hide-results-table-if-empty.html?catid=75&Itemid=165

    is the name of the dataset. Bring up the tablix properties (or the textbox you want to hide) Select "Visibility" in the left margin Type the following expression (where "Equipment" is the name of the dataset) =IIF(Sum(Fields!Counter.Value, "Equipment")...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  13. SSRS Querying on either of 2 Parametershttps://joellipman.com/component/content/article/ssrs-querying-on-either-of-2-parameters.html?catid=75&Itemid=165

    only). So following the above, I end up with: Then I want the ID parameter ("@StudentReference") to populate itself if it is left blank when the report is executed. So my first dataset has to include the Username check as well (…WHERE...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  14. SSRS: Performance Improvements: SELECT TOPhttps://joellipman.com/component/content/article/ssrs-performance-improvements-select-top.html?catid=75&Itemid=165

    Not the internal processing and rendering as the report server says it did this in 0.4 seconds. So where's the problem? How? Left to its own devices, a search for "SMITH" as a surname would make the report spin for about 10 minutes without the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  15. Running Internet Explorer 6, 7, 8 as standaloneshttps://joellipman.com/component/content/article/running-internet-explorer-6-7-8-as-standalones.html?catid=80&Itemid=165

    your main Start menu button) As soon as it loads, press DEL to enter the BIOS setup. Navigate to the "Boot" section with the left & right arrow keys Press "Enter" on Boot device priority Press "Enter" on the first boot device Select "CDROM" Press "F10"...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  16. Search a database for a string (MySQL, T-SQL)https://joellipman.com/articles/else/database/search-a-database-for-a-string-mysql-t-sql.html

    = 0 AS /* Parameters and usage @Tablenames -- Provide a single table name or multiple table name with comma seperated. If left blank , it will check for all the tables in the database @SearchStr -- Provide the search string. Use the '%' to coin the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  17. SQL Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/else/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

    e.EventDate, --event details to display e.Note --CTEs defined above are used as the queries for the results FROM Dates d LEFT JOIN Events e ON CAST(CONVERT(VARCHAR(10),e.EventDate,101) AS DATETIME) = d.[Date] --Set the maximum times the Dates cte can...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  18. DataTumble - Randomize Data Rowshttps://joellipman.com/articles/else/database/t-sql/datatumble-randomize-data-rows.html

    BEGIN TRY BEGIN TRANSACTION A DECLARE @NumberLeft INT DECLARE @random INT DECLARE @CurrentID INT DECLARE @ScrambledID INT DECLARE @Data VARCHAR(MAX) DECLARE @UpdateData VARCHAR(MAX) DECLARE @Chosen BIT DECLARE @ChosenID INT DECLARE @SqlStatement...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  19. SQL Queries for Statisticshttps://joellipman.com/articles/else/database/mysql/sql-queries-for-statistics.html

    FROM custombu_stats_visits a WHERE YEAR(a.DateTimeStamp)='2010' GROUP BY a.VisitorIP ORDER BY MAX(a.VisitorID) DESC ) t1 LEFT OUTER JOIN wikimedia_user b ON t1.ID=b.user_id GROUP BY t1.IP ORDER BY b.user_name ) t2 GROUP BY MONTH(t2.Date); Notes: I use...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  20. Developer's Checklist: Taking over a projecthttps://joellipman.com/articles/cms/website-development/developers-checklist-taking-over-a-project.html

    that works for me. Most Difficult? My hardest project was (still is) one created by a PhD student who graduated and left the institution. It was a custom-built site written from scratch, and it's purpose was to manage Staff and Students within the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
Results 61 - 80 of 93