Licence GNU/GPLhttps://www.joellipman.com/static-items/licence-gnugpl.html

03 April 2009 work, the recipient automatically receives a license from the original licensors, to run, modify and propagate that work, subject to this License. You are not responsible for enforcing compliance by third parties with this License. An “entity...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

T-SQL concatenate an incremental row numberhttps://www.joellipman.com/articles/database/t-sql/t-sql-concatenate-an-incremental-row-number.html

24 May 2013 Surname 1 Joel Lipman 2 Another Joe TABLE: Qualifications -------------------------------------------------- ID Employee Subject Grade 1 001 Computer Science BSc 2.1 2 001 Superman 10/10 3 002 Tape-Monkey Engineer 1:0 So based on this logic, the...

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

Windows Live Mail Error ID: 0x8DE00005https://www.joellipman.com/articles/microsoft/windows-os/windows-live-mail-error-id-0x8de00005.html

14 December 2016 the new account will have all your mail. The error Unable to send or receive messages for the Hotmail (someone) account. Subject 'your Microsoft Issue' Server Error: 3219 Windows Live Mail Error ID: 0x8DE00005 Unable to send or receive messages for the...

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

Zoho Deluge: Search Records with Special Characters (COQL)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

28 August 2020 reliable enough I have found to work each time is using the CRM Object Query Language or Zoho's COQL. Similar to SQL but subject to similar issues of escaping special characters... 1. Setup a CRM Connection to Search Records via API I won't go into...

• 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 as a test but remember to remove this before going Live. sendmail [ from :zoho.adminuserid to :"info@joellipman.com" subject :"TEST ebay Webhook Notification" message :m_Payload ] */ return r_CreateRecord; Save the function While still on the CRM...

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

Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attachhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-writer-button-to-merge-template,-send,-and-attach.html

21 October 2021 = v_OutputMessage + "Generated and attached file to CRM record. "; } // // to generate and send via email m_MergedData.put("subject","Document for " + r_ContactRecord.get("Salutation") + " " + r_ContactRecord.get("Last_Name"));...

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

Zoho CRM: Schedule a Call using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-call-with-deluge.html

18 November 2021 m_ScheduleCall.put("Owner",v_LeadOwnerID); m_ScheduleCall.put("What_Id",v_LeadID); m_ScheduleCall.put("Subject","Scheduled Call with " + v_CustomerName); m_ScheduleCall.put("Call_Start_Time",v_SystemAppointmentDateTimeStart);...

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

Zoho CRM: Schedule a Meeting using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-meeting-using-deluge.html

02 March 2022 example, a lead record but can be almost any kind of record) m_ScheduleMeeting.put("What_Id",98765432109876543); // // the subject m_ScheduleMeeting.put("Event_Title","TEST Consultation: Call with TEST LEAD"); // // the description...

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

Amazon Kindle: Send PDFs to your Kindlehttps://www.joellipman.com/amazon/kindle/amazon-kindle-send-pdfs-to-your-kindle.html

29 June 2022 Also, you can send multiple PDF files at the same time, as it is with any email client. You can also use ‘Convert’ as the subject and send it to Kindle. The file gets automatically converted to the Kindle format. Fix for PDF file now showing on the...

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

Zoho Books/Inventory: Trigger a workflow when an invoice has been paidhttps://www.joellipman.com/articles/crm/zoho/zoho-books-inventory-trigger-a-workflow-when-an-invoice-has-been-paid.html

17 August 2022 evidence that the workflow was triggered and ran this function sendmail [ from :zoho.adminuserid to :"info@joellipman.com" subject :"Client Test: ZB: Payment Received for Invoice " + v_InvoiceRef message :"Workflow was executed and function ran:...

• 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 info r_Attach; // // to send this as an email as well sendmail [ from :zoho.adminuserid to :"info@joellipman.com" subject :"ZohoSign Test - Request: " + v_RequestId + " - Document: " + v_DocumentId message :"Please find attached your requested...

• 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 modification of your data. That being said, it's important to note that the use and distribution of trained models may be subject to legal or ethical considerations, depending on the nature of the data and the intended use of the model. Therefore, if...

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

Zoho Creator: Sendmail a list of attachmentshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-send-mail-a-list-of-attachments.html

20 July 2023 l_Downloads.add(r_Download2); // sendmail [ from: zoho.adminuserid to: "info@joellipman.com" subject: "Test File: List" message: "This is just a test" attachments: file: l_Downloads ] } Yields

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

Zoho Deluge and Wordpress/WooCommerce API: Get All Productshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-and-wordpress-woocommerce-api-get-all-products.html

15 April 2024 + ".json"); // // send this to us via email sendmail [ from :zoho.adminuserid to :"me@joellipman.com" subject :"All Products from " + v_MyWordPressSiteUrl + " as of " + zoho.currenttime.toString("yyyy-MM-dd HH:mm:ssXXX") message :"Please see the...

• 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 } /* // sendmail [ from :zoho.adminuserid to :"me+DEBUG_SHOPIFY_EXAMPLE@joellipman.com" subject :"CLIENT Payload and Hash Comparison" message :v_VerifyHash + " " + v_ShopifyHash + " " + m_Payload.toString() ] // // to cut even more time, we could store...

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

Zoho Analytics: Create a Monitoring System with Imageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-create-a-monitoring-system-with-images.html

25 July 2024 AS "Record Owner", img5."ZohoAnalytics Image URL" AS "Status Image" FROM ( SELECT tsk."Id" AS "RecordID", tsk."Subject" AS "RecordName", tsk."Task Owner Name" AS "RecordOwner", tsk."Modified Time" AS "ModifiedTime", if(to_date(tsk."Modified Time") >...

• 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 " + zoho.currenttime; // if(b_DebugMode) { sendmail [ from :zoho.adminuserid to :"me+DEBUGZOHOSIGNWEBHOOK@joellipman.com" subject :"My ZohoSign Webhook - ANY EVENT" message :v_DebugMessage ] } return ""; Related List for Custom Module Just for good...

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

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

13 March 2025 + " "; // v_StatusCode = 200; // v_To = ""; l_bcc = List({}); // sendmail [ from :zoho.loginuserid to :v_To bcc: l_bcc subject :v_Topic message :v_Message ] } catch(e) { v_StatusCode = 403; } // m_PayloadResponse = Map();...

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

Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://www.joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

25 September 2025 file to CRM record. "; } } // // send to an email for testing /* sendmail [ from :zoho.adminuserid to :v_ContactEmail subject :"Radar Chart for " + v_ViewName message :"See attached" Attachments :file:f_ChartExport ] */ // return "The function executed....

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

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

01 October 2025 " + r_CreateContact; } /* OPTIONAL: Send yourself an email sendmail [ from :zoho.adminuserid to :"me@mycompany.com" subject :"TEST: Survey has been submitted" message :crmAPIRequest ] */ // // build response to Zoho Survey (hard-coded a ok)...

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