ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://www.joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

05 December 2023 the "Image URL" column and select "Change Data Type" > select under Data Type: "URL" Right-click on the "Image URL" column again and select "Format Column" > Select under Display As: "Image" You can now specify the size of the image as well (16x16 is a...

• 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 failed to add the setParamName such as: f_CSVFile.setParamName("file"); 3700: Unable to upload a file. Please check and try again. If I test my connection or even change how I upload the file, this error no longer appears. This error seems to be at the...

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

Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

07 May 2024 pushing back too much, it can end up looking like those old websites with HTML tables. We're going to use a HTML table again but that's because I want to send it to the PDF renderer in ZohoCreator and want all the data to stay aligned. Using only DIV...

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

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

14 May 2024 An article to ensure I never spend this long on such a request again. The brief is: "Follow up when a lead is created and not converted within 1 day send an email and notification to sales person everyday for 3 days then escalate to a specified user"....

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

Zoho Analytics & Zoho People: Monitor DataSource Sync https://www.joellipman.com/articles/crm/zoho/zoho-analytics-zoho-people-monitor-datasource-sync.html

02 July 2024 Zoho People and Zoho Analytics. "; } v_Message = v_Message + " This may have been a one-off blip but if you get this error again tomorrow, you should raise this with either Zoho or your Zoho partner. This email will also have been copied to the ticket...

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

Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 ErrorCode: R6006 Message: Invalid signer info. Please try again with proper signer info. Solution: Recipients list was incorrect and I'd assigned the recipient twice. Scope(s): ZohoSign.documents.ALL, ZohoSign.account.ALL, ZohoSign.templates.ALL,...

• 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 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 from my...

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

ZohoCRM & Xero: Function to pull most recent invoiceshttps://www.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-invoices.html

09 October 2025 invoices. Why? This took me a whole afternoon so I wanted a template function I could use in future when I get this request again. The additional benefit of having this template is that it includes creating contacts, accounts, and products on-the-fly as...

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

Can't play music after Firmware Update Version 3.0https://www.joellipman.com/hardware/cant-play-music-after-firmware-update-version-30.html

21 September 2009 to the Sound System via Optical Out. I found that if you do enable the multi-audio output then you can play music again. What a bummer you can't play music and use anything else anymore. I can still play some games and select my own music... but they're...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

AutoHotkey Ternary Operatorhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-ternary-operator.html

27 April 2010 which I'll put in soon. I just needed something on my site now as I find myself looking for this bit of info every now and again.

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

First and Last Entry on a Page using Modulus Remainderhttps://www.joellipman.com/articles/web-development/php/first-and-last-entry-on-a-page-using-modulus-remainder.html

26 September 2011 mathematics table and it all makes sense (see my 10 mod table below). This article is a quick note (so I never spend as long again) in PHP on how to determine when looping through a loop, which entry was first and which was last. This is incredibly...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Reminder on SSRS row separatorhttps://www.joellipman.com/articles/microsoft/ssrs/reminder-on-ssrs-row-seperator.html

26 October 2011 Check that the grouping grey part (a giant parenthesis) is still there. Right-click on the grey header of the tablix row again (left-most grey part) Select "Insert Row" and I selected "Outside Group - Below". Done.

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

Mootools - How to contain a menu sidebar between header and footerhttps://www.joellipman.com/articles/web-development/mootools/mootools-how-to-contain-a-menu-sidebar-between-header-and-footer.html

10 August 2012 This has taken me too long to figure out and I hope I don't lose this note again. The only website that was titled similarly kept slowing down my computer too much so I decided to work out my own. The complexity is due to content also being dynamically...

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