PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://www.joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

12 March 2022 5 monitors working with only 1 graphics card. Why? This took me a good few hours to get working so I thought this article could help others. It's also a chance to show off my build. Although not high budget like lots of YouTubers I drew inspiration and...

• Type: Article
• Author: Joel Lipman
• Category: Articles
• Language: *

Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 Lighting Sunbeams X-Ray Volumetric Lighting Famous Artist Styles I've tried to list artists here who have styles that I could not generate using the above keywords/tokens. Usage:...in the style of... Note that some of these may verge on Copyright...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkithttps://www.joellipman.com/articles/crm/zoho/zoho-email-deliverability-spf-dkim-dmarc-toolkit.html

04 May 2023 this setup involves creating the TXT records on the DNS. Ideally, we would not want access to the DNS as Zoho Support as we could be blamed for any website / mail server issues not related to any of this setup / configuration. Instead, we prepare the...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Determine if Daylight Savings are in effecthttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-determine-if-daylight-savings-are-in-effect.html

03 July 2023 this works. Why? I've covered this before in a fair few articles on this website but for clients in the US, where there could be 4 different timezones between customer, agent, HQ, server; we would create a separate table to manage this data. I can't do...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Get the Week Number if Week starts on a Mondayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-the-week-number-if-week-starts-on-a-monday.html

06 July 2023 I had this formula which seemed to do the same thing but unnecessarily moved the pointer to the start of the week. It could also error eventually if Zoho made it possible to change the start of the week (this is in ZohoCreator; I'm aware that some of...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Find Duplicates by Customer Name for Large Datasetshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-find-duplicates-by-customer-name-for-large-datasets.html

12 July 2023 is changed to remove every instance of the "distinct" list, then I'll have to come up with a different solution. Maybe Zoho could introduce a removeFirst() if they change removeAll().. The number of duplicates may easily differ to the loop of...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Get Images in Report to be Exported to PDFhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-get-images-in-report-to-be-exported-to-pdf.html

26 January 2024 + v_PublishKey + "?filepath=/" + v_DocFileName; // // Store the link to the local file as the local image - this is where we could check on file extension and substitute with PDF, DOC, XLS extensions c_Document.Local_Image = ""; info "File: " +...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCreator: Using .toFile and Uploading to a Creator fieldhttps://www.joellipman.com/articles/crm/zoho/zohocreator-using-tofile-and-uploading-to-a-creator-field.html

25 March 2024 use by a dynamic auto-suggester dropdown; one of those fancy ones that includes photos and a bit of fuzzy logic. I thought I could simply update the field with the new file but as I'm not downloading it, this is apparently not the process. How? As a...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Books / Inventory: Get Item Rate from a Price Book/Listhttps://www.joellipman.com/articles/crm/zoho/zoho-books-inventory-get-item-rate-from-a-price-book-list.html

23 May 2024 sales order is created to do some further calculations based on a surcharge rate held in a custom module. The custom module could only be created in Zoho Books at time of print but Zoho Inventory is where our workflow and code is sitting right now. The...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoAnalytics & ZohoBooks: Custom Related List from Analyticshttps://www.joellipman.com/articles/crm/zoho/zohoanalytics-zohobooks-custom-related-list-from-analytics.html

09 July 2024 so."Sales order ID" LEFT JOIN "Sales Order Items" soi ON so."Sales order ID" = soi."Sales order ID" Initially we thought we could take the purchase order by simply going through the comments but this only shows Purchase Orders raised from a Sales Order...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Analytics: Create a Monitoring System with Imageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-create-a-monitoring-system-with-images.html

25 July 2024 browser tab if using Google Chrome and select "Duplicate"). I then arranged the two browser windows side-by-side so that I could copy the image address from the library to the 2nd column in my data table. So in the duplicate browser, go to modify a...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Input Color Pickerhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-input-color-picker.html

14 October 2024 hexadecimal color references and Red Green Blue (RGB) values is somewhat difficult. What would be nice-to-have is if they could be presented with a bunch of colors and they click on one to select it. When are colors used? Well in this use-case, we are...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

MacOs: Transcribe Training Video using OpenAI Whisperhttps://www.joellipman.com/articles/apple/macos-transcribe-training-video-using-openai-whisper.html

23 June 2025 prompt: rephrase the following so that it makes sense to a trainee: "" // wait for completion and if paragraph 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...

• Type: Article
• Author: Joel Lipman
• Category: Apple
• Language: *

Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

18 August 2025 */ // // initialize v_AccountID = ""; v_Output = "Error: Could not retrieve given CRM Account ID"; // // ****************************** GENERIC CODE BELOW ****************************** // // retrieving the parameters of the request m_RequestParams =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

404: Page Not Foundhttps://www.joellipman.com/static-items/404.html

11 February 2015 Sorry, but the content you requested could not be found. It is possible that you have followed an out-of-date link or incorrectly typed an address. We have revamped this website as of September 2015 and tidied up some of our URLs. Some sections will...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Hide Menu Item from Registered and Special https://www.joellipman.com/articles/cms/joomla/hide-menu-item-from-registered-and-special.html

06 September 2009 at this date/time. Can't simply hide an item but can hide a menu (of course the menu could have been created with just one item with no title and positioned at the bottom of another menu; this would look like it was all part of one menu). toubkal wrote:...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Outputting PHP files into different file formatshttps://www.joellipman.com/articles/web-development/php/outputting-php-files-into-different-file-formats.html

12 February 2010 to get PHP output to create a text file. Then my client showed me how she then opens the text file in Excel, so I said we could get the script to do that instead. PHP to TXT header('Content-Type: text/plain; charset=utf-8'); header('Content-Disposition:...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Increment a column in MySQL using the UPDATE queryhttps://www.joellipman.com/articles/database/mysql/increment-a-column-in-mysql-using-the-update-query.html

18 February 2010 1 to counter_field_value UPDATE table1 SET counter_field_value= WHERE column1='this_article' Combined with a PHP script this could be a few lines for something really small. The quick trick to this is to do it all in one query: UPDATE table1 SET...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

If Then Else in Report Builder 2.0 Expressionshttps://www.joellipman.com/articles/microsoft/ssrs/if-then-else-in-report-builder-20-expressions.html

06 May 2010 Yes, well don't laugh, I could not find this on the WWW so I was obviously not using Google properly. Anyway here's just a quick note on how to do if else statements in Report Builder 2.0 I'm looking at the following if statement: If (MyFieldName = 0)...

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

Strip HTML in MySQLhttps://www.joellipman.com/articles/database/mysql/strip-html-in-mysql.html

06 December 2011 old content to a new system. From a MediaWiki CMS to a SaaS called Service-Now. The previous interlinking between images could no longer be used. How? There were a few functions out there. One called "strip_tags" crashed in the running of the query. The...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB