GoDaddy Apache cPanel: Install SSL Certificatehttps://joellipman.com/articles/linux/cpanel/godaddy-apache-cpanel-install-ssl-certificate.html

07 April 2022 Opened the first certificate file (the one with numbers, letters with extension CRT), copied the contents to clipboard then pasted under "Install an SSL Website" into the "Certificate" textarea field. Duplicated the tab and went to the SSL/TLS page in...

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

SSRS Expand specific drilldown by defaulthttps://joellipman.com/articles/microsoft/ssrs/ssrs-expand-specific-drilldown-by-default.html

23 February 2011 thought I'd put something here as there are lots of posts like this on forums (a lot of which seem to be copied & 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...

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

MS Excel - Split Workbook into separate files per sheethttps://joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

11 February 2019 example, this will produce an extra 12 worksheets in this file. Using the above module, overwrite the code you previously pasted with the below (note the file format for Excel 97-2003): Sub Splitbook() Dim xPath As String xPath =...

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

Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Divhttps://joellipman.com/articles/crm/zoho/zoho-creator-page-toggle-on-off-switch-hide-display-a-div.html

22 October 2020 are read by Zoho and certain CSS attributes (such as position and float) will be removed automatically. The code has to be pasted directly in the Page and then the CSS attributes will remain. Preview the Code The code below can be changed to suit your...

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

Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://joellipman.com/articles/crm/zoho/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

19 September 2021 First - Off: The one workflow to rule them all In the first instance, we don't want large amounts of code to be copied and pasted for each field, especially if they're doing the same thing for example displaying a preview in a notes field. We would...

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