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

  1. URL passed settings in Reporting Serviceshttps://joellipman.com/component/content/article/url-passed-settings-in-reporting-services.html?catid=75&Itemid=165

    Further rendering options: MS Reporting Services Device Information Settings To specify the zoom configuration (defaults to 100%) http:///ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render &rc:Zoom=100% Note:...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  2. Productshttps://joellipman.com/component/content/category/products.html?Itemid=165

    • Type: Category
    • Language: en-GB
  3. Quadcopter App with Flight Restrictions (JQA)https://joellipman.com/component/content/article/quadcopter-app.html?catid=53&Itemid=165

    What? This is an article serving as documentation for my first ever app on the Android Operating System. For tablets and phones. The app in a nutshell displays flight restrictions in a given area Description As a quadcopter flier myself, I wanted an app...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  4. Zoho Deluge - Get Refresh/Access Token API v2https://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-refresh-access-token.html

    What? A sorta quick article to note how I can generate refresh tokens and access tokens using Zoho Deluge code (so within Zoho Creator, CRM or Books) without XML calls. Why? I find myself using this more and more now that API v1 is on the way out and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  5. Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://joellipman.com/articles/crm/zoho/zoho-people/zoho-people-reject-an-application-for-leave-in-deluge.html

    = l_DeptEmployees.size(); // ensure total is not zero as we need to divide by it (defaulting to 2 because if 1 then it's 100%, as 2 it's 50% might have it booked off) v_TotalDeptEmployees = if(v_TotalDeptEmployees 80 && v_TotalDeptEmployees>1) { // //...

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

    What? This is a very quick article with a code snippet on how I added to a multi-lookup field. Why? Using a multi-line 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  7. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://joellipman.com/articles/crm/zoho/zoho-other/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

    What? A quick article on my adaptation of some code posted by Poorvik Palanikumar on the Zoho Community Forums to connect a ZohoCliq to the OpenAI API and ChatGPT... Note that I have another article for those who want to integrate ChatGPT with ZohoZIA....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  8. Zoho Creator: Render to PDF with margins and page numbershttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

    #my-footer{ color: #111; font-family: 'Lato', sans-serif !important; font-size: 10pt; font-weight:300; } .my-table{ width: 100%; margin-bottom:20px; } .my-table td, .my-table th { padding: 5px 10px; } /* letterhead header */ #my-header .my-table thead{...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  9. Zoho Projects: Get All Eventshttps://joellipman.com/articles/crm/zoho/zoho-projects/zoho-projects-get-all-events.html

    What? A quick article because I couldn't find anything that documented this with a working example. Why? The use-case here is that we want to make a ZohoCreator page display events for this month from ZohoProjects. How? The bit that stumped me was...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Projects
    • Language: *
  10. ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

    What? An article on a client script used in CRM which is a working example of rewriting a subform (line items of an invoice) and calls a REST API fuction to return the custom fields of the line items. Pretty much a function which took me a day to write....

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

    What? Just noted this down in case I need to do it again. This article documents how to take a 5.5 hour video (MP4) and have it transcribed by a locally installed AI on a MacOS (running Sequoia 15.1.1). Why? Needed for training videos as a follow-on...

    • Type: Article
    • Author: Joel Lipman
    • Category: Apple
    • Language: *
  12. Parameters not being used in report processinghttps://joellipman.com/component/content/article/parameters-not-being-used-in-report-processing.html?catid=75&Itemid=165

    Once again I've spent a whole morning going in the wrong direction with a convincing SQL script. This article is just a note on when using Business Intelligence Development Studio (BIDS) or Report Builder 2.0 and when previewing the report, the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  13. Reorder Columns in a Tablehttps://joellipman.com/articles/else/database/reorder-columns-in-a-table.html

    What? Just a quick note to myself on how to reorder columns as I was having difficulty using a phpMyAdmin interface to do this. How? Taken from the best forum for programming Qs&As: http://stackoverflow.com/questions/4095481/easy-way-to-re-order-columns...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *
  14. DataJumble - Shuffling characters in a data valuehttps://joellipman.com/articles/else/database/t-sql/data-shuffling-function.html

    This was called a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which merely uses the same characters but switches their order randomly, so I've renamed it DataJumble as opposed to my article on...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  15. DataScramble - Randomizing data rowshttps://joellipman.com/articles/else/database/t-sql/datascramble-randomizing-data-rows.html

    What? Along with my DataJumble function and DataTumble procedure which also help scramble database tables sent to suppliers/developers, this is a function which simply finds random characters and inserts these. I would recommend using the DataTumble...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  16. Three boxes, two roll over, one falls outhttps://joellipman.com/articles/cms/website-development/css/three-boxes-two-roll-over-one-falls-out.html

    equalize method to make div layers the same height, and in this case, the same width. It isn't so much a miscalculation of 100% divided by 3 that leaves 1 pixel left over, more the fact that the scripts use that 1 pixel (ceiling rather than floor?)....

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *
  17. Zoho Cliq: Integrate OpenAI ChatGPT with Conversation Threadshttps://joellipman.com/articles/crm/zoho/zoho-other/zoho-cliq-integrate-openai-chatgpt-with-conversation-threads.html

    What? A quick follow-on article to my previous article on Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo. Why? Connecting to OpenAI ChatGPT is all very well and good, but this forgets what you were talking about after each chat. So it's good for 1...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  18. Prefix Line Numbers in a Text Filehttps://joellipman.com/component/content/article/prefix-line-numbers-to-a-text-file.html?catid=51&Itemid=165

    Intro Prefixing lines with their respective line number in a text file using a Microsoft Windows Operating System... I've just googled this as I couldn't remember how I did this last time and a number of people showing off their MS-DOS batch skills have...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: *
  19. Joe's Unduplicater (JUD)https://joellipman.com/component/content/article/joes-unduplicater.html?catid=53&Itemid=165

    If you need to remove files which are simply the converted versions of music or video files, then this tool asks which folder has the files it will keep and which ones it will send to the Recycle Bin. TESTED ON: - Windows XP, Windows 7 SCREENSHOTS:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  20. Joes Quicklist Weblinks (JQW)https://joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=53&Itemid=165

    having 50% opacity to start with when the page loads; when you hover the mouse cursor over it the thumbnail will regain 100% opacity. Target Window: Rokbox? Demo'd on my personal website because I am using a RocketTheme template but this should work if...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
Results 21 - 40 of 63