Zoho Workdrive: Getting Team Folder IDhttps://www.joellipman.com/articles/crm/zoho/zoho-workdrive-getting-team-folder-id.html

11 September 2024 6 - View 5 - Edit 3 - Organize 7 - Upload Error(s) Encountered: When updating members to a workdrive, I was getting errors such as 2945 Invalid JSON 2945 Invalid JSON for each v_RecipientEmail in l_WorkdriveRecipients { m_Header = Map();...

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

ZohoCRM / Client Script / Canvas: Hide Tab based on Pipelinehttps://www.joellipman.com/articles/crm/zoho/zohocrm-client-script-canvas-hide-tab-based-on-pipeline.html

06 May 2025 */ // clear the console so I can see what this script is doing (among all the zoho warnings/errors) console.clear(); // try and catch exception try { // get the record ID currently displayed var v_ThisRecordID = $Page.record_id; // get the record...

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

PHP Script: Make your own Thumbnail Generator via APIhttps://www.joellipman.com/articles/crm/zoho/php-script-make-your-own-thumbnail-generator-via-api.html

29 May 2025 & Logging • Ensure PHP can write to _origs and _thmbs. • Optionally monitor or rotate logs for download and processing errors.

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• 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 { v_Action = m_ResponseData.get("action"); } info m_ResponseData.get("code"); // // possible errors, output anyway b_Error = if(m_ResponseData.get("code").equalsIgnoreCase("SUCCESS"),false,true); if(b_Error) { info m_ThisInvoice.get("InvoiceNumber") +...

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

SSRS Display question mark when date is blankhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-display-question-mark-when-date-is-blank.html

15 April 2014 where's the problem? The problem Putting the date in an IIF (if-then-else) statement displays "#Error". You should get errors referring to converting strings to dates and incorrect data types. How? The fix is to simply get the field and both results to...

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

VBScript to retrieve Windows Product Keyhttps://www.joellipman.com/articles/microsoft/windows-os/vbscript-to-retrieve-windows-product-key.html

23 September 2015 key in Windows 7 with a small VB script file. There are other articles on the web about this but the ones I found returned errors such as WshShell not valid. This article has a working example applicable to Windows 7 Professional. Why? With the Windows...

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