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

05 December 2023 (zoho.com). Update 2023: This solution has been superceded by instead directing the ZohoTicket Attachment trigger (internal webhook in ZohoDesk rather than on Ticket Edit) and creates a row in a ZohoCreator report instead of ZohoAnalytics. The reason...

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

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

25 March 2024 Get current file name (optional) To check on filename changes, I run this bit of code to get the internal and current file name: // // get original document file (optional) - you need your own record ID here v_ZC_DocumentRecordID = 1234567890123456789;...

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

ZohoDeluge: eBay marketplace account deletion/closure notificationshttps://joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

13 March 2025 (e.g., GET https://?challenge_code=123). The provided endpoint URL must use the 'https' protocol and cannot include internal IP addresses or 'localhost'. Upon receiving the unique challenge code, the endpoint must hash the challengeCode,...

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

Zoho Survey: Zoho CRM Webhookhttps://joellipman.com/articles/crm/zoho/zoho-survey-zoho-crm-webhook.html

01 October 2025 who has permission to create functions Create a CRM function, I'm calling mine "Fn - Submit Suspect Survey - Webhook" with internal name as fn_SubmitSuspectSurvey_Webhook and the parameter is a string called crmAPIRequest Give it the following code:...

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

Mouseover Links in AutoHotkeyhttps://joellipman.com/articles/automation/autohotkey/mouseover-links-in-autohotkey.html

08 July 2011 it. Proper HTML mouseovers: When I have a more stable solution. I would however recommend cwebpage.dll at as a minimum for internal HTML pages for use in an AutoHotkey GUI.

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

Drop If Object Existshttps://joellipman.com/articles/database/t-sql/drop-if-object-exists.html

03 August 2012 FS = Assembly (CLR) scalar-function FT = Assembly (CLR) table-valued function IF = SQL inline table-valued function IT = Internal table P = SQL Stored Procedure PC = Assembly (CLR) stored-procedure PG = Plan guide PK = PRIMARY KEY constraint R = Rule...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Zoho Projects: Deluge to Submit Custom Fieldshttps://joellipman.com/articles/crm/zoho/zoho-projects-deluge-to-submit-custom-fields.html

17 June 2021 m_Custom = {"UDF_CHAR8":12345678901234567,"UDF_CHAR7":"Joel Lipman"}; m_Params = { "name": "My Happy Project", "flag": "internal", "milestone_id": 98765432109876540, "tasklist_id": 78901234567890130, "person_responsible": "20211234567", "duration": "1",...

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