Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

07 September 2015 to not generate images) - Parameter: Select Thumbnail Service (allows me to add) - Date Uploaded: Mon, 25th Jul 2011 1.4- Retrieves website thumbnails on the fly or uses local images if they exist. (Note: This retrieves thumbnail from a service and...

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

ZohoCRM: ZDK Client Script to retrieve Contact Emailhttps://www.joellipman.com/articles/crm/zoho/zohocrm-zdk-client-script-to-retrieve-contact-email.html

20 July 2022 An article on one of my first client scripts for ZohoCRM. This retrieves and populates an email field based on when a contact is selected in a lookup field. Why? I could do a normal automation/workflow on save of the record, but the client wants the...

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

SSRS AlphaNumeric Parameter Validationhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-alphanumeric-validation.html

07 November 2011 in parameters and clicks on "View Report" Report passes parameter to dataset which gets formatted by the database Report retrieves (select) formatted parameter as a field value to use Report loads with changes based on returned value. The Gist Add...

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

Getting the mysql where in delimited string to workhttps://www.joellipman.com/articles/database/mysql/getting-the-mysql-where-in-delimited-string-to-work.html

02 January 2012 specifying the statement "WHERE IN (c.RoomImages)", this is interpreted as a string and when converted to a number only retrieves the first value before the first comma. Consider the following, the first query is how MySQL interprets the query and the...

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

Zoho Deluge: Sort a Map by a specific fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-sort-a-map-by-a-specific-field.html

29 January 2021 1997-07-05 23:15, 1977-11-14 12:30, 1923-10-16 15:00 This above snippet of code, loops through the sorted list of keys and retrieves each record as follows: {"name":"Amazing","id":335448,"date":"1997-07-05T23:15:00+00:00"}...

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

Zoho Creator: Receive eBay Order Notifications via Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 void API.fn_eBayQuery_GetNotificationPreferences() { /* Function: fn_eBayQuery_GetNotificationPreferences() Purpose: Retrieves the requesting application's notification preferences Date Created: 2021-09-20 (Joellipman.com - Joel Lipman) - Initial...

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

ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM recordhttps://www.joellipman.com/articles/crm/zoho/zohoflow-zohosign-retrieve-a-zoho-sign-document-request-and-add-attachments-to-crm-record.html

17 October 2022 describing a custom function built into Zoho Flow that will accept as parameter the document_id and request_id. It then retrieves the Deal Reference (entered by an office signee) on the ZohoSign document and searches for the relevant Deal record in CRM....

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

ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

06 March 2023 - Queries OpenAI ChatGPT Date Modified: 2023-03-11 (Joel Lipman) - Stores conversation messages / thread in CRM records - Retrieves and builds up conversation trail to send to OpenAI ChatGPT API...

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

Zoho Webhooks & Shopify API: Keep Disappearinghttps://www.joellipman.com/articles/crm/zoho/zoho-webhooks-shopify-api-automatically-restore.html

22 April 2024 crmAPIResponse. Don't overthink it, just accept it. Less headaches for everyone. Source(s): Shopify Dev - REST API - Retrieves a list of webhooks Shopify Dev - REST API - List of Webhook event topics Shopify Dev - REST API - HTTPS webhook delivery...

• 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 function onLoad () Label: CsfnShowSectionBasedOnPipeline Trigger: Client Script on Load of the Deal record page Purpose: Retrieves the pipeline of the deal record and hides/shows sections accordingly. Inputs: - Outputs: - Date Created: 2025-05-06 (Joel...

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